Split the sentence and search every related letter of words from sentence in database and display in datagridview

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

if i will put one sentence in one textbox that all the words will check one by one like google search.and it will display all related datas(means Ex-If i will put one sentence 'Hi ! welcome to india' then it will display all related data by checking every words in database.the result can display all the related data means in the word india means it can display all related 'in' or 'ind ia' or 'nd' in datagridview ) in datagridview.In my following coding it is spiliting the sentence and displaying all the data of particular word but it is not displaying the related data of related word means if i will take 'wellcome to india' then it should filtrate the datas of 'in' or 'dia'.

My Coding is:

C#

private void btnSearch_Click(object sender, EventArgs e)
{
    try
    {
        string commaDelimited = textBox1.Text;
        string[] year = commaDelimited.Split(new char[] { });
        /////////////////////////////////////////
        //string[] r = { "TV", "Radio", "Coal" };
        string filter = string.Empty;
        foreach (string name in year)
        {
            if (filter.Length > 0)
            {
                filter += ",";
            }
            filter += string.Format("'{0}'", name);
        }
        SqlDataAdapter adp;
        DataSet ds = new DataSet();
        adp = new SqlDataAdapter("Select * from EMP_DET where FName IN (Like '%(" + filter + ")%')", con);
        adp.Fill(ds, "EMP_DET");
        dataGridView1.DataSource = ds.Tables[0].DefaultView;
    }
    catch
    { }
}

Posted 5-Apr-11 23:38pm

Banajyotsna

Updated 5-Apr-11 23:41pm

JOAT-MON

v2

Add a Solution

Comments

JOAT-MON 6-Apr-11 5:42am

wrapped code block

Ankur^\m/ 6-Apr-11 5:59am

"Select * from EMP_DET where FName IN (Like '%(" + filter + ")%')"

This part is wrong. It doesn't work like this. Search Google for dynamic sql and do some research on how to pass such comma separated parameter.

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)

OriginalGriff · Answer 1 · 2011-04-06T00:48:00

Solution 1

The SQL LIKE operator does not work like that - see here: http://www.w3schools.com/sql/sql_like.asp[^]

Instead, you need to build your command with a range of conditions:

SQL

SELECT * FROM EMP_DET WHERE FName LIKE %word1% OR FName LIKE %word2%

Posted 6-Apr-11 0:48am

OriginalGriff

Comments

Banajyotsna 6-Apr-11 10:16am

But in my query filter contains the splitted words of sentence putted through the textbox.which is matching one by one words of that sentence and retrieving the datas.my question how it will retrieve the related data of word(i want to put Like keyword to match the latter of those splitted word).please try to understand my query.retrieve datas from database by matching latter of those splitted word.Ex-google search.I think it will succeed if we will use IN and LIKE sql commands in one SQLquery.But i do not know how to use in a single query

OriginalGriff 6-Apr-11 10:43am

You can't. The SQL IN operator only works with a list of values: LIKE does not return such.
It *may* be possible with a stored procedure to return a list of all records that are LIKE a word, and convert them into a list suitable for handing to IN, but it's a nasty way to do it!

Instead, change your filter generation to generate the "FName LIKE %word%" clauses instead of comma separating them.