Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.

Question

0.00/5 (No votes)

See more:

Hello,

I am using this code for display items in datagridview using datatable. but it's showing error:-
Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.

C#

for (int i = 0; i < dt.Rows.Count; i++)
           {
               dgvDisplayTiles.Rows.Add();
               dgvDisplayTiles.Rows[i].Cells[0].Value = dt.Rows[i][0].ToString();
               dgvDisplayTiles.Rows[i].Cells[1].Value = dt.Rows[i][1].ToString();
               dgvDisplayTiles.Rows[i].Cells[2].Value = dt.Rows[i][2].ToString();

               Bitmap img = new Bitmap(Application.StartupPath + "\\ " + dt.Rows[i][3].ToString());
               dgvDisplayTiles.Rows[i].Cells[3].Value = img;

               try
               {
                   Bitmap img3 = new Bitmap(Application.StartupPath + "\\ " + dt.Rows[i][4].ToString());
                   dgvDisplayTiles.Rows[i].Cells[4].Value = img3;
               }
               catch (Exception ex)
               {
                   Bitmap img3 = new Bitmap(Application.StartupPath + "\\Library\\NoTiles.png");
                   dgvDisplayTiles.Rows[i].Cells[4].Value = img3;
               }

           }
           dgvDisplayTiles.AutoGenerateColumns = false;
           dgvDisplayTiles.DataSource = dt;

Please help me.

Thanks in Advance.

Ankit Agarwal
Software Engineer

[edit]Empty Space added after \\ to avoid escaped quotes and the mess of code format[/edit]

Posted 10-Dec-13 20:09pm

ankit.agg1984

Updated 10-Dec-13 23:33pm

Nelek

v4

Add a Solution

Comments

jing567 11-Dec-13 3:34am

Hello,
Its not right way to add a row to directly to Datagrid.... Try adding a row to the dataSource(Datatable or Dataset) and then try to bind the DataTable to that Grid View...

For Example":
dgvDisplayTiles.ItemSourc=DataTable;(DataTable is source)

Then Add a Row to the DataTable and the give the source to the Grid view...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jing567 · Answer 1 · 2013-12-10T21:34:00

Hello, Its not right way to add a row to directly to Datagrid.... Try adding a row to the dataSource(Datatable or Dataset) and then try to bind the DataTable to that Grid View...

For Example":

C#

dgvDisplayTiles.ItemSourc=DataTable;(DataTable is source)

Then Add a Row to the DataTable and the give the source to the Grid view...

BobJanova · Answer 2 · 2013-12-10T23:01:00

Solution 2

Simply put you don't need to do this at all, setting the DataSource should populate the grid.

If you want to implement custom logic in generating the column values, you should hide the DataTable behind a converter which implements IBindingSource and exposes the appropriate columns.

Posted 10-Dec-13 23:01pm

BobJanova