efficient searching records from database on search button.

Question

1.00/5 (2 votes)

See more:

i tried this code for solve that problem but it not working properly then give a right searching solution.

C#

string s = Request.QueryString["serc"];
    SqlDataAdapter ad = new SqlDataAdapter("SELECT product_tbl.pname, product_tbl.path, product_tbl.price, product_tbl.cat, product_detail.product_info FROM product_tbl INNER JOIN product_detail ON product_tbl.pro_id = product_detail.pro_id  where product_tbl.pname like '%" + s + "%'", con);

    DataSet ds = new DataSet();
    con.Open();
    ad.Fill(ds);
    con.Close();
    GridView1.DataSource = ds;
    GridView1.DataBind();

Posted 19-Sep-13 19:36pm

sinsinwar rahul

Updated 19-Sep-13 19:54pm

Thanks7872

v2

Add a Solution

Comments

[no name] 20-Sep-13 1:38am

What do you mean by not working properly..??and what more you are expecting..??

sinsinwar rahul 20-Sep-13 2:01am

i mean that code pick up whole records from db .......whatever typing in textbox i only wants selected records whatever i typed in textbox.

CodeBlack 20-Sep-13 1:55am

what error you are getting ?

sinsinwar rahul 20-Sep-13 2:02am

i mean that code pick up whole records from db .......whatever typing in textbox i only wants selected records whatever i typed in textbox.

CodeBlack 20-Sep-13 2:10am

do you get values what you have typed in Request.QueryString["serc"] ?

Thanks7872 20-Sep-13 1:56am

that problem- which problem?

not working properly-means what?

right searching solution-what you mean by this? There is nothing to answer in the above code dump.

sinsinwar rahul 20-Sep-13 2:02am

i mean that code pick up whole records from db .......whatever typing in textbox i only wants selected records whatever i typed in textbox.

JoCodes 20-Sep-13 2:11am

Your requirement is not at all clear . Whatever you are searching through your textbox is supposed to fetch "all" the matching criteria right? Then where is the problem ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

smokingkills · Answer 1 · 2013-09-19T20:25:00

First you need to check whether you are getting correct value in Request.QueryString["serc"].
Second, as you are using '%<searchstring>%', it would retrieve all the items which contain 'searchString' in the Product names.
For example, if all of the products contain 'pro'(anywhere in the product names) & your searchString is also 'pro', it'll return all the items.

efficient searching records from database on search button.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us