search record from database
Please support our ASP.NET advertiser: DiscountASP.NET – 3 Months Free on ASP.NET 3.5/2.0 Web Hosting
![]() |
•
•
Posts: 19
Reputation:
Solved Threads: 0
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
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
•
•
Posts: 43
Reputation:
Solved Threads: 5
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
The above will return the dataset. bind this dataset to your grid
Pls. mark as solved if it helps you.
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 FunctionThe 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 12:25 am.
![]() |
Similar Threads
Other Threads in the ASP.NET Forum
- Search code in a database (Visual Basic 4 / 5 / 6)
- Search records in a database (ASP.NET)
- How to Search record from the Sql Server Database (ASP.NET)
- To Search a record in datagridview (VB.NET)
- Search record from SQLDatabase (ASP.NET)
Other Threads in the ASP.NET Forum
- Previous Thread: oledbDataAdapter.update exception: No value given for one or more required parameter
- Next Thread: richtextbox in asp.net
•
•
•
•
Views: 502 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)





Linear Mode