Visual Basic

transactionDataGridView.DataSource = nothing<br />
transactionDataGridView.DataSource = transactionBindingSource

Private Sub PopulateDataViewAndFilter() 
    Dim set1 As New DataSet()

    ' Some xml data to populate the DataSet with.
    Dim musicXml As String = " & _
        "<music>" & _
        "<recording><artist>Coldplay</artist><cd>X & Y</cd></recording>" & _
        "<recording><artist>Dave Matthews</artist><cd>Under the Table and Dreaming</cd></recording>" & _
          "</music>"

    ' Read the xml.
    Dim reader As New StringReader(musicXml)
    set1.ReadXml(reader)

    ' Get a DataView of the table contained in the dataset.
    Dim tables As DataTableCollection = set1.Tables
    Dim view1 As New DataView(tables(0))

    ' Create a DataGridView control and add it to the form.
    Dim datagridview1 As New DataGridView()
    datagridview1.AutoGenerateColumns = True
    Me.Controls.Add(datagridview1)

    ' Create a BindingSource and set its DataSource property to
    ' the DataView.
    Dim source1 As New BindingSource()
    source1.DataSource = view1

    ' Set the data source for the DataGridView.
    datagridview1.DataSource = source1

    source1.Filter = "artist = 'Dave Matthews'"

End Sub