internal List<string> getCommodityNames()
{
String sqlString;
DataTable Data;
List<string> retValue = new List<string>();
try
{
Data = new DataTable();
sqlString = "select loccommodity from tbCommodity";
Program.DBCon.Execute(sqlString, Data);
foreach (DataRow currentRow in Data.Rows)
retValue.Add((String)currentRow["loccommodity"]);
return retValue;
}
catch (Exception ex)
{
throw new Exception("Error while getting names of all commodities", ex);
}
}