Question

在C#里面如何写参数化sql语句，参数个数不定，就像多条件查询(2)

Answer 1

for (int i = 0; i < temp.Length; i++){sb.Append(temp[i]);}comm.CommandText = sb.ToString();}}if (comm.Connection.State != ConnectionState.Open){comm.Connection.Open();}return comm.ExecuteReader(CommandBehavior.CloseConnection);}调用的时候类似：ExecuteReaderParams(comm, "select * from xx where id=? and name=?",id,name); ------解决方案--------------------------------------------------------如果是多条件查询的话 存储过程里面就一个参数就够了 这个参数是不定条件查询语句