C# DataGridView Removing Data Rows

Question

This may be quite a common asked question with regards to the search results, however, I haven't yet found the answer to my problem.

I am loading 3 different types of DataGridView's in 3 different Pages (Window forms), and in each and every single one of them, previously viewed data rows are added onto it (the newly opened DataGridView).

Does anyone know of a way I can prevent this from happening?

 private void Emp_Awaiting_Dispatch_Orders_Load(object sender, EventArgs e)
    {
        foreach (TBL_Order ord in DataLOrders.Get_Status_AwaitingDispatchOrder())
        {
            ViewAwaitDipOrd_DGV.Rows.Add(ord.OrderID, ord.CustomerID, ord.ProductID, ord.Status, ord.Quantity, "Switch to Dispatched");
        }
    }
    private void ViewAwaitDipOrd_DGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
    {
        if (ViewAwaitDipOrd_DGV.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
        {
            if (e.ColumnIndex == 5)
            {
                BusinessLOrders.OrderDispatched();

                foreach (TBL_Order ord in DataLOrders.Get_Status_AwaitingDispatchOrder())
                {                 
                    Int32.TryParse(ViewAwaitDipOrd_DGV.Rows[e.RowIndex].Cells[0].FormattedValue.ToString(), out cellID);

                    if (ord.ProductID == cellID)
                    {
                        Int32.TryParse(ViewAwaitDipOrd_DGV.Rows[e.RowIndex].Cells[0].FormattedValue.ToString(), out cellID);
                    }
                }
            }
        }
    }

Add a bool column - which can be invisible - to the datasource and use a RowFilter to filter them out. — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Jan 1, 2018 at 23:38

user1063108 · Accepted Answer · 2018-01-01 23:48:22Z

1

you can check for row count

dataGridView.Rows.Count

and if there are existing rows you can clear them

dataGridView.Rows.Clear();

Make sure you add header row first if it is not automatically added by source. Hope it helps

answered Jan 1, 2018 at 23:48

user1063108

7421 gold badge12 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

C# DataGridView Removing Data Rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related