我的代码如下:
sqlcommand cmd=new ("select * from a where ID=@ID);
SqlParameterCollection tt = cmd.Parameters;
tt.AddWithValue("@ID", ID);
SqlDataAdapter rs = new SqlDataAdapter();
rs.SelectCommand = cmd;
DataSet ds = new DataSet();rs.fill(ds,"inf");请问 如果这里这么写
where ID in (@ID)tt.AddWithValue("@ID", ID);ID值为”1,2" 是否可以。。现在为什么查不到数据呢?(其实有数据)
sqlcommand cmd=new ("select * from a where ID=@ID);
SqlParameterCollection tt = cmd.Parameters;
tt.AddWithValue("@ID", ID);
SqlDataAdapter rs = new SqlDataAdapter();
rs.SelectCommand = cmd;
DataSet ds = new DataSet();rs.fill(ds,"inf");请问 如果这里这么写
where ID in (@ID)tt.AddWithValue("@ID", ID);ID值为”1,2" 是否可以。。现在为什么查不到数据呢?(其实有数据)
估计你是想select * from a where ID in (1,2)吧?