visual basic== help on searching

[sikwate]

can i hav some examples on on how 2 search info from database
and display to data grids? pls .. im almost out of time.

[fret]

what kind of info do you need? like this one or not?

Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
'cn is the SqlConnection 
        da.SelectCommand = New SqlCommand("select * from student where lastname = 'sikwate'", cn)
        Dim dt As New DataTable()
        da.Fill(dt)
        Me.DataGrid1.DataSource = dt
    End Sub