4

I have a very simple C# DataTable problem that I cannot seem to wrap my head around; it seems so strait forward but I must be missing something.

I was hoping that someone could explain to me why I'm unable update a cell value in a DataTable like shown below:

Code:

    DataTable t = new DataTable();
    t.Columns.Add("MyCol");
    t.Rows.Add("old value");
    t.Rows[0].ItemArray[0] = "new value";
    t.AcceptChanges();
    dataGridView1.DataSource = t;         //did not work. still reads "old value"

Any help would be appreciated! thanks!

Chromex
  • 43
  • 1
  • 3

3 Answers3

7

Simply change:

t.Rows[0].ItemArray[0] = "new value";

to

t.Rows[0][0] = "new value";

That's it!

EDIT (Added explaination):

Changes to ItemArray elements are not tracked, so no changes are reflected in the datatable values (code in the original question)

However you can use ItemArray to change all the row at once, like this:

t.Rows[0].ItemArray = new object[] {"new value"};

In this case the changes are tracked, and you get the expected result.

JotaBe
  • 38,030
  • 8
  • 98
  • 117
  • dude!!!! that totally works! thanks so much! Any idea why Rows[][] works but Rows[].ItemArray[] doesn't? – Chromex Mar 22 '12 at 01:23
1

To answer you question

you should do like this

  t.Rows[0].ItemArray = new object[] { "new value" };

according to MSDN,

You can use this property to set or get values for this row through an array. If you use this property to set values, the array must have the same size and ordering as the column collection. Passing null in the ItemArray indicates that no value was specified.

Turbot
  • 5,095
  • 1
  • 22
  • 30
0

Have you tried the following? 


...
dataGridView1.DataSource = null; // set it to null before it set to a new one.
dataGridView1.DataSource = t;
Chansik Im
  • 1,473
  • 8
  • 13