Esempio n. 1
0
        public static DataSet ExecuteDataSet(CommandType cmdType, string cmdText, params DbParameter[] parameterValues)
        {
            DataSet result = null;
            bool    mustCloseConn;

            DbCommand cmd = PrepareCmd(cmdType, cmdText, parameterValues, out mustCloseConn);

            try
            {
                using (DbDataAdapter da = _dataProviders.GetDbDataAdappter())
                {
                    da.SelectCommand = cmd;
                    result           = new DataSet();

                    da.Fill(result);
                }
            }
            catch (Exception ex)
            {
                // ignored
            }
            if (mustCloseConn)
            {
                CloseConn(cmd.Connection);
            }
            ClearCmdParameters(cmd);
            cmd.Dispose();

            return(result);
        }