VB.NET: Clear DataGridView

Question

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?

score 72 · Accepted Answer · answered Sep 16 '10 at 12:55

72

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()

answered Sep 16 '10 at 12:55

Alex Essilfie

12,339
9
70
108

1

In case this code throws an error like "Cannot clear this list", I suggest this approach: `DataGridView.DataSource = Nothing` ...then refresh it... `DataGridView.Refresh()` – Curbside Coder Oct 05 '19 at 13:04

score 11 · Answer 2 · answered Apr 08 '13 at 20:38

11

For unbound cases note that:

DataGridView.Rows.Clear()

leaves the Columns collection in place.

DataGridView.Columns.Clear()

..will remove all the columns and rows. If you are using the DGV unbound, and on next use the columns change, clearing the Rows may not be adequate. For library code clear all the columns before adding columns.

answered Apr 08 '13 at 20:38

rheitzman

2,247
3
20
36

Thank goodness someone has included the code to clear unbound grid. I'm really glad there isn't a **clear** for the whole grid, too easy that way. – EllieK Apr 28 '23 at 18:06

score 8 · Answer 3 · answered Feb 07 '10 at 15:12

8

I'd probably use this...

DataGridView1.Rows.Clear()

to clear out the rows and then rebind.

answered Feb 07 '10 at 15:12

Restore the Data Dumps

38,967
12
96
122

3

It says cannot clear this list.. Is it because I'm using a database table as the datasource? – Bibhas Debnath Feb 07 '10 at 23:25

score 4 · Answer 4 · edited Feb 05 '13 at 10:35

4

Follow the easy way like this

assume that ta is a DataTable

ta.clear()
DataGridView1.DataSource = ta
DataGridView1.DataSource = Nothing

edited Feb 05 '13 at 10:35

Alex Essilfie

12,339
9
70
108

answered Jan 24 '13 at 15:02

Nal MEN

41
1

score 1 · Answer 5 · edited May 31 '13 at 16:34

1

To remove the old record in datagridview when you are searching for new result,with button_click event write the following code,

me.DataGridview1.DataSource.clear()

this code will help to remove the old record in datagridview.

edited May 31 '13 at 16:34

Community

1
1

answered May 31 '13 at 16:14

karthikeyan

11
2

score 1 · Answer 6 · answered Sep 04 '13 at 19:00

1

I found that setting the datasource to null removes the columns. This is what works for me:

c#:

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

VB:

Call CType(myDataGrid.DataSource, DataTable).Rows.Clear()

answered Sep 04 '13 at 19:00

Ron Rebennack

2,666
1
22
17

Thumb up for mentioning a common problem, that other answers don't respect or address. – Oak_3260548 Feb 16 '18 at 08:49

score 1 · Answer 7 · answered Feb 07 '10 at 15:13

1

Can you not bind the datagridview to an empty collection (instead of null). That do the trick?

answered Feb 07 '10 at 15:13

FiveTools

5,970
15
62
84

score 1 · Answer 8 · edited Feb 14 '17 at 17:21

1

Don't do anything on DataGridView, just clear the data source. I tried clearing myDataset.clear() method, then it worked.

edited Feb 14 '17 at 17:21

marc_s

732,580
175
1,330
1,459

answered Jun 07 '14 at 12:03

user3717731

11
1

It's always better to explain why, not just what to do. – edi9999 Jun 07 '14 at 12:44

score 1 · Answer 9 · answered Jun 25 '15 at 12:54

1

My DataGridView is also bound to a DataSource and myDataGridView.Columns.Clear() worked fine but myDataGridView.Rows.Clear() did NOT. Just an FYI for those who have tried .Rows.

answered Jun 25 '15 at 12:54

leoraelkins

173
1
1
13

score 0 · Answer 10 · answered Oct 28 '13 at 09:54

I had the same problem on gridview content clearing. The datasource i used was a datatable having no columns, and i added columns and rows programmatically to datatable. Then bind to datagridview. I tried the code related with gridview like gridView.Rows.Clear(), gridView.DataSource = Nothing

but it didn't work for me. Then try the below code related with datatable before binding it to datagridview each time.

  dtStore.Rows.Clear()
  dtStore.Columns.Clear()
  gridView.DataSource = dtStore

And is working fine, no replication in DataGridView

