Assigning value to tablecell?

Question

Hello, I'm trying to change a value in a datatable and I cannot get it working, does anyone have any ideas of why? Thank you.

DataTable table;

-- inserting values into the datatable --

table.rows[1].ItemArray[1] = null; //This is not working, I cannot assign the cell any value

Vulpes · Answer

Instead of using ItemArray which may only work if you set the values for the whole row, I'd use this syntax: table.Rows[1][1] = null; // or DBNull.Value

Mats A · Answer

Hello, I resolved the assignment using data_table_global.Rows[current_row][current_col] = and it works fine. Thread resolvet, thank you DBNull .Value;

Sam Hobbs · Answer

You cannot change a row if the row does not exist. You need to add a row first. The row must have the correct fields for the row. All of that can be more work than you are hoping for. Is this data that will be stored in a table in a database? If so then the easiest way to do this is to create a TableAdapter. If it is not for a table in a database, then probably the easiest way is to use the dataset designer to create a DataSet for the table.

Suthish Nair · Answer

Mats, thread resolved? Remember to use method dtTable.AcceptChanges(); after updations.

Assigning value to tablecell?

Answers (4)