I am new to vb.net so please bear with me . I would like to know is it possible to load ms access tables in datagridview and open selected table in another datagridview just like opening a selected table using combo box?
can someone provide me with a sql statement . when I run the sql I get the following error
Could not find file 'C:\Documents and Settings\user\My Documents\Visual Studio 2010\Projects\winform1\bin\Debug\INFORMATION_SCHEMA.mdb'.
my full code
Dim con As New OleDbConnection(" Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\msacc.accdb")
Dim Query2 As String ="Select * from INFORMATION_SCHEMA.TABLES where table_name like 'E%'"
Dim Da As OleDbDataAdapter, Ds As New DataSet, Dtb As New System.Data.DataTable
con.Open()
Da = New OleDbDataAdapter(Query2, con)
Da.Fill(Ds)
con.Close()
Dtb = Ds.Tables(0)
DataGridView1.DataSource = Dtb