IBE.SQL.EliteDBIO.getCommodityNames C# (CSharp) Method

        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);
            }
        }