| | |
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: 86
Reputation:
Solved Threads: 15
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 |
Tag cloud for ASP.NET
.net 2.0 3.5 ajax appliances application asp asp.net beginner box browser businesslogiclayer button c# cac checkbox child class compatible content contenttype control countryselector courier database datagrid datagridview datalist deployment development dgv dialog dropdown dropdownmenu dynamic dynamically edit embeddingactivexcontrol feedback fileuploader fill findcontrol flash flv folder form gridview gudi iis image javascript list maps menu mobile mssql nameisnotdeclared news novell opera order parent problem radio ratings redirect refer registration relationaldatabases reportemail richtextbox search security select serializesmo.table sessionvariables silverlight smoobjects software sql sql-server ssl tracking treeview typeof validatedate validation vb.net videos vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment webprogramming wizard xsl





