public List <UnitOfMeasure> LoadUnitOfMeasures(string whereClause)
{
List <UnitOfMeasure> umList = new List <UnitOfMeasure>();
string sqlQuery = "SELECT * FROM " + UnitOfMeasure._tableName;
sqlQuery += ((whereClause != null && whereClause.Length > 0) ? " WHERE " + whereClause : "");
try
{
OleDbCommand sqlCommand = new OleDbCommand(sqlQuery, _accessConnection);
OleDbDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
UnitOfMeasure newUm = new UnitOfMeasure();
newUm.Load(reader);
umList.Add(newUm);
}
}
catch (Exception e)
{
}
return(umList);
}