SQL search problems

Question

So here is my problem: I have a site where I have to search through the stuff on it. This is my sql sentence:

public DataTable Search(string Keyword)
{
    return db.GetData("SELECT * FROM tblBehandlinger WHERE fldYdelse LIKE @1", 
                  "%" + Keyword + "%");
}

But as you can see it will only search through the table name "fldYdelse". And I works fine, but my problem is that it wont search through two things. This I how I want it to be:

public DataTable Search(string Keyword)
{
    return db.GetData("SELECT * FROM tblBehandlinger WHERE fldYdelse LIKE 
                       @1 OR fldPris @2", "%" + Keyword + "%");
}

This is my backend of the search.aspx site:

string keyword = Request.QueryString["search"].ToString();

foreach (DataRow item in s.Search(keyword).Rows)
{
    //BLAH BLAH BLAH
}

But I can't list it out.

Mahmoud Gamal · Accepted Answer · 2012-10-02 12:43:24Z

2

You have to write the LIKE predicate with the second parameter fldPris as well. Your sql statement should look like:

SELECT * 
FROM tblBehandlinger 
WHERE fldYdelse LIKE @1 
   OR fldPris   LIKE @2

Instead of:

SELECT * 
FROM tblBehandlinger 
WHERE fldYdelse LIKE @1 
   OR fldPris @2

edited Oct 2, 2012 at 12:43

answered Oct 2, 2012 at 12:16

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RichardTheKiwi · Accepted Answer · 2012-10-02 12:17:14Z

0

Repeating a parameter (string) in C# is cheap... did you want to use a single parameter twice?

return db.GetData("SELECT * FROM tblBehandlinger " +
                  "WHERE fldYdelse LIKE @1 OR fldPris LIKE @2",
                  "%" + Keyword + "%", "%" + Keyword + "%");

Or did you really miss the 2nd LIKE?

answered Oct 2, 2012 at 12:17

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

2 Comments

Kasper Bramsen Over a year ago

Huh.. didnt think of that. But thank you very much! It worked :)

RichardTheKiwi Over a year ago

Thanks for the confirmation. I think you need to wait 15 minutes before accepting the answer. Welcome to StackOverflow.

codingbiz · Accepted Answer · 2012-10-02 12:18:13Z

0

I think you mean

return db.GetData("SELECT * FROM tblBehandlinger WHERE fldYdelse LIKE 
                   @1 OR fldPris LIKE @1", "%" + Keyword + "%");

It's the same keyword

answered Oct 2, 2012 at 12:18

codingbiz

26.4k9 gold badges62 silver badges99 bronze badges

Collectives™ on Stack Overflow

SQL search problems

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related