public DataSet ExecuteDataSet(CommandType cmdType, string cmdText, params DbParameter[] commandParameters)
{
IDbCommand cmd = dbF.CreateCommand();
using (IDbConnection conn = dbF.CreateConnection())
{
//通过PrePareCommand方法将参数逐个加入到IDbCommand的参数集合中
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
IDbDataAdapter sda = dbF.CreateDataAdapter();
sda.InsertCommand = cmd;
sda.DeleteCommand = cmd;
sda.SelectCommand = cmd;
sda.UpdateCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds);
//清空IDbCommand中的参数列表
cmd.Parameters.Clear();
conn.Close();
return(ds); //注意:这里改了
}
}
