Adding Parameters to WHERE clause in DataAdapter

[Mike D]

What am I doing wrong? I want to be able to add parameters to my WHERE
clause in my sqlDataAdapter. I also want to use LIKE. (ie. style_cd like
"%123%"

sqlDataAdapter1.SelectCommand.Parameters.Add("@sty le_cd",SqlDbType.VarChar,15);

sqlDataAdapter1.SelectCommand.Parameters["@style_cd"].Value =
txt_style.Text;

dataSet11.Clear();

sqlDataAdapter1.Fill(dataSet11);

DataGrid1.DataBind();

[VJ]

Whats the error you are getting? , could also post the SQL statment (just
the part were parameter is being used)

VJ

"Mike D" <md*****@nospambennettcompany.com> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

What am I doing wrong? I want to be able to add parameters to my WHERE
clause in my sqlDataAdapter. I also want to use LIKE. (ie. style_cd like
"%123%"

sqlDataAdapter1.SelectCommand.Parameters.Add("@sty le_cd",SqlDbType.VarChar,15);

sqlDataAdapter1.SelectCommand.Parameters["@style_cd"].Value =
txt_style.Text;

dataSet11.Clear();

sqlDataAdapter1.Fill(dataSet11);

DataGrid1.DataBind();

[Mike D]

I don't get an error message. It just returns all the rows in the database.

"VJ" <vi********@yahoo.com> wrote in message
news:uU**************@TK2MSFTNGP12.phx.gbl...

Whats the error you are getting? , could also post the SQL statment (just
the part were parameter is being used)

VJ

"Mike D" <md*****@nospambennettcompany.com> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

What am I doing wrong? I want to be able to add parameters to my WHERE
clause in my sqlDataAdapter. I also want to use LIKE. (ie. style_cd like
"%123%"

sqlDataAdapter1.SelectCommand.Parameters.Add("@sty le_cd",SqlDbType.VarChar,15);

sqlDataAdapter1.SelectCommand.Parameters["@style_cd"].Value =
txt_style.Text;

dataSet11.Clear();

sqlDataAdapter1.Fill(dataSet11);

DataGrid1.DataBind();

[Ravichandran J.V.]

What is the error ?

with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!