1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Dim cnn As New System.Data.OleDb.OleDbConnection
Dim da As New System.Data.OleDb.OleDbDataAdapter
Dim TheDataSet As New DataSet
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Me.TextBox1.Text & ";Extended Properties=dBASE IV;User ID=Admin;Password="
Try
cnn.Open()
da.SelectCommand = New System.Data.OleDb.OleDbCommand("select * from " & Me.TextBox2.Text, cnn)
da.Fill(TheDataSet)
'MsgBox(TheDataSet.Tables(0).Rows.Count)
DataGridView1.DataSource = TheDataSet
DataGridView1.Refresh()
Catch ex As Exception
MsgBox("Erreur de connection à la Database." & vbNewLine & ex.Message)
End Try |