Adding Parameters to WHERE clause in DataAdapter

  • Thread starter Thread starter Mike D
  • Start date Start date
M

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("@style_cd",SqlDbType.VarChar,15);

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

dataSet11.Clear();

sqlDataAdapter1.Fill(dataSet11);

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

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



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

VJ

Mike D said:
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("@style_cd",SqlDbType.VarChar,15);

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

dataSet11.Clear();

sqlDataAdapter1.Fill(dataSet11);

DataGrid1.DataBind();
Click to expand...
Click to expand...
 
Back
Top