Databinding to a programmaticly created DataTable

Question

Suppose I have a datatable like this:

        DataTable dt = new DataTable("Woot");

        dt.Columns.AddRange(new DataColumn[]{
            new DataColumn("ID",typeof(System.Guid)),
            new DataColumn("Name",typeof(String))
            });

When I try to bind a control to it:

        this.txtName.DataBindings.Add("Text", _dtRow, "Name");

I get this exception:

Cannot bind to the property or column Name on the DataSource. Parameter name: dataMember

Any idea why this works on a datatable created by a dataAdapter, but not on a programmaticly created one?

Answer 1

shouldn't you reference dt instead of _dtRow?

For example:

this.txtName.DataBindings.Add("Text", dt, "Name");

EDIT:

This code worked for me:

   DataTable dt = new DataTable("Woot");

    dt.Columns.AddRange(new DataColumn[]{
        new DataColumn("ID",typeof(System.Guid)),
        new DataColumn("Name",typeof(String))
    });

    DataRow r = dt.NewRow();
    r["ID"] = new Guid();
    r["Name"] = "AAA";
    dt.Rows.Add(r);

    r = dt.NewRow();
    r["ID"] = new Guid();
    r["Name"] = "BBB";
    dt.Rows.Add(r);

    dataGridView1.DataSource = dt;

    this.txtName.DataBindings.Add("Text", r.Table , "Name");

Answer 2

OK, after messing with your code for a while, I kept getting stumped. Then I finally realized the issue. I'm assuming _dtRow is a DataRow. You need to reference the actual DataTable (dt).

this.textBox1.DataBindings.Add("Text", dt, "Name");

EDIT: After seeing your comment on Igor's post. If you bind to dt, then say for example if you have a datagridview bound to this DataTable, every time you select a different row, the textbox will change.

Here's the code that works for me:

            DataTable dt = new DataTable("Woot");

            dt.Columns.AddRange(new DataColumn[]{
            new DataColumn("ID",typeof(System.Guid)),
            new DataColumn("Name",typeof(String))
            });


            dt.Rows.Add(Guid.NewGuid(), "John");
            dt.Rows.Add(Guid.NewGuid(), "Jack");

            this.dataGridView1.DataSource = dt;

            this.textBox1.DataBindings.Add("Text", dt, "Name");

Change rows in the DGV and you'll see the textbox change text.

EIDT AGAIN OK, time to hack it. This is how I got it to work:

this.textBox1.DataBindings.Add("Text",_dtRow.ItemArray[1], "");

I used index 1, but you can use whatever index you need in the array.