void PopulateArray(clsDataConnection DB) { Int32 Index = 0; Int32 RecordCount = 0; Int32 SearchOrderId = 0; RecordCount = DB.Count; mOrdersList = new List <clsOrders>(); //While there are records while (Index < RecordCount) { //Create a blank order clsOrders Orders = new clsOrders(); //Read in fields from current record and assign to tblOrder object attributes Orders.OrderId = Convert.ToInt32(DB.DataTable.Rows[Index]["OrderId"]); SearchOrderId = Convert.ToInt32(DB.DataTable.Rows[Index]["OrderId"]); Orders.DispatchedStatus = Convert.ToBoolean(DB.DataTable.Rows[Index]["DispatchedStatus"]); Orders.DeliveryAddress = Convert.ToString(DB.DataTable.Rows[Index]["DeliveryAddress"]); Orders.OrderDate = Convert.ToDateTime(DB.DataTable.Rows[Index]["OrderDate"]); clsDataConnection DBO = new clsDataConnection(); DBO.AddParameter("@OrderId", SearchOrderId); DBO.Execute("sproc_tblOrderline_Filter_By_OrderId"); Orders.ItemId = Convert.ToInt32(DBO.DataTable.Rows[0]["ItemId"]); Orders.Quantity = Convert.ToInt32(DBO.DataTable.Rows[0]["Quantity"]); Orders.ProductCode = Convert.ToString(DBO.DataTable.Rows[0]["ProductCode"]); Orders.UnitPrice = Convert.ToDouble(DBO.DataTable.Rows[0]["UnitPrice"]); mOrdersList.Add(Orders); Index++; } }