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

Question

1.00/5 (1 vote)

See more:

I am getting data from database in manually created column of datagridview,When i get data from database and i try to add row in that datagridview it cause error as i mention in title.This is my code.

What I have tried:

C#

int col = dataGridView1.CurrentCell.ColumnIndex;
int row = dataGridView1.CurrentCell.RowIndex;
                
if (dataGridView1.CurrentRow.Index+1 == dataGridView1.Rows.Count)
{
   if (col < dataGridView1.Columns.Count - 1)
   {
      dataGridView1.CurrentCell = dataGridView1.Rows[row].Cells[col + 1];
      dataGridView1.Focus();
   }
   else if (col == dataGridView1.Columns.Count - 1)
   {
      dataGridView1.Rows.Add(1);
      dataGridView1.CurrentCell = dataGridView1.Rows[row].Cells[1];
      dataGridView1.Focus();
   }
}

Posted 5-Oct-19 0:12am

Member 13608869

Updated 5-Oct-19 10:07am

Nelek

v3

Add a Solution

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)

phil.o · Answer 1 · 2019-10-05T00:25:00

Your datagridview is data bound, it means that it constructs itself from the datasource you provide to it.
You have two solutions:

Either you strip off the data binding and do the boilerplate code yourself.
Or you add a new record to the datasource and refresh the gridview => it will update itself with the new row.

OriginalGriff · Answer 2 · 2019-10-05T00:27:00

Solution 2

When you link a data source such as a List or a DataTable to a DataGridView, you cannot add rows directly to the DGV, because that would leave it out of sync with it's data source, and it wouldn't "know" what to display when - or what to update the Database with should you require that.

Instead, update the datasource: add items to your List, or DataRows to your DataTable and invalidate the control to update the display if necessary.

Posted 5-Oct-19 0:27am

OriginalGriff

Comments

Member 13608869 5-Oct-19 6:42am

sir i am using same gridview for insert update and display. for e.g i firstly insert 3 rows of data in datagridview and save it into database then i want to update it i use display command for getting data in datagridview, i get 3 rows in datagridview which i insert in database.Now i want to insert one more row and want to update it by same datagridview.