C# DataGridView data-bound error with Grid.Rows.Add method

Question

i have a DataGridView on the Form. I select some data from database and load them to datatable and after that i make reference this datatable to grid's datasorurce as below.

string sql = "";
sql = "SELECT id,name,surname,code FROM t_persons";
DataTable dt = new DataTable();
...
adapter.Fill(dt);
grid.DataSource = dt;

and after that i want to add new row to this grid with grid.Rows.Add() method. But every time it gives an error Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.
So whatis the problem and how can i solve it.

Solve it by adding a row to the DataTable (isn't the exception self-explanatory?). — Tim Schmelter
– Tim Schmelter, Commented Aug 23, 2012 at 8:54

Vale · Accepted Answer · 2012-08-23 08:55:06Z

2

You should add row to the DataTable, not to the DataGridView. That is what the exception is saying. Try:

DataRow newRow = dt.NewRow();
dt.Rows.Add(newRow);

answered Aug 23, 2012 at 8:55

Vale

3,2982 gold badges29 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vikram Jain · Accepted Answer · 2012-08-23 08:55:23Z

1

Please you can add row directly to datatable and it's effect on gridview because it's bind to datatable.

answered Aug 23, 2012 at 8:55

Vikram Jain

5,6081 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

C# DataGridView data-bound error with Grid.Rows.Add method

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related