I want to be able to type text in a search box (textbox1) and have the datagrid adjust at the same time. My datagridview is called DGEstudent and the data source is dataset2 and is pulling from the student table. As soon as I start typing in the textbox my datagrid just goes blank. Any help would be greatly appreciated.

Private Sub TextBox1_KeyUp(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.KeyUp

Dim dv As DataView = New DataView()

dv.Table = DataSet2.Student
dv.RowFilter = "First_Name like '" & TextBox1.Text & "%'"

DGEstudent.DataSource = dv

End Sub