like: SqlDataAdapter sda = new SqlDataAdapter("select * from article where title like '% @cs %'", con); in: SqlDataAdapter sda = new SqlDataAdapter("select * from article where classId in(@cs)", con); SqlParameter p1 = new SqlParameter("@cs", SqlDbType.Int);
p1.Value = "铜";
sda.SelectCommand.Parameters.Add(p1);
DataTable dt = new DataTable();
sda.Fill(dt);
上面的两种写法都不行!!
string sql = "select * from article where title like '%"+ @cs + "%'"
SqlDataAdapter sda = new SqlDataAdapter(sql,con);in 同理