Torna al Thread

Private Sub ConnettiToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ConnettiToolStripMenuItem.Click Dim isAvailable = My.Computer.Network.IsAvailable 'Rilevo se la connessione a internet esiste If isAvailable Then 'Creo un Dataadapter per il server con Tabella INBOX Dim ServerDataAdapter As New OleDbDataAdapter() ServerDataAdapter.SelectCommand = New OleDbCommand() ServerDataAdapter.SelectCommand.Connection = Connessione_server ServerDataAdapter.SelectCommand.CommandText = "SELECT * FROM INBOX" ServerDataAdapter.SelectCommand.CommandType = CommandType.Text Connessione.Open() 'Inserisco le intestazioni nel dataset ServerDataAdapter.Fill(DataSet, "INBOX") 'Chiudo la connessione con il Database Connessione.Close() 'Creo un dataadapter per il DB contentente la tabella Numeri Dim SmsPanel As New OleDbDataAdapter() SmsPanel.SelectCommand = New OleDbCommand() SmsPanel.SelectCommand.Connection = Connessione_server SmsPanel.SelectCommand.CommandText = "SELECT * FROM numeri" SmsPanel.SelectCommand.CommandType = CommandType.Text Connessione.Open() 'Inserisco le intestazioni nel dataset ServerDataAdapter.Fill(DataSet, "numeri") 'Chiudo la connessione con il Database Connessione.Close() End If End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5