public bool IsExistData(string _strSQL)
{
DataBaseHelper _db = new DataBaseHelper();
DataTable _dt=_db.getTable(base.ConnectionString, false, _strSQL);
if (_dt.Rows.Count > 0)
return true;
else
return false;
}
public DataTable ExecuteSQLQuery(string _strSQL)
{
DataTable _dt=new DataTable();
DataBaseHelper _db = new DataBaseHelper();
try
{
_dt = _db.getTable(base.ConnectionString, false, _strSQL);
return _dt;
}
catch (Exception ex)
{
throw new Exception("DAL::Queries::ExecuteSQL::" + ex.Message);
}
finally
{
_dt = null;
_db = null;
}
}