Search by single and multiple key words both from single textbox

Question

0.00/5 (No votes)

See more:

By Above code I can get details for multiple keywords but at the same time, I want to get records by single keyword also.

Please some one help me, Thanks in Advance

What I have tried:

C#

var db = new MatriModel();
string s = txtKeyWord.Text;
string[] words = s.Split(',');
int count = words.Length;

if (count <= 5))
{
    SerachByKeyWordPanel.Visible = true;
    var KeyWord = db.tblProfiles.Where(x => words.Contains(x.tblCaste.Caste) && words.Contains(x.tblCountry.Country) && words.Contains(x.City) && words.Contains(x.tblOccupation.Occupation) && words.Contains(x.tblMotherTongue.MotherTongue)).Select(x => new
  {
        ProfileID = x.ProfileID,
        ProfileFor = x.tblProfileFor.ProfileFor,
  }.ToList();

Posted 24-Nov-16 4:00am

Member 12115746

Updated 24-Nov-16 9:31am

v2

Add a Solution

Comments

Philippe Mori 24-Nov-16 10:16am

If you want to search specific things, then it would be better to display 5 fields on the web page and filter data as appropriate depending on which field was filled.

You have not clearly explained the problem with your code... It might not be obvious for everyone on the first reading that your code would fails to find an item as soon as one information (caste, country, city...) is missing from the words.

Member 12115746 24-Nov-16 10:59am

Search by keywords like city,Country,Caste with single textbox is working with my above code, but with the same code if i search with single keyword ex: city, then it shows me "No record found".

Need to get records with multiple keyword search and also single keyword

Philippe Mori 24-Nov-16 11:09am

As I said, if one information is missing, you won't find the record because you filter on all fields.

Although if the user enter a single information, it would be trivial to use || instead of && so that it could match any of the field, it won't works well if the user want to enter multiple informations but not all.

You might be able to count the number of matches but then the query would probably become too complex and it might fails or be very slow.

Thus, as I said, the best option is to have one field in your UI for each column in your database. That way, you can easily filter appropriate columns.

Well, if the data is really small (say less than 100 entries maximum), you might be able to do the filtering in memory (and not be limited by the complexity of a SQL query).

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)

Maciej Los · Answer 1 · 2016-11-24T09:31:00

Together with Where you have to use Any[^] Linq method ;)

Check my past answer to the question: Multiple values in 1 parameter using LINQ[^]

My best guess:

C#

var KeyWord = db.tblProfiles
    .Where(x => words.Any(y=< y==x.tblCaste.Caste) || 
                words.Any(y=< y==x.tblCountry.Country) ||
                words.Any(y=< y==x.City) ||
                words.Any(y=< y==x.tblOccupation.Occupation) ||
                words.Any(y=< y==x.tblMotherTongue.MotherTongue))
    .Select(...);

Note: not tested on large portion of data.