// public class constructor public clsFoodCollection() { clsDataConnection DB = new clsDataConnection(); DB.Execute("sproc_tblFood_SelectAll"); // get the count Int32 RecordCount = DB.Count; // set index Int32 Index = 0; // while loop while (Index < RecordCount) { // create class instance clsFood Food = new clsFood(); // get data Food.FoodID = Convert.ToInt32(DB.DataTable.Rows[Index]["FoodID"]); Food.FoodName = Convert.ToString(DB.DataTable.Rows[Index]["FoodName"]); Food.FoodType = Convert.ToString(DB.DataTable.Rows[Index]["FoodType"]); Food.SellPrice = Convert.ToDecimal(DB.DataTable.Rows[Index]["SellPrice"]); // add record mFoods.Add(Food); // increment index Index++; } }
//public constructor for the class public clsFoodCollection() { //var for the index Int32 Index = 0; //var to store the record count Int32 RecordCount = 0; //object for data connection clsDataConnection DB = new clsDataConnection(); //execute the stored procedure DB.Execute("sproc_tblFood_SelectAll"); //get the count of records RecordCount = DB.Count; //while there are records to process while (Index < RecordCount) { //create a blank address clsFood AFood = new clsFood(); //read in the fields from the current record AFood.FoodID = Convert.ToInt32(DB.DataTable.Rows[Index]["FoodID"]); AFood.FoodName = Convert.ToString(DB.DataTable.Rows[Index]["FoodName"]); AFood.FoodPrice = Convert.ToString(DB.DataTable.Rows[Index]["FoodPrice"]); AFood.Quantity = Convert.ToString(DB.DataTable.Rows[Index]["Quantity"]); //add the record to the private data member foodList.Add(AFood); //point at the next record Index++; } }