它认为最简单的方法是动态SQL生成：
// assuming select is a SqlCommandstring[] values = "A,B,C,D,E,F".Split(',');StringBuilder query = new StringBuilder();query.Append("select * from tbl_test where tbl_test.pre in (");int i = 0;foreach (string value in values) { string paramName = "@p" + i++; query.Append(paramName); select.Parameters.AddWithValue(paramName, value);}query.Append(")");select.CommandText = query.ToString();// and then execute the select Command
