Dim CNX_Str As String = "Data Source=.\SQLEXPRESS;Initial Catalog=MaTable;Integrated Security=SSPI" Dim CMD_Str As String = "SELECT * FROM Matable" ' Dim SQL_Connex As SqlConnection Dim SQL_cmd As SqlCommand ' Try ' SQL_Connex = New SqlConnection(CNX_Str) SQL_cmd = New SqlCommand(CMD_Str, SQL_Connex) ' SQL_Connex.Open() ' Dim BS As New BindingSource BS.DataSource = SQL_cmd.ExecuteReader DataGridView1.DataSource = BS ' Catch ' MessageBox.Show("Une erreur est survenue durant la connexion", _ "Erreur de connexion", _ MessageBoxButtons.OK, _ MessageBoxIcon.Exclamation) ' If SQL_Connex IsNot Nothing AndAlso _ SQL_Connex.State <> ConnectionState.Closed Then SQL_Connex.Close() SQL_Connex.Dispose() End If ' End Try
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim SQL_Connex As SqlConnection' Déclare la connexion Dim SQL_cmd As SqlCommand ' Try ' SQL_Connex = New SqlConnection(CNX_Str) 'Instancie la connexion
Dim SQL_Connex As New SqlConnection Dim SQL_cmd As SqlCommand ' Try ' SQL_Connex = New SqlConnection(CNX_Str) 'Instancie la connexion
Try ' Dim SQL_Connex As New(CNX_Str)
Dim SQL_Connex As New SqlConnection = Nothing Dim SQL_cmd As SqlCommand = Nothing ' Try ' SQL_Connex = New SqlConnection(CNX_Str) 'Instancie la connexion