Child list exception

[Guest]

Hello:

I'm trying to connect "DataGridView" to ".MDB" file
from the code:

string connectionString =
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\file.MDB";

OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();

DataGridView1.DataSource = connection.DataSource;
DataGridView1.DataMember = "tblTime;

When execution get to the line:
"DataGridView1.DataMember = "tblTime".ToString(); "

There is exception:

"Child list for field tblTime cannot be created."


Does somebody know what i'm doing wrong ?

thank you,
dave

 

[Nicholas Paldino [.NET/C# MVP]]

dave,

The problem here is that you are trying to set the data source to the
connection. You can't do this. You have to assign a connection to a
dataadapter and then fill a dataset with that information. Then, you can
bind the data grid to the data set.

Hope this helps.