Pls. use SQL query viz
strQuery = "Select * from customers where customer name like '%" textbox1.text &" %'"
Pls. make sure to change your approriate db connection string
Public Function LoadData(ByVal StrQuery As String) As DataSet
Try
Dim con As New MySqlConnection(GetConnection.ToString)
Dim cmd As New MySqlCommand(StrQuery, con)
Dim ds As New DataSet
Dim da As New MySqlDataAdapter(cmd)
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
da.Fill(ds)
If IsNothing(ds) Then
ds = Nothing
Return ds
Else
Return ds
End If
Catch ex As Exception
Throw ex
End Try
End Function
The above will return the dataset. bind this dataset to your grid
dim ds as new dataset
ds = LoadData(strQuery )
grid.datasource = ds
grid.databind()
Pls. mark as solved if it helps you.
Last edited by reach_yousuf; Nov 23rd, 2008 at 1:25 am.