SagaDB.MSSQLOperator.GetDataSet C# (CSharp) Method

GetDataSet() public method

��ȡDataSet
public GetDataSet ( string sql ) : DataSet
sql string SQL���
return System.Data.DataSet
        public DataSet GetDataSet(string sql)
        {
            bool criticalarea = ClientManager.enteredcriarea;
            if (criticalarea)
                ClientManager.LeaveCriticalArea();
            DatabaseWaitress.EnterCriticalArea();
            // ��
            this.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = this._conn;
            if (isTransaction == true)
            {
                cmd.Transaction = this._trans;
            }
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            cmd.CommandText = sql;
            da.SelectCommand = cmd;
            try
            {
                da.Fill(ds);
            }
            catch(Exception ex)
            {
                Logger.ShowSQL("Error on query:" + sql, null);
                Logger.ShowSQL(ex, null);
            }
            // �ͷ�
            //this.Close();
            DatabaseWaitress.LeaveCriticalArea();
            if (criticalarea)
                ClientManager.EnterCriticalArea();
            return ds;
        }