/// <summary> /// Retrieves ItemCodes from LineItems /// </summary> /// <returns></returns> public List <String> GetLineItems_ItemCodes() { List <String> toRet = new List <String>(); try { int num = 0; ds = db.ExecuteSQLStatement(SQLQueries.RetrieveLineItems_ItemCodes(), ref num); for (int i = 0; i < num; i++) { toRet.Add(ds.Tables[0].Rows[i][0].ToString()); } } catch (Exception ex) { //Just throw the exception throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } return(toRet); }