| | |
search record from database
Please support our ASP.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Nov 2008
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
•
•
Join Date: Sep 2007
Posts: 66
Reputation:
Solved Threads: 12
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
ASP.NET Syntax (Toggle Plain Text)
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
ASP.NET Syntax (Toggle Plain Text)
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.
![]() |
Similar Threads
- 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
| Thread Tools | Search this Thread |
.net activexcontrol advice ajax alltypeofvideos appliances asp asp.net bc30451 beginner bottomasp.net box browser button c# cac checkbox click commonfunctions control css dataaccesslayer database datagridview datagridviewcheckbox datalist deadlock deployment development dgv dialog dropdownlist dynamic dynamically edit embeddingactivexcontrol expose fileuploader fill findcontrol flash formatdecimal formview gridview gudi iframe iis javascript listbox login microsoft mono mouse mssql multistepregistration news novell numerical objects opera panelmasterpagebuttoncontrols radio redirect registration relationaldatabases reportemail rotatepage save schoolproject search security sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 ssl suse textbox tracking treeview unauthorized validatedate validation vb.net video videos virtualdirectory vista visualstudio web webapplications webdevelopemnt webdevelopment webprogramming webservice xsl youareanotmemberofthedebuggerusers





