deleting rows in a datagridview

Question

0.00/5 (No votes)

See more:

I have a DGV that houses items to be place on a order. The items were entered by the user
and are not bound to any source table. I can add/change items rows in the DGV. I can delete rows
and the DGV adjusts itself accordingly.
Example: I have seven rows in the DGV the rows are numbered 1-7
I delete row 2
The row disappears. The rows are now numbered 1-6
If I attempt to delete what is now row 2 it gets an exception error
stating I can not access a deleted row.
Any ideas on how to best resolve this problem.

Posted 10-Jan-14 4:55am

myavo

Add a Solution

Comments

bowlturner 10-Jan-14 11:31am

My first question would be are the 'row id's being renumbered? or just the visual numbers?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jan-14 12:36pm

Can you show the code which you trying to delete the row?
Have you rebounded the DGV after deleting the row?

Kees van Spelde 10-Jan-14 14:03pm

He said the DGV is not bound to any datasource so that is probably not the problem.
For the rest I agree with you... show use some code.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jan-14 22:55pm

Yes, correct. Thanks :)

ZurdoDev 10-Jan-14 15:39pm

Yes, you need to keep track of your rows properly.

njammy 10-Jan-14 18:21pm

I agree you need to show your code and logic.
To be a bit helpful, here's a quick example that works. It can be modified to use id's and other data to get the row to delete.
///

/// Add row
///

/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string rowValue = textBox1.Text;
dataGridView1.Rows.Add(new object[] { rowValue });
}

///

/// Delete row
///

/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DataGridViewRow row = dataGridView1.SelectedRows[0];
dataGridView1.Rows.Remove(row);
}

Generally though, before delete event, the data should be stored in at least a Dictionary object or a class as that can be added to a collection. This can be bound to a DGV and refreshed to get around your issue.

Dilan Shaminda 12-Jan-14 0:50am

you can do something like this.when you are selecting the row take the Index of that row.then use
dataGridView1.Rows.RemoveAt(Index);

1 solution

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)

Rahul VB · Answer 1 · 2014-01-11T06:46:00

Hello ,

I have created a small application it contains a form with the following controls:

1)2 buttons:
-Add: Adds the data in datagridview.
-Delete: Delete data from the datagridview.

2)DataGridView:
-datagridview1

3)2 textboxes:
- textbox1: enter data into the datagridview through this textbox.
- textbox2: this specifies the index at which you want to remove the data. So enter the index at which you want to remove the data.

C#

public partial class Form1 : Form
  {
      public Form1()
      {
          InitializeComponent();
          dataGridView1.Columns.Add("col1", "data");////Initialize the columns and give it a name.
          dataGridView1.RowsRemoved += new DataGridViewRowsRemovedEventHandler(removed);///When you remove an item this event handler fires


      }

      private void add_Click(object sender, EventArgs e)
      {
          dataGridView1.Rows.Add(textBox1.Text);///fetch an item from textbox and add it to the datagridview
       }

      private void delete_Click(object sender, EventArgs e)
      {
          dataGridView1.Rows.RemoveAt(int.Parse(textBox2.Text));////Remove At the location specified in the textbox
      }

      public void removed(object sender, DataGridViewRowsRemovedEventArgs e)
      {

          MessageBox.Show("Removed  ");///pops up when you delete an item
      }

  }

- Please remember suppose you have 3 elements in the datagridview. To delete the 3 element you will have to specify the index : 2, because it is a zero based index, starts from 0 not 1. So the exception you might have got is :

Quote:
Uncommitted new row cannot be deleted.

(correct me if i am wrong).

- Just try the above code. Hope it helps. This code adds and deletes an item on button press. Please do let me know what happens.

thanks again,
-Rahul