Child list exception

[dave]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"dave" <da**@discussions.microsoft.com> wrote in message
news:E5**********************************@microsof t.com...

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