/// <summary> /// Execute the SQL statement returns the result to the DataSet /// </summary> /// <param Name="strSQL"> </ param> /// <returns> DataSet </ returns> public DataSet ReturnDataSet(string strSQL) { DataSet _DataSet = null; try { _TrackerDbConn.Open(); _DataSet = new DataSet(); OleDbDataAdapter _OleDbDA = new OleDbDataAdapter(strSQL, _TrackerDbConn); _OleDbDA.Fill(_DataSet, "objDataSet"); } catch (OleDbException _ex) { // Handle exception. TrackerTools _Tools = new TrackerTools(); _Tools.SetTrackerSessionErrorString(_ex.Message); _DataSet.Dispose(); throw; } finally { _TrackerDbConn.Close(); } return(_DataSet); }
public OleDbDataReader ReturnDataReader(string strSQL) { OleDbDataReader _OleDataReader = null; try { _TrackerDbConn.Open(); OleDbCommand _cmd = new OleDbCommand(strSQL, TrackerDbConn); _OleDataReader = _cmd.ExecuteReader(); } catch (OleDbException _ex) { // Handle exception. TrackerTools _Tools = new TrackerTools(); _Tools.SetTrackerSessionErrorString(_ex.Message); _OleDataReader.Dispose(); } finally { /// } return(_OleDataReader); }