score 0 · Answer 11 · answered Feb 07 '10 at 15:22

I've got this code working in a windows form,

Public Class Form1

    Private dataStuff As List(Of String)


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        DataGridView1.DataSource = Nothing

    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        dataStuff = New List(Of String)

        dataStuff.Add("qwerty")
        dataStuff.Add("another")
        dataStuff.Add("...and another")

        DataGridView1.DataSource = dataStuff
    End Sub
End Class

score 0 · Answer 12 · answered Mar 07 '14 at 13:50

1) create button named it Clear.Inside insert tfhe following code datagridviewer.DataSource=nothing

2) In your search button begin your code by the following statement

datagridviewer.DataSource = DataSet.table

Nb:instead of table put the real name of your table ex: datagridviewer.DataSource = DataSet.client

score 0 · Answer 13 · edited Jun 15 '14 at 10:35

0

When feeding info from an SQL query into a datagridview you can clear the datagridview first before reloading it.

Where I have defined dbDataSet as New DataTable I can do a clear. dbDataSet must be at the start of the form within the Public Class Form

Dim dbDataset AS New DataTable

within the code of you Private Sub, place

dbDataSet.Clear()

edited Jun 15 '14 at 10:35

brasofilo

25,496
15
91
179

answered Jun 15 '14 at 07:21

user3741825

1

score 0 · Answer 14 · answered Jul 03 '14 at 15:04

