如我本来的SQL语名是拼接的
String sql="Select * From Tab Wehre Name = '" + Name + "'";
改为传参数就为
String sql="Select * From Tab Wehre Name = @Name"; 但
String sql="Select * From Tab Wehre Name Like '%" + Name + "'%";
这样改为传参是怎么改 String sql="Select * From Tab Wehre Name Like %@Name%"; 这样吗??? 谢谢
String sql="Select * From Tab Wehre Name = '" + Name + "'";
改为传参数就为
String sql="Select * From Tab Wehre Name = @Name"; 但
String sql="Select * From Tab Wehre Name Like '%" + Name + "'%";
这样改为传参是怎么改 String sql="Select * From Tab Wehre Name Like %@Name%"; 这样吗??? 谢谢
-----------------------------------------------------------------
这里是我随手写的,主要问题是,那个传参的要怎么写 谢谢
SqlCommand cmd = new SqlCommand(strSql, cn);
cmd.Parameters.AddWithValue("@Name", "%" + name + "%");
string strSql = "Select * From Tab Wehre Name = @Name";
SqlCommand cmd = new SqlCommand(strSql, cn);
cmd.Parameters.AddWithValue("@Name", "%" + name + "%");上面的方式和String sql="Select * From Tab Wehre Name Like '%" + Name + "'%"; 一样吗
这里是 Like 啊 还是 = 啊
谢谢
String sql="Select * From Tab Wehre Name Like @Name"; SqlParameter parm = new SqlParameter("@Name", "%"+name+"%");
string strSql = "Select * From Tab Wehre Name like '%'+@Name+'%'";
SqlCommand cmd = new SqlCommand(strSql, cn);
cmd.Parameters.AddWithValue("@Name", name);
--------------------------------
这样会不会变成了拼接语句了呢谢谢
给值的时候再拼:
parame["@name"].value = "%" + name + "%";