ASP.Net查询的问题，请大家指教

[shixianyong]

Sub BindGrid()
Dim myConnection As SqlConnection = cn
Dim ds As DataSet = New DataSet
Dim adapter As SqlDataAdapter = New SqlDataAdapter("Select * from ICP_report", myConnection)
adapter.Fill(ds, "ICP_report")
MyDataGrid.DataSource = ds.Tables("ICP_report").DefaultView
MyDataGrid.DataBind()
ShowStats()
End Sub
我要到别的地方Clear BindGrid里面的ds的记录应该怎么写啊，
比如说我要到一个Button1_Click事件做查询，查询时我只需要显示我查询到的记录，
下面是我的代码，
Public cn As New SqlClient.SqlConnection

Public Sub OpenDatabase()
cn.ConnectionString = "Server=192.168.203.30;Database=dgkye;Uid=kye;Pwd=kye;"
cn.Open()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim comm As New SqlCommand
Dim ada As New SqlDataAdapter
Dim ds As New DataSet
comm.Connection = cn
If DropDownList1.SelectedItem.Text = "料号" Then
comm.CommandText = "Select * from ICP_report Where s_materialno like '%" + TextBox1.Text + "%'"
ada.SelectCommand = comm
ada.Fill(ds)
End If
MyDataGrid.DataSource = ds.Tables(0)
End Sub

[singlepine]

直接这样绑定就可以了,datagrid会自动替换为新的数据源的
MyDataGrid.DataSource = ds.Tables(0)
MyDataGrid.DataBind()//在你程序中少了这个

[shixianyong]

TKS