}//UpdateItemToDatabase /// <summary> /// Clear_Database_Table - delete all records from the table "user" in the database /// <input> theTable - the table name</input> /// </summary> public void Clear_Database_Table() { string strCommand = "DELETE FROM " + theTable; if (!DBUtils.ExecuteSqlNonQuery(strCommand)) { LogManager.writeToLog(" ExecuteSqlNonQuery returned: FALSE; in user.cs:Clear_Database_Table. ExecuteSqlNonQuery"); } }//Clear_Database_Table
}//UpdateItemToDatabas //--------------------------------------------------------------------------------------------------------------- /// <summary> /// Clear_Database_Table - delete all records from the table "mapping_note" database /// <input> theTable - the table name</input> /// </summary> public void Clear_Database_Table() { if (CountRows() == 0) { return; } string strCommand = "DELETE FROM " + theTable; if (!DBUtils.ExecuteSqlNonQuery(strCommand)) { LogManager.writeToLog(" ExecuteSqlNonQuery returned: FALSE; in mapping_note_Table.cs:Clear_Database_Table.ExecuteSqlNonQuery()"); } }
}//UpdateItemToDatabase //--------------------------------------------------------------------------------------------------------------- /// <summary> /// Clear_Database_Table - delete all records from the table "affirmation" database /// <input> theTable - the table name</input> /// </summary> public void Clear_Database_Table() { if (CountRows() == 0) { return; } string strCommand = "DELETE FROM " + theTable; // Delete all rows from TABLE if (!DBUtils.ExecuteSqlNonQuery(strCommand)) { LogManager.writeToLog("ExecuteSqlNonQuery returned: FALSE; in affirmation_Table.cs:Clear_Database_Table.ExecuteSqlNonQuery()"); } }//Clear_Database_Table
}//UpdateItemToDatabase //--------------------------------------------------------------------------------------------------------------- /// <summary> /// Clear_Database_Table - delete all records from the table "process_area" in the database /// <input> theTable - the table name</input> /// </summary> public void Clear_Database_Table() { if (CountRows() == 0) { return; } string strCommand = "DELETE from " + theTable; if (!DBUtils.ExecuteSqlNonQuery(strCommand)) { LogManager.writeToLog(" ExecuteSqlNonQuery returned: FALSE; in process_area_Table.cs:Clear_Database_Table. ExecuteSqlNonQuery"); } }