传入参数时,两个以上便会报错,因此需要代入{0}
public DataTable dtOutput(DB2Connection db2Conn, string 需要传入的)
{
DB2DataAdapter adpter = new DB2DataAdapter();
DataTable dt = new DataTable();
String strSQLQuery = @"SELECT
A.name
FROM
A
WHERE
A.firstname IN ('A', 'B')
AND A.lastName in ({0})
";
try
{
adpter = new DB2DataAdapter(String.Format(strSQLQuery, 需要传入的), db2Conn);
adpter.SelectCommand.CommandTimeout = Const.TIMEOUT;
adpter.Fill(dt);
}
return dt;
}