delete rows in datagridview in c#

priyanka

I want to delete some rows from datagridview based on condition in c#,but at run time i find that row,though by debugging my code is working properly.

My code is as follows:-

foreach (DataGridViewRow item in this.dataGridView1.Rows)

{

if ((item.Cells["Start Time"].Value.ToString() != "22:00:00") || (item.Cells["Start Time"].Value.ToString() != "18:00:00"))

{

dataGridView1.Rows.Remove(item);

}

dataGridView1.Rows.Remove(item);

Instead of this line,I have even tried

dataGridView1.Rows.RemoveAt(item.Index)

i have even tried to delete rows from datatable and then bind in datagridview ,but nothings helped me.

why my above code fails to delete record in datagridview,PLZ help me out.

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sirisha K8y ago
I got success in that,
We need to declare datatable has globally and add static and public to datatable declaration.
0
Karthik Ramachandran8y ago
CommandName="Select" OnClick="link_pt_delete_Click" OnClientClick="return confirm('Procedure will be deleted permanently. Are you sure?');">
AlternateText="Delete Procedure Details" ImageUrl="~/images/icons/delete.gif" />

protected void link_pt_delete_Click(object sender, EventArgs e)
{
try
{
LinkButton lc = (LinkButton)sender;
string sid = lc.CommandArgument;
string[] str = new string[2];
char[] splitter = { ',' };
str = sid.Split(splitter);
string coid = str[0].ToString();
int ptId = int.Parse(coid);

// pass this id to your delete stored procedure...

}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
-1
Rafnas T P8y ago
hi,

try to write this code in CellFormatting Event of datagrid
+1
Sirisha K8y ago
dataGridView1.Clear();
+1
priyanka8y ago
Thanks all for your reply
I have solved this,by copying rows based on condition in another datatable.
+1
Kanimozhi Shivakumar8y ago
Hi Priyanka,

Even I faced this same issue..Later I found the solution and now it is working perfectly..You can try below code :

I used for loop instead of Foreach :
for (int i = 0; i < dataGridView1.Rows.Count; i++)
                    {
                        if (dataGridView1["Start Time", i].Value != null && (dataGridView1["Start Time", i].Value.ToString().Trim() == "22:00:00" || dataGridView1["Start Time", i].Value.ToString().Trim() == "18:00:00"  )
                        {
                            DataGridViewRow dgvDelRow = dataGridView1.Rows[i];
                            dataGridView1.Rows.Remove(dgvDelRow);
                        }
                    }
dataGridView1.Refresh();
Please share what error you are getting.. then we can help you to resolve this issue.

You can try with DataGridView1_DataError() event in debug mode to find out the error
+3
Yogesh Ghorpade8y ago
Priyanka Try After Remove The Row

dataGridView1.Refresh();
+1
Jignesh Kumar8y ago
Hi Priyanka,

You can try DeleteRow method

dataGridview1.DeleteRow(Item.Index);

After this use gridview1.Bind() to bind grid after deleted row.
+1
Jaish Mathews8y ago
Just noticed this. Here 2 points to share. 1st you should use RemoveAt() and also if you are using data bind and then need to remove the rows, normal List/Collection won't work. You should use a collection which implements IBindingList i.e. BindingList , DataTable etc... Below is an example which I quickly tried and worked.
private void Form1_Load(object sender, EventArgs e)
{
    BindingList timeDetails = new BindingList();
    timeDetails.Add(new TimeDetail { StartTime = DateTime.Parse("8/11/2018"), Month = "Jan" });
    timeDetails.Add(new TimeDetail { StartTime = DateTime.Parse("8/12/2018"), Month = "May" });
    timeDetails.Add(new TimeDetail { StartTime = DateTime.Parse("12/12/2018"), Month = "May" });
    timeDetails.Add(new TimeDetail { StartTime = DateTime.Parse("1/11/2018"), Month = "Jan" });
    dataGridView1.DataSource = timeDetails;

}
private void button1_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow item in this.dataGridView1.Rows)
            {
                if (item.Cells["Month"].Value.ToString() == "Jan")
                {
                    dataGridView1.Rows.RemoveAt(item.Index);
                }
            }
        }

public class TimeDetail
        {
            public DateTime StartTime { get; set; }
            public string Month { get; set; }

        }
+2
ejaz mirza8y ago
u r bringing the values from database then u have to delete by writing query
0
priyanka8y ago
i am not getting any error,but when i look at runtime,that rows, which i want to delete is still in my datagriview
+1
ejaz mirza8y ago
whats error r u getting
+1
priyanka8y ago
yes,i am getting that
+1
ejaz mirza8y ago
put a break point be sure that u r getting item.id
+1