I have a sort button and I have a texbox.I have written a query which sorts a particular text given in a textbox.Suppose I have written Team in a textbox and click the sort button then all the line of text will be displayed which contains "Team".But supposing if I want to search the line containing 2 or 3 or 4 or any number of text..What should be the query...?Lets say,I have written team,Manager,Leader and press sort button,then all the line should be displayed containing the team or manager or leader.The text in a texbox can be of any words serperated by ,
what is the query to retrieve the data based on many texts?
I am using c# for this
Loading
Amit ChoudharyPosted Feb 25, 2010, 8:26 AM
you can create an array by splitting the text of your text box and add it to your query... like below
string Text = "Team, Leader, Manager";
string query = "select * from Table_sql where ";
string[] keys = new string[100];
keys = Text.Split(',');
for (int i = 0; i < keys.Length; i++)
{
if (i == 1)
{
query += "Keyword like '%" + keys[i].Trim() + "%'";
}
else
{
query += " OR Keyword like '%" + keys[i].Trim() + "%'";
}
}
Please mark the answer if it helps.