/// <summary>
/// Submits an SQL query that expects a single record as a result, then returns the first record found
/// </summary>
/// <param name="strSQL">The select query</param>
/// <returns>REturns the first row of the record set</returns>
public DataRecord SelectQueryOneRecord(string strSQL)
{
SqlDataReader odbRead;
SqlCommand odbCommand;
DataRecord oRecord;
int iCtr;
string strName;
CheckConnection();
oRecord = new DataRecord();
odbCommand = new SqlCommand(strSQL, cdbConn);
odbCommand.CommandTimeout = cTimeoutSecs;
odbRead = odbCommand.ExecuteReader();
if (odbRead.HasRows == false)
{
oRecord.AddValue("FoundInDB", false);
odbRead.Close();
throw new Exception("The SQL query given retrned 0 rows. The query was:\n" + strSQL);
}
odbRead.Read();
oRecord.AddValue("FoundInDB", true);
for (iCtr = 0; iCtr < odbRead.FieldCount; iCtr++)
{
strName = odbRead.GetName(iCtr);
oRecord.AddValue(strName, odbRead[strName].ToString());
}
odbRead.Close();
return(oRecord);
}
/// <summary>
/// Submits an SQL query that expects multiple records as a result
/// </summary>
/// <param name="strSQL">The select query</param>
/// <returns>Returns an enumerated list of DataRecords, each DataRecord is one row from the results</returns>
public IEnumerable <DataRecord> SelectQueryMultipleRecords(string strSQL)
{
SqlDataReader odbRead;
SqlCommand odbCommand;
int iCtr;
string strName;
List <DataRecord> lRecords;
DataRecord oNewRecord;
CheckConnection();
lRecords = new List <DataRecord>();
odbCommand = new SqlCommand(strSQL, cdbConn);
odbCommand.CommandTimeout = cTimeoutSecs;
odbRead = odbCommand.ExecuteReader();
if (odbRead.HasRows == false)
{
odbRead.Close();
throw new Exception("The SQL query given retrned 0 rows. The query was:\n" + strSQL);
}
while (odbRead.Read() == true)
{
oNewRecord = new DataRecord();
oNewRecord.AddValue("FoundInDB", true);
for (iCtr = 0; iCtr < odbRead.FieldCount; iCtr++)
{
strName = odbRead.GetName(iCtr);
oNewRecord.AddValue(strName, odbRead[strName].ToString());
}
lRecords.Add(oNewRecord);
}
odbRead.Close();
return(lRecords);
}
/// <summary>
/// Submits an SQL query that expects a single record as a result, then returns the first record found
/// </summary>
/// <param name="strSQL">The select query</param>
/// <returns>REturns the first row of the record set</returns>
public DataRecord SelectQueryOneRecord(string strSQL) {
SqlDataReader odbRead;
SqlCommand odbCommand;
DataRecord oRecord;
int iCtr;
string strName;
CheckConnection();
oRecord = new DataRecord();
odbCommand = new SqlCommand(strSQL, cdbConn);
odbCommand.CommandTimeout = cTimeoutSecs;
odbRead = odbCommand.ExecuteReader();
if (odbRead.HasRows == false) {
oRecord.AddValue("FoundInDB", false);
odbRead.Close();
throw new Exception("The SQL query given retrned 0 rows. The query was:\n" + strSQL);
}
odbRead.Read();
oRecord.AddValue("FoundInDB", true);
for (iCtr = 0; iCtr < odbRead.FieldCount; iCtr++) {
strName = odbRead.GetName(iCtr);
oRecord.AddValue(strName, odbRead[strName].ToString());
}
odbRead.Close();
return oRecord;
}
/// <summary>
/// Submits an SQL query that expects multiple records as a result
/// </summary>
/// <param name="strSQL">The select query</param>
/// <returns>Returns an enumerated list of DataRecords, each DataRecord is one row from the results</returns>
public IEnumerable<DataRecord> SelectQueryMultipleRecords(string strSQL) {
SqlDataReader odbRead;
SqlCommand odbCommand;
int iCtr;
string strName;
List<DataRecord> lRecords;
DataRecord oNewRecord;
CheckConnection();
lRecords = new List<DataRecord>();
odbCommand = new SqlCommand(strSQL, cdbConn);
odbCommand.CommandTimeout = cTimeoutSecs;
odbRead = odbCommand.ExecuteReader();
if (odbRead.HasRows == false) {
odbRead.Close();
throw new Exception("The SQL query given retrned 0 rows. The query was:\n" + strSQL);
}
while (odbRead.Read() == true) {
oNewRecord = new DataRecord();
oNewRecord.AddValue("FoundInDB", true);
for (iCtr = 0; iCtr < odbRead.FieldCount; iCtr++) {
strName = odbRead.GetName(iCtr);
oNewRecord.AddValue(strName, odbRead[strName].ToString());
}
lRecords.Add(oNewRecord);
}
odbRead.Close();
return lRecords;
}