How to clear datagridview all rows?

Question

Hi to all,

 

I have a datagridview on a form. I required it to clear all rows of datagridview on button click event.

 

I tried the syntax ::

        dataGridView1.Rows.Clear();

But that syntax threws an exception "Cannot Clear The List".

 

Currently i am using the syntax ::

        ((DataTable)dataGridView1.DataSource).Rows.Clear();

 

Here, I want to know that is the method mentioned later is the appropriate to clear the datagridview rows or is their any other method to clear the datagridview rows.

 

Thanks

Sandeep Soni

Answer 1

 

if tou use datasource to fill the grid use:

 

dataGridView1.DataSource=null;

dataGridView1.refresh();

 

if you fill the grid programitalty use:

 

dataGridView1.Rows.Clear();

 

 

Answer 2

Hi,

 

Try this :

 

Code Block

Code Changed :

dataGridView1.Rows.Clear()

or

dt.Rows.Clear() // If dgv is bound to datatable

dataGridView1.DataBind();

 

 

or

 

Use this code to check if you are bound to a data source :

 

Code Block

if (this.dataGridView1.DataSource != null)
{
     this.dataGridView1.DataSource = null;
}
else
{
    this.dataGridView1.Rows.Clear();
}

 

 

 

HTH,
Suprotim Agarwal

-----
http://www.dotnetcurry.com
-----

Answer 3

Here I check that the datatable is not directlty accessibe throught datasource property of datagridview.

 

"dataGridView1.DataSource.Table.Rows.Clear();" in that part i could not find any table property after the data source property of datagridview.

 

 

 

Answer 4

Hi,

 

That was a typo. I have changed the code. Kindly have a look at it again.

 

 

HTH,
Suprotim Agarwal

-----
http://www.dotnetcurry.com
-----

 

Answer 5

Thanks Suprotim for you helpful suggestions.

Answer 6

You cant clear the datagrid by just making the datasource into nothing..but you should clear your dt or data table like....dt.clear() the it works.

Answer 7

Both of your codes ain't working....2nd one gives error,

"Unable to cast object of type 'System.Data.DataView' to type 'System.Data.DataTable'."