How to clear a data grid view

Question

I am trying to populate a DataGridView based on the selected item in a ComboBox  I have this part working   However  I need to be able to clear the grid before adding the new data from a new item rather than it just adding on to the end    How do I clear a DataGridView before adding items to it

User · Answer

For having a Datagrid you must have a method which is formatting your Datagrid. If you want clear the Datagrid you just recall the method.

Here is my method:

    public string[] dgv_Headers = new string[] { "Id","Hotel", "Lunch", "Dinner", "Excursions", "Guide", "Bus" }; // This defined at Public partial class


    private void SetDgvHeader()
    {
        dgv.Rows.Clear();
        dgv.ColumnCount = 7;
        dgv.RowHeadersVisible = false;
        int Nbr = int.Parse(daysBox.Text);  // in my method it's the textbox where i keep the number of rows I have to use
        dgv.Rows.Add(Nbr);
        for(int i =0; i<Nbr;++i)
            dgv.Rows[i].Height = 20;
        for (int i = 0; i < dgv_Headers.Length; ++i)
        {
            if(i==0)
                dgv.Columns[i].Visible = false;  // I need an invisible cells if you don't need you can skip it
            else
                dgv.Columns[i].Width = 78;
            dgv.Columns[i].HeaderText = dgv_Headers[i];
        }
        dgv.Height = (Nbr* dgv.Rows[0].Height) + 35;
        dgv.AllowUserToAddRows = false;
    }

dgv is the name of DataGridView

User · Answer

YourGrid Items Clear    YourGrid Items Refresh

User · Answer

You can clear DataGridView in this manner      dataGridView1 Rows Clear    dataGridView1 Refresh      If it is databound then try this  dataGridView1 Rows Clear      If dgv is bound to datatable dataGridView1 DataBind

User · Answer

datatable Clear    dataGridView1 DataSource   datatable

User · Answer

You could take this next instruction and would do the work with lack of perfomance  If you want to see the effect of that  put one of the 2 next instructions  Technically similars  where you need to clear the DataGridView into a try   catch        finally block and wait what occurs        while  dataGridView1 Rows Count  gt  1                dataGridView1 Rows RemoveAt 0              foreach  object  Cols in dataGridView1 Columns                dataGridView1 Columns RemoveAt 0           You improve this task but its not enough  there is a problem to reset a DataGridView  because of the colums that remains in the DataGridView object  Finally I suggest  the best way i ve implemented in my home practice is to handle this gridView as a file with rows  columns  a record collection based on the match between rows and columns  If you can improve  then take your own choice a  or b   foreach or while           a   With foreach      foreach  object  Cols in dataGridView1 Columns                dataGridView1 Columns RemoveAt 0              foreach object  row in dataGridView1 Rows           dataGridView1 Rows RemoveAt 0                 b   With foreach      while  dataGridView1 Rows Count  gt  1                dataGridView1 Rows RemoveAt 0             while  dataGridView1 Columns Count  gt  0                dataGridView1 Columns RemoveAt 0           Well  as a recomendation Never in your life delete the columns first  the order is before the rows after the cols  because logically the columns where created first and then the rows It would be a penalty in terms of correct analisys        foreach  object  Cols in dataGridView1 Columns                dataGridView1 Columns RemoveAt 0             foreach  object  row in dataGridView1 Rows                dataGridView1 Rows RemoveAt 0             while  dataGridView1 Rows Count  gt  1                dataGridView1 Rows RemoveAt 0              while  dataGridView1 Columns Count  gt  0                dataGridView1 Columns RemoveAt 0           Then  Put it inside a function or method    private void ClearDataGridViewLoopWhile                    while  dataGridView1 Rows Count  gt  1                dataGridView1 Rows RemoveAt 0              while  dataGridView1 Columns Count  gt  0                dataGridView1 Columns RemoveAt 0            private void ClearDataGridViewForEach         foreach  object  Cols in dataGridView1 Columns                dataGridView1 Columns RemoveAt 0             foreach  object  row in dataGridView1 Rows                dataGridView1 Rows RemoveAt 0             Finally  call your new function ClearDataGridViewLoopWhile    or ClearDataGridViewForEach    where you need to use it  but its recomended when you are making queries and changing over severall tables that will load with diferents header names in the grieView  But if you want preserve headers here there is a solution given

User · Answer

If you want to clear all the headers as well as the data  for example if you are switching between 2 totally different databases with different fields  therefore different columns and column headers  I found the following to work  Otherwise when you switch you have the columns  fields from both databases showing in the grid   dataTable Dispose     get rid of existing datatable dataTable   new DataTable     create new datatable  datagrid DataSource   dataTable   clears out the datagrid with empty datatable   datagrid Refresh    This does not seem to be neccesary  dataadapter Fill dataTable     assumming you set the adapter with new data                datagrid DataSource   dataTable

User · Answer

This is working to me   int numRows   dgbDatos Rows Count               for  int i   0  i  lt  numRows  i                                  try                                        int max   dgbDatos Rows Count - 1                      dgbDatos Rows Remove dgbDatos Rows max                        btnAgregar Enabled   true                                    catch  Exception exe                                        MessageBox Show  No se puede eliminar     exe                          MessageBoxButtons OK  MessageBoxIcon Information

User · Answer

private void ClearGrid             if this InvokeRequired  this Invoke new Action this ClearGrid         this dataGridView DataSource   null      this dataGridView Rows Clear        this dataGridView Refresh

User · Answer

If it s bound to a datasource -  dataGridView DataSource null  dataGridView Rows Clear      Worked for me

User · Answer

refresh the datagridview and refresh the datatable  dataGridView1 Refresh    datatable Clear

User · Answer

Solution is   while  dataGridView1 RowCount  gt  1        dataGridView1 Rows RemoveAt 0

User · Answer

You can assign the datasource as null of your data grid and then rebind it   dg DataSource   null  dg DataBind

User · Answer

DataGrid DataSource   null  DataGrid DataBind

User · Answer

Firstly  null the data source   this dataGridView DataSource   null    Then clear the rows   this dataGridView Rows Clear      Then set the data source to the new list   this dataGridView DataSource   this GetNewValues

User · Answer

The solution is   dataGridView1 Rows RemoveAt 0     Clears the grid and preserves the columns

User · Answer

dataGridView1 Rows Clear    dataGridView1 Refresh

User · Answer

IF you want to clear not only Data  but also ComboBoxes  Checkboxes  try  dataGridView Columns Clear

[c#] How to clear a data grid view

Examples related to c#

Examples related to datagrid