search record from database
 

hai friends ,,

in monster/naukri we have a search button is there.using that we can search the record from there.
in my project also we have a registration form .
if we wants any customer details just we enters the customer id or name that customer details can retrieved.
i want the code to do like that .i am thinking from 4 days onwards but i am not getting .i am trying using the select command but it is retrieved
please send me a correct to that
Thanks & Regards,

A.Kranti Kumar

Re: search record from database
 

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.