VB.NET: Clear DataGridView

vb.net datagridview datasource datagridviewrow
Bibhas Debnath picture Bibhas Debnath · Feb 7, 2010 · Viewed 279.2k times · Source

I've tried -

DataGridView1.DataSource=Nothing

and

DataGridView1.DataSource=Nothing
DataGridView1.Refresh()

and

DataGridView1.RefreshEdit()

None of them works..

I've written a method that sets the DataSource of the DataGridView when executed. but each time i execute it, it replicates the data with new value and appends it to the previous contents of the DGV.. I wanna clear the content and then add the values.. Is that possible?

Answer

Alex Essilfie picture Alex Essilfie · Sep 16, 2010

If the DataGridView is bound to any datasource, you'll have to set the DataGridView's DataSource property to Nothing.

If the DataGridView is not bound to any data source, this code will do the trick:

DataGridView.Rows.Clear()

Related questions

Disable Cell Highlighting in a datagridview

How to disable Cell Highlighting in a datagridview, Highlighting should not happen even if I click on the cell. Any thoughts please

Read More
Double-click DataGridView row?

I am using vb.net and DataGridView on a winform. When a user double-clicks on a row I want to do something with this row. But how can I know whether user clicked on a row or just anywhere in …

Read More
Loading datagridview in VB.NET programmatically using dataset

I've created a datagridview, dataGridReport in the Designer view of VB 2010. I'm then using a query to fill a dataset, and I want this dataset to populate the datagridview... but it doesn't seem to work. This is my code: Dim …

Read More