Child list for field " " cannot be created

Question

I have the following set of codes for adding values to my DataGridView through DataTable as my datasource. However, it keeps on giving me the error "Child list for field tbl_main cannot be created". Anybody can help me identify the problem?

dgvMySchedule.Columns.Clear();
dgvMySchedule.Rows.Clear();
dgvMySchedule.ClearSelection();

dataSet.Tables.Add(tbl_main);
dgvMySchedule.DataSource = dataSet;
dgvMySchedule.DataMember = "tbl_main";

tbl_main.Columns.Add("TIME");
tbl_main.Columns.Add("CLASS");

DataRow row;
dgvMySchedule.RowTemplate.Height = 8;
for (int i = 0; i <= 71; i++)
{
    row = tbl_main.NewRow();
    row["TIME"] = i;
    row["CLASS"] = i;
    tbl_main.Rows.Add(row);
}

Why are you creating a dataset for one table? Anyway you still need to add the created row to the table and rebind it. — Poody, Oct 31 '16 at 09:00

Peter B · Answer 1 · 2016-11-01T08:26:00.347

3

It looks like your tbl_main is unnamed, or it has a different name than "tbl_main". There are three possible solutions:

Remove the DataSet, instead use dgvMySchedule.DataSource = tbl_main;
If you need/want the DataSet, add tbl_main.TableName = "tbl_main";
If you need/want the DataSet, remove the line saying dgvMySchedule.DataMember = "tbl_main" (the grid will then automatically use the one DataTable present).

edited Nov 01 '16 at 08:26

answered Oct 31 '16 at 09:06

Peter B

22,460
5
32
69

hi! I finally realized my mistake. I forgot to initialize my datatable during declaration. I used DataTable tbl_main = new DataTable(); instead of DataTable tbl_main = new DataTable("tbl_main"); The changes pretty much answered my concern. Thank you! – Amore Nov 01 '16 at 03:10

score 1 · Accepted Answer · answered Nov 01 '16 at 03:12

1

I finally realized my mistake. I forgot to initialize my datatable during declaration. I used DataTable tbl_main = new DataTable(); instead of DataTable tbl_main = new DataTable("tbl_main"); The changes pretty much answered my concern. Thank you!

answered Nov 01 '16 at 03:12

Amore

101
3
11

please mark this as the answer so that this question wont linger as an open ended question. – Nap Jun 04 '18 at 00:20

score 0 · Answer 3 · answered Jun 04 '18 at 00:09

0

I had this problem using binding in winforms. I had set binding to a non existent field name.

answered Jun 04 '18 at 00:09

Kirsten

15,730
41
179
318

Child list for field " " cannot be created

3 Answers3