1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Module Module1
Dim con_strg As String = "Data Source=nomduserverdistant;Initial catalog=nomdelabase;Integrated Security=SSPI"
Sub ChargeTable(ByVal requeteSQL As String, ByVal TableName As String, ByVal NomDataSet As System.Data.DataSet)
Dim con As New SqlConnection()
Dim sqlda As SqlDataAdapter
con = New SqlConnection(con_strg)
con.Open()
sqlda = New SqlDataAdapter(RqtCtc, con)
Try
' Récupération des données dans une table nomtable
sqlda.Fill(DatasetCtc, TableName)
Catch ex As Exception
MsgBox(ex.ToString)
Finally
con.Close()
End Try
End Sub[
end module |