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;
}