clear datagrid

[angelica]

I need to clear datagrid Tab Page on leave method.

I have tried the following but nothing works. Any idea?



Private Sub TbView_leave(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TbViewStockbalance.Leave
DataGrid3.Refresh()

End Sub

Private Sub TbView_leave(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TbViewStockbalance.Leave
DataGrid3.bindings.clear

End Sub

[sparrow1]

Hi,

You can try this:

dataSet1.Clear()
    
     dataGrid1.DataSource = dataSet1.TableNameHere.DefaultView

Hope it helps,

sparrow1

[angelica]

Nope, throws an exception;

Object reference not set to an instance of an object.
----------------------------------------------------

Private Sub TbViewStockbalance_leave(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TbViewStockbalance.Leave
        Dim dataset1 As DataSet = New DataSet
        dataset1.Clear()
        DataGrid3.DataSource = dataset1.Tables("tb_transaction_log").DefaultView
    End Sub

[sparrow1]

Hi,

I'm assuming you want to clear the datatable which will have the effect of
clearing the grid? To clear the datatable you can just call:

DataTableName.Clear

Wkr,

sparrow1

[angelica]

Doesnt work sparrow1,


Well Im populating with :

Using mMySqlDataAdapter As New SqlClient.SqlDataAdapter(cmd)
                    Using mDataSet As New DataSet 'call dataset
                        mDataSet.Clear()
                        mMySqlDataAdapter.Fill(mDataSet, "tb_book") 'fill dataset with the table in the query
                        mDataView = New DataView
                        mDataView.Table = mDataSet.Tables("tb_book"

then I need to clear the grid on Tab Pag leave.

[jmcilhinney]

First up, why do you have a Using block? Why would you want to dispose a DataSet that you're binding to a control and, therefore, continuing to make use of past the End Using line?

Secondly, why are you using a DataSet at all? Or a DataView for that matter? All you need is one DataTable. Create it, populate it, bind it, end of story.

Finally, when you want to clear your grid then you need to clear THAT DataTable, or else set the DataSource to Nothing. There's no point creating a new DataSet or DataTable and clearing that. If your TV is on and you want to turn it off do you go out and buy a new TV and turn that off? If you did would that affect the TV you already have?