You may have a user scenario such that you want to keep the data binding and only temporarily clear the DataGridView. For instance, you have the user click on a facility on a map to show its attributes for editing. He is clicking for the first time, or he has already clicked on one and edited it. When the user clicks the "Select Facility" button, you would like to clear the DataGridView of the data from the previous facility (and not throw an error if it's his first selection). In this scenario, you can achieve the clean DataGridView by adapting the generated code that fills the DataGridView. Suppose the generated code looks like this:

    Try
        Me.Fh_maintTableAdapter.FillByHydrantNumber(Me.Fh2010DataSet.fh_maint, hydrantNum)
    Catch ex As System.Exception
        System.Windows.Forms.MessageBox.Show(ex.Message)
    End Try

We are filling the DataGridView based on the hydrant number. Copy this code to the point where you want to clear the DataGridView and substitute a value for "hydrantNum" that you know will retrieve no data. The grid will clear. And when the user actually selects a facility (in this case, a hydrant), the binding is in place to fill the DataGridView appropriately.

score 0 · Answer 15 · answered Sep 10 '14 at 14:18

0

If the DataGridView is bound to any datasource,

DataGridView1.DataSource = Nothing
DataGridView1.DataBind()

answered Sep 10 '14 at 14:18

SUHAIL AG

195
1
8

score 0 · Answer 16 · edited Sep 04 '15 at 11:03

Dim DS As New DataSet

DS.Clear() - DATASET clear works better than DataGridView.Rows.Clear() for me :

Public Sub doQuery(sql As String)
   Try
        DS.Clear()  '<-- here
        '   - CONNECT -
        DBCon.Open()
        '   Cmd gets SQL Query
        Cmd = New OleDbCommand(sql, DBCon)
        DA = New OleDbDataAdapter(Cmd)
        DA.Fill(DS)
        '   - DISCONNECT -
        DBCon.Close()
    Catch ex As Exception
        MsgBox(ex.Message)
    End Try
End Sub

score 0 · Answer 17 · edited Apr 11 '16 at 17:55

0

If the GridView (Say the name is gvArchive) is bound to any DataSource, the following will clear it:

gvArchive.DataSource = Nothing

gvArchive.DataBind()

edited Apr 11 '16 at 17:55

Paul Roub

36,322
27
84
93

answered Apr 11 '16 at 17:44

Neil

821
9
17

score 0 · Answer 18 · answered Mar 26 '17 at 10:20

0

just write this

DataGridView1.DataSource = ""

answered Mar 26 '17 at 10:20

Areej Qasrawi

97
4

2

Whilst this code snippet is welcome, and may provide some help, it would be [greatly improved if it included an explanation](//meta.stackexchange.com/q/114762) of *how* and *why* this solves the problem. Remember that you are answering the question for readers in the future, not just the person asking now! Please [edit] your answer to add explanation, and give an indication of what limitations and assumptions apply. – Toby Speight Mar 27 '17 at 10:18

score 0 · Answer 19 · answered Sep 20 '17 at 12:57

I had the same problem: I was programmatically binding my GridView1 to one SQL table [dictonary] or another [meny] BUT when I selected the second table from my RadioButtonList1, I was getting an error (System.Web.HttpException: Field or property with the title [the first column's title from the previously selected table] was not found in the selected data source.) i.e. saying that the columns from my first-selected table couldn't be found. All I needed to do was insert:

GridView1.Columns.Clear()

before adding the table columns. Here goes the full code:

Dim connectionString As String = "your-string-details"
Dim connection As New SqlConnection(connectionString)

Then comes your first Sub:

Private Sub BindOrders()
    connection.Open()

    Dim sqlCommand As String = "SELECT * FROM [dictionary]" 
    Dim dataAdapter As New SqlDataAdapter(sqlCommand, connection)
    Dim dt As New DataTable() 
    dataAdapter.Fill(dt)

    GridView1.Columns.Clear() ' clear columns before adding new ones

    If GridView1.Columns.Count <= 0 Then
        Dim Field As New BoundField()
        Field.DataField = "id"
        Field.HeaderText = "id"
        GridView1.Columns.Add(Field)

        Field = New BoundField()
        Field.DataField = "strArHundreds"
        Field.HeaderText = "strArHundreds"
        GridView1.Columns.Add(Field)

        Field = New BoundField()
        Field.DataField = "strArTens"
        Field.HeaderText = "strArTens"
        GridView1.Columns.Add(Field)

        Field = New BoundField()
        Field.DataField = "strArSingles"
        Field.HeaderText = "strArSingles"
        GridView1.Columns.Add(Field)
    End If

    GridView1.DataSource = dt
    GridView1.DataBind()

    connection.Close()
End Sub

Then comes your second Sub:

Private Sub BindDocuments()
    connection.Open()

    Dim sqlCommand As String = "SELECT * FROM [meny]"
    Dim dataAdapter As New SqlDataAdapter(sqlCommand, connection)
    Dim dt As New DataTable()

    dataAdapter.Fill(dt)

    GridView1.Columns.Clear() ' clear columns before adding new ones

    If GridView1.Columns.Count <= 0 Then
        Dim Field As New BoundField
        Field = New BoundField
        Field.DataField = "id"
        Field.HeaderText = "id"
        GridView1.Columns.Add(Field)

        Field = New BoundField
        Field.DataField = "nazev"
        Field.HeaderText = "nazev"
        GridView1.Columns.Add(Field)
    End If

    GridView1.DataSource = dt
    GridView1.DataBind()

    connection.Close()
End Sub

Finally comes your RadioButton:

Protected Sub RadioButtonList1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles RadioButtonList1.SelectedIndexChanged
    Dim index As Integer
    index = RadioButtonList1.SelectedIndex
    Select Case index
        Case 0
            BindOrders()
            Exit Select
        Case 1
            BindDocuments()
            Exit Select
    End Select
End Sub

For completion, here is the code for the GridView1 and the RadioButtonList1 in the associated aspx.file:

<asp:RadioButtonList ID="RadioButtonList1"
    runat="server"
    AutoPostBack="True"
    OnSelectedIndexChanged="RadioButtonList1_SelectedIndexChanged">
    <asp:ListItem>Obraty</asp:ListItem>
    <asp:ListItem>Dokumenty</asp:ListItem>
</asp:RadioButtonList>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
</asp:GridView>

This all works well now.

score 0 · Answer 20 · answered Dec 22 '17 at 19:45

The mistake that you are making is that you seem to be using a dataset object for storing your data. Each time you use the following code to put data into your dataset you add data to the data already in your dataset.

myDataAdapter.Fill(myDataSet)

If you assign the table in your dataset to a DataGridView object in your program by the following code you will get duplicate results because you have not cleared data which is already residing in your dataset and in your dataset table.

myDataGridView.DataSource = myDataSet.Tables(0)

To avoid replicating the data you have to call clear method on your dataset object.

myDataSet.clear()

An then assign the table in your dataset to your DataGridView object. The code is like this.

myDataSet.clear()
myDataAdapter.Fill(myDataSet)
myDataGridView.DataSource = myDataSet.Tables(0)

You can try this code:

' clear previous data
DataGridView2.DataSource = Nothing
DataGridView2.DataMember = Nothing
DataGridView2.Refresh()
Try
    connection.Open()
    adapter1 = New SqlDataAdapter(sql, connection)
    ' clear data already in the dataset
    ds1.Clear()
    adapter1.Fill(ds1)
    DataGridView2.DataSource = ds1.Tables(0)
    connection.Close()
Catch ex As Exception
    MsgBox(ex.ToString)
End Try

score 0 · Answer 21 · answered Feb 07 '19 at 04:46

Use this code where ever you want to implement clear datagridview command

datagridview1.datasource= nothing
datagridview1.datasource= ds
dt.clear()               'Dt as new DATATABLE
ds.clear()              'Ds as new Dataset

this code will clear the datagridview and wil stop data duplication when populating data from database.

score 0 · Answer 22 · answered Jan 03 '12 at 05:10

0

You should remove the table from dataset if the datagrid is bind to some datatable. Your Gridview will be cleared automatically. No other way.

[YourDatasetName].Tables.Clear()

answered Jan 03 '12 at 05:10

Samiran Nath

21
1

What does your answer adds new to the already accepted answer? – Yaroslav Oct 27 '12 at 16:14

user2955140 · Answer 23 · 2014-02-25T04:52:40.413

-1

For the Clear of Grid View Data You Have to clear the dataset or Datatable

I use this Code I clear the Grid View Data even if re submit again and again it will work Example Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim da As New OleDbDataAdapter Dim dar As OleDbDataReader Dim dt As New DataTable If (con.State <> 1) Then con.Open() End If dt.Clear() 'To clear Data Every time to fresh data cmd.Connection = con cmd.CommandText = "select * from users" da.SelectCommand = cmd da.Fill(dt) DataGridView1.DataSource = dt DataGridView1.Visible = True

    cmd.Dispose()
    con.Close()

edited Feb 25 '14 at 04:52

answered Feb 24 '14 at 10:56

user2955140

1
1

Thanks for contributing to StackOverflow :). The question you are answering is old and already answered - we'll be glad if you can give your effort to more pressing questions too. Also please try to keep your answer relevant for the example in the question (which doesn't involve any users table, for instance). – Mifeet Feb 24 '14 at 11:20

score -1 · Answer 24 · edited Jun 07 '16 at 13:16

-1

You can do that only by the following 2 lines:

DataGridView1.DataSource=Nothing
DataGridView1.DataBind()

edited Jun 07 '16 at 13:16

Thomas G

9,886
7
28
41

answered Jun 07 '16 at 07:42

Peter Mankge

79
1
2

Dash_25 · Answer 25 · 2018-03-07T03:51:03.080

-1

You can also try this code if you want to clear all data in your DataGridView

DataGridView1.DataSource.Clear()

edited Mar 07 '18 at 03:51

answered Mar 07 '18 at 03:22

Dash_25

1
1

score -1 · Answer 26 · edited Jun 15 '20 at 17:40

-1

Try this for a specific cell:

Datagrid.Rows(RowIndex).Cells(ColIndex).Value = DBNull.Value

edited Jun 15 '20 at 17:40

Matt Ke

3,599
12
30
49

answered Jun 15 '20 at 17:04

ahmed abdelsalam

1

Very short answers tend to get automatically flagged for low quality, so avoid one-liner answers like this. Beyond that, it's always helpful to add a little explanation of *why* the change you're suggesting should solve the problem. – Caleb Jun 15 '20 at 18:05

Gmo Core · Answer 27 · 2021-10-27T23:42:50.143

-1

DgRemolques is the name of my Data grid on WPF

dgRemolques.ItemsSource = Nothing but i need to clean also de DataTable dtRemolques.Clear()

edited Oct 27 '21 at 23:42

answered Oct 22 '21 at 16:42

Gmo Core

1
1

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Oct 22 '21 at 17:08

score -1 · Answer 28 · edited Mar 20 '12 at 15:47

-1

You can do in this way:

DataGridView1.Enable = false
DataGridView1.DataSource = Nothing
DataGridView1.Enable = true

edited Mar 20 '12 at 15:47

Isuru

30,617
60
187
303

answered Feb 01 '12 at 09:21

wertyk

410
10
30

VB.NET: Clear DataGridView

28 Answers28

Linked