build sql query

[Howard]

How do I do this with parameterized query?
without parameterized query:
string search = "hello world search";

search = search.Replace( " ", " AND ");

SELECT * FROM TABLE1 WHERE TEXT LIKE '%' + @search + '%'
parameterized query:

SELECT * FROM TABLE1 WHERE TEXT LIKE '%' + @search + '%'

cmd.Parameters. Add("@search", SqlDbType.NVarC har).Value = search;

basically I am trying to perform a search where all the words in the
search string are present.

Howard

[S. Justin Gengo]

Howard,

You specify parameters in a text query with a question mark.

So your sql would look like:

SqlCommand.Comm andText = "SELECT * FROM TABLE1 WHERE TEXT LIKE '%'?'%'";
SqlCommand.Comm andType = CommandType.Tex t;
SqlCommand.Para meters.Add("@se arch", SqlDbType.NVarC har).Value = search;
--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"Howard" <ho*******@yaho o.com> wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.com...

How do I do this with parameterized query?
without parameterized query:
string search = "hello world search";

search = search.Replace( " ", " AND ");

SELECT * FROM TABLE1 WHERE TEXT LIKE '%' + @search + '%'
parameterized query:

SELECT * FROM TABLE1 WHERE TEXT LIKE '%' + @search + '%'

cmd.Parameters. Add("@search", SqlDbType.NVarC har).Value = search;

basically I am trying to perform a search where all the words in the
search string are present.

Howard

[Bruce Barker]

try an array and a loop:
string search = "hello world search";
cmd.CommandText = "select * from table1";
string sep = " where "
string[] terms = search.Split(' ');
for (int i =0; i < terms.length; ++i)
{
string pname = "@search" + i.ToString;
cmd.CommandText += sep + string.format(" text like '%' + {0} +
'%'",pname);
cmd.Parameters. Add(pname, SqlDbType.NVarC har).Value = terms[i];
sep = " or ";
}
-- bruce (sqlwork.com);
"Howard" <ho*******@yaho o.com> wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.com...

How do I do this with parameterized query?
without parameterized query:
string search = "hello world search";

search = search.Replace( " ", " AND ");

SELECT * FROM TABLE1 WHERE TEXT LIKE '%' + @search + '%'
parameterized query:

SELECT * FROM TABLE1 WHERE TEXT LIKE '%' + @search + '%'

cmd.Parameters. Add("@search", SqlDbType.NVarC har).Value = search;

basically I am trying to perform a search where all the words in the
search string are present.

Howard