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); //注意:这里改了 } }