Search records in a database

[jcf]

Hi,

I am creating a program that is connected to a database (Jet. OLEDB). I would like to know how can you search a record in the program.

Thanks

[Paladine]

A search is bascially a query in the most basic sense. i.e. SELECT title FROM books WHERE author = "King, Stephen"

So the questions become;

What are you wanting to do for the search?

Do you want to search on one specifc criteria (i.e. Username or book title) ??

Do you want to do searches on concatnated strings? (i.e. A book tile by a specific author)

Please provide more details as to what you want to do specifically and I will be able to provide more details to assist you.

[jcf]

If the users want to search for a certain keyword....they must type a keyword in a textbox.....then it will show the record that matches that keyword.

- so that if you have a lot of records in a database you can easily search for it.

Thanks for helping....I might have some more questions after these one.

[postmaster]

Following is a part of code to search a record and diaplay that record.

http://www.programmingknowledge.com/simpleDataGrid.aspx

=================================

Private Sub LoadPage() 
Dim strSQL As String = "SELECT * FROM JOB WHERE ID =" & 
Request.QueryString.Item("JobID") 
Dim cnn As New SqlClient.SqlConnection 
Dim cmd As SqlCommand 
Dim dr As SqlDataReader 
 
cnn.ConnectionString="Server=SERVERNAME;
_Database=DBNAME;uid=USER;pwd=PWD;" 
 
cnn.Open() 
cmd = New SqlCommand(strSQL, cnn) 
dr = cmd.ExecuteReader 
 
While dr.Read 
lblID.Text = dr("ID") 
txtJobName.Text = dr("JobName") 
txtJobDescription.Text = dr("JobDescription") 
End While 
End Sub

[Paladine]

Also try looking at some of the tutorials and posts about Login pages, etc on Dani Web as they contain good examples of searches from values entered into a textbox.

[Noonza]

Hi i have to do the project in ASP.net, could please send me code for search that are connected to sql Database.

[SheSaidImaPregy]

Noonza,

To do a search in a database, all you have to do is create a user control like Datalist, DataGrid, or Repeater and bind it to the datasource. If you want to search for a keyword, create a textbox that posts to the server. When a user enters in the information and submits, it will post to the server, and the your code will tell the SQL command what to search for. Then you need to bind that datasource to your user control. On the front-end of your page, you will need to design your search results and how they will display.

Create a page with a form running at the server. Create the textbox and submit button. On the submit button, create an OnClick command that posts to a sub on the server. Something like this would look like

OnClick="btnSearch_Click"

Then in your "Sub btnSearch_Click(...)" you will have the code to search the database using SQL parameters and the LIKE with % symbols. Then after it does the search, check to see if it "hasrows" with "repeatername.HasRows". If it is true, bind to the datasource.

Now create your Datalist, DataGrid, or Repeater on the page with your design/layout in the ItemTemplate tags. Then run your page and you have your results.

Done.

[krany18]

please send me the code for that

please...please...please...please...please...please...
ASAP

[krany18]

please send me the code as soon as possible

[shanwaz]

how to search paritcular thing in database and that has to view in gridview and how to delete/edit from frontend only. plz give the answer. its urgent. thank u