internal Sales_by_YearRow(System.Data.DataRowBuilder rb) : 
         base(rb) {
     this.tableSales_by_Year = ((Sales_by_YearDataTable)(this.Table));
 }
 internal void InitVars(bool initTable) {
     this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
     if ((initTable == true)) {
         if ((this.tableCategories != null)) {
             this.tableCategories.InitVars();
         }
     }
     this.tableCustomerCustomerDemo = ((CustomerCustomerDemoDataTable)(base.Tables["CustomerCustomerDemo"]));
     if ((initTable == true)) {
         if ((this.tableCustomerCustomerDemo != null)) {
             this.tableCustomerCustomerDemo.InitVars();
         }
     }
     this.tableCustomerDemographics = ((CustomerDemographicsDataTable)(base.Tables["CustomerDemographics"]));
     if ((initTable == true)) {
         if ((this.tableCustomerDemographics != null)) {
             this.tableCustomerDemographics.InitVars();
         }
     }
     this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
     if ((initTable == true)) {
         if ((this.tableCustomers != null)) {
             this.tableCustomers.InitVars();
         }
     }
     this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
     if ((initTable == true)) {
         if ((this.tableEmployees != null)) {
             this.tableEmployees.InitVars();
         }
     }
     this.tableEmployeeTerritories = ((EmployeeTerritoriesDataTable)(base.Tables["EmployeeTerritories"]));
     if ((initTable == true)) {
         if ((this.tableEmployeeTerritories != null)) {
             this.tableEmployeeTerritories.InitVars();
         }
     }
     this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
     if ((initTable == true)) {
         if ((this.tableOrder_Details != null)) {
             this.tableOrder_Details.InitVars();
         }
     }
     this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
     if ((initTable == true)) {
         if ((this.tableOrders != null)) {
             this.tableOrders.InitVars();
         }
     }
     this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
     if ((initTable == true)) {
         if ((this.tableProducts != null)) {
             this.tableProducts.InitVars();
         }
     }
     this.tableRegion = ((RegionDataTable)(base.Tables["Region"]));
     if ((initTable == true)) {
         if ((this.tableRegion != null)) {
             this.tableRegion.InitVars();
         }
     }
     this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
     if ((initTable == true)) {
         if ((this.tableShippers != null)) {
             this.tableShippers.InitVars();
         }
     }
     this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
     if ((initTable == true)) {
         if ((this.tableSuppliers != null)) {
             this.tableSuppliers.InitVars();
         }
     }
     this.tableTerritories = ((TerritoriesDataTable)(base.Tables["Territories"]));
     if ((initTable == true)) {
         if ((this.tableTerritories != null)) {
             this.tableTerritories.InitVars();
         }
     }
     this.tableAlphabetical_list_of_products = ((Alphabetical_list_of_productsDataTable)(base.Tables["Alphabetical list of products"]));
     if ((initTable == true)) {
         if ((this.tableAlphabetical_list_of_products != null)) {
             this.tableAlphabetical_list_of_products.InitVars();
         }
     }
     this.tableCategory_Sales_for_1997 = ((Category_Sales_for_1997DataTable)(base.Tables["Category Sales for 1997"]));
     if ((initTable == true)) {
         if ((this.tableCategory_Sales_for_1997 != null)) {
             this.tableCategory_Sales_for_1997.InitVars();
         }
     }
     this.tableCurrent_Product_List = ((Current_Product_ListDataTable)(base.Tables["Current Product List"]));
     if ((initTable == true)) {
         if ((this.tableCurrent_Product_List != null)) {
             this.tableCurrent_Product_List.InitVars();
         }
     }
     this.tableCustomer_and_Suppliers_by_City = ((Customer_and_Suppliers_by_CityDataTable)(base.Tables["Customer and Suppliers by City"]));
     if ((initTable == true)) {
         if ((this.tableCustomer_and_Suppliers_by_City != null)) {
             this.tableCustomer_and_Suppliers_by_City.InitVars();
         }
     }
     this.tableInvoices = ((InvoicesDataTable)(base.Tables["Invoices"]));
     if ((initTable == true)) {
         if ((this.tableInvoices != null)) {
             this.tableInvoices.InitVars();
         }
     }
     this.tableOrder_Details_Extended = ((Order_Details_ExtendedDataTable)(base.Tables["Order Details Extended"]));
     if ((initTable == true)) {
         if ((this.tableOrder_Details_Extended != null)) {
             this.tableOrder_Details_Extended.InitVars();
         }
     }
     this.tableOrder_Subtotals = ((Order_SubtotalsDataTable)(base.Tables["Order Subtotals"]));
     if ((initTable == true)) {
         if ((this.tableOrder_Subtotals != null)) {
             this.tableOrder_Subtotals.InitVars();
         }
     }
     this.tableOrders_Qry = ((Orders_QryDataTable)(base.Tables["Orders Qry"]));
     if ((initTable == true)) {
         if ((this.tableOrders_Qry != null)) {
             this.tableOrders_Qry.InitVars();
         }
     }
     this.tableProduct_Sales_for_1997 = ((Product_Sales_for_1997DataTable)(base.Tables["Product Sales for 1997"]));
     if ((initTable == true)) {
         if ((this.tableProduct_Sales_for_1997 != null)) {
             this.tableProduct_Sales_for_1997.InitVars();
         }
     }
     this.tableProducts_Above_Average_Price = ((Products_Above_Average_PriceDataTable)(base.Tables["Products Above Average Price"]));
     if ((initTable == true)) {
         if ((this.tableProducts_Above_Average_Price != null)) {
             this.tableProducts_Above_Average_Price.InitVars();
         }
     }
     this.tableProducts_by_Category = ((Products_by_CategoryDataTable)(base.Tables["Products by Category"]));
     if ((initTable == true)) {
         if ((this.tableProducts_by_Category != null)) {
             this.tableProducts_by_Category.InitVars();
         }
     }
     this.tableQuarterly_Orders = ((Quarterly_OrdersDataTable)(base.Tables["Quarterly Orders"]));
     if ((initTable == true)) {
         if ((this.tableQuarterly_Orders != null)) {
             this.tableQuarterly_Orders.InitVars();
         }
     }
     this.tableSales_by_Category = ((Sales_by_CategoryDataTable)(base.Tables["Sales by Category"]));
     if ((initTable == true)) {
         if ((this.tableSales_by_Category != null)) {
             this.tableSales_by_Category.InitVars();
         }
     }
     this.tableSales_Totals_by_Amount = ((Sales_Totals_by_AmountDataTable)(base.Tables["Sales Totals by Amount"]));
     if ((initTable == true)) {
         if ((this.tableSales_Totals_by_Amount != null)) {
             this.tableSales_Totals_by_Amount.InitVars();
         }
     }
     this.tableSummary_of_Sales_by_Quarter = ((Summary_of_Sales_by_QuarterDataTable)(base.Tables["Summary of Sales by Quarter"]));
     if ((initTable == true)) {
         if ((this.tableSummary_of_Sales_by_Quarter != null)) {
             this.tableSummary_of_Sales_by_Quarter.InitVars();
         }
     }
     this.tableSummary_of_Sales_by_Year = ((Summary_of_Sales_by_YearDataTable)(base.Tables["Summary of Sales by Year"]));
     if ((initTable == true)) {
         if ((this.tableSummary_of_Sales_by_Year != null)) {
             this.tableSummary_of_Sales_by_Year.InitVars();
         }
     }
     this.tableCustOrderHist = ((CustOrderHistDataTable)(base.Tables["CustOrderHist"]));
     if ((initTable == true)) {
         if ((this.tableCustOrderHist != null)) {
             this.tableCustOrderHist.InitVars();
         }
     }
     this.tableCustOrdersDetail = ((CustOrdersDetailDataTable)(base.Tables["CustOrdersDetail"]));
     if ((initTable == true)) {
         if ((this.tableCustOrdersDetail != null)) {
             this.tableCustOrdersDetail.InitVars();
         }
     }
     this.tableCustOrdersOrders = ((CustOrdersOrdersDataTable)(base.Tables["CustOrdersOrders"]));
     if ((initTable == true)) {
         if ((this.tableCustOrdersOrders != null)) {
             this.tableCustOrdersOrders.InitVars();
         }
     }
     this.tableEmployee_Sales_by_Country = ((Employee_Sales_by_CountryDataTable)(base.Tables["Employee Sales by Country"]));
     if ((initTable == true)) {
         if ((this.tableEmployee_Sales_by_Country != null)) {
             this.tableEmployee_Sales_by_Country.InitVars();
         }
     }
     this.tableSales_by_Year = ((Sales_by_YearDataTable)(base.Tables["Sales by Year"]));
     if ((initTable == true)) {
         if ((this.tableSales_by_Year != null)) {
             this.tableSales_by_Year.InitVars();
         }
     }
     this.tableSalesByCategory = ((SalesByCategoryDataTable)(base.Tables["SalesByCategory"]));
     if ((initTable == true)) {
         if ((this.tableSalesByCategory != null)) {
             this.tableSalesByCategory.InitVars();
         }
     }
     this.tableTen_Most_Expensive_Products = ((Ten_Most_Expensive_ProductsDataTable)(base.Tables["Ten Most Expensive Products"]));
     if ((initTable == true)) {
         if ((this.tableTen_Most_Expensive_Products != null)) {
             this.tableTen_Most_Expensive_Products.InitVars();
         }
     }
     this.relationFK_CustomerCustomerDemo = this.Relations["FK_CustomerCustomerDemo"];
     this.relationFK_CustomerCustomerDemo_Customers = this.Relations["FK_CustomerCustomerDemo_Customers"];
     this.relationFK_Employees_Employees = this.Relations["FK_Employees_Employees"];
     this.relationFK_EmployeeTerritories_Employees = this.Relations["FK_EmployeeTerritories_Employees"];
     this.relationFK_EmployeeTerritories_Territories = this.Relations["FK_EmployeeTerritories_Territories"];
     this.relationFK_Order_Details_Orders = this.Relations["FK_Order_Details_Orders"];
     this.relationFK_Order_Details_Products = this.Relations["FK_Order_Details_Products"];
     this.relationFK_Orders_Customers = this.Relations["FK_Orders_Customers"];
     this.relationFK_Orders_Employees = this.Relations["FK_Orders_Employees"];
     this.relationFK_Orders_Shippers = this.Relations["FK_Orders_Shippers"];
     this.relationFK_Products_Categories = this.Relations["FK_Products_Categories"];
     this.relationFK_Products_Suppliers = this.Relations["FK_Products_Suppliers"];
     this.relationFK_Territories_Region = this.Relations["FK_Territories_Region"];
 }
 private void InitClass() {
     this.DataSetName = "NorthwindDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableCategories = new CategoriesDataTable();
     base.Tables.Add(this.tableCategories);
     this.tableCustomerCustomerDemo = new CustomerCustomerDemoDataTable();
     base.Tables.Add(this.tableCustomerCustomerDemo);
     this.tableCustomerDemographics = new CustomerDemographicsDataTable();
     base.Tables.Add(this.tableCustomerDemographics);
     this.tableCustomers = new CustomersDataTable();
     base.Tables.Add(this.tableCustomers);
     this.tableEmployees = new EmployeesDataTable();
     base.Tables.Add(this.tableEmployees);
     this.tableEmployeeTerritories = new EmployeeTerritoriesDataTable();
     base.Tables.Add(this.tableEmployeeTerritories);
     this.tableOrder_Details = new Order_DetailsDataTable();
     base.Tables.Add(this.tableOrder_Details);
     this.tableOrders = new OrdersDataTable();
     base.Tables.Add(this.tableOrders);
     this.tableProducts = new ProductsDataTable();
     base.Tables.Add(this.tableProducts);
     this.tableRegion = new RegionDataTable();
     base.Tables.Add(this.tableRegion);
     this.tableShippers = new ShippersDataTable();
     base.Tables.Add(this.tableShippers);
     this.tableSuppliers = new SuppliersDataTable();
     base.Tables.Add(this.tableSuppliers);
     this.tableTerritories = new TerritoriesDataTable();
     base.Tables.Add(this.tableTerritories);
     this.tableAlphabetical_list_of_products = new Alphabetical_list_of_productsDataTable();
     base.Tables.Add(this.tableAlphabetical_list_of_products);
     this.tableCategory_Sales_for_1997 = new Category_Sales_for_1997DataTable();
     base.Tables.Add(this.tableCategory_Sales_for_1997);
     this.tableCurrent_Product_List = new Current_Product_ListDataTable();
     base.Tables.Add(this.tableCurrent_Product_List);
     this.tableCustomer_and_Suppliers_by_City = new Customer_and_Suppliers_by_CityDataTable();
     base.Tables.Add(this.tableCustomer_and_Suppliers_by_City);
     this.tableInvoices = new InvoicesDataTable();
     base.Tables.Add(this.tableInvoices);
     this.tableOrder_Details_Extended = new Order_Details_ExtendedDataTable();
     base.Tables.Add(this.tableOrder_Details_Extended);
     this.tableOrder_Subtotals = new Order_SubtotalsDataTable();
     base.Tables.Add(this.tableOrder_Subtotals);
     this.tableOrders_Qry = new Orders_QryDataTable();
     base.Tables.Add(this.tableOrders_Qry);
     this.tableProduct_Sales_for_1997 = new Product_Sales_for_1997DataTable();
     base.Tables.Add(this.tableProduct_Sales_for_1997);
     this.tableProducts_Above_Average_Price = new Products_Above_Average_PriceDataTable();
     base.Tables.Add(this.tableProducts_Above_Average_Price);
     this.tableProducts_by_Category = new Products_by_CategoryDataTable();
     base.Tables.Add(this.tableProducts_by_Category);
     this.tableQuarterly_Orders = new Quarterly_OrdersDataTable();
     base.Tables.Add(this.tableQuarterly_Orders);
     this.tableSales_by_Category = new Sales_by_CategoryDataTable();
     base.Tables.Add(this.tableSales_by_Category);
     this.tableSales_Totals_by_Amount = new Sales_Totals_by_AmountDataTable();
     base.Tables.Add(this.tableSales_Totals_by_Amount);
     this.tableSummary_of_Sales_by_Quarter = new Summary_of_Sales_by_QuarterDataTable();
     base.Tables.Add(this.tableSummary_of_Sales_by_Quarter);
     this.tableSummary_of_Sales_by_Year = new Summary_of_Sales_by_YearDataTable();
     base.Tables.Add(this.tableSummary_of_Sales_by_Year);
     this.tableCustOrderHist = new CustOrderHistDataTable();
     base.Tables.Add(this.tableCustOrderHist);
     this.tableCustOrdersDetail = new CustOrdersDetailDataTable();
     base.Tables.Add(this.tableCustOrdersDetail);
     this.tableCustOrdersOrders = new CustOrdersOrdersDataTable();
     base.Tables.Add(this.tableCustOrdersOrders);
     this.tableEmployee_Sales_by_Country = new Employee_Sales_by_CountryDataTable();
     base.Tables.Add(this.tableEmployee_Sales_by_Country);
     this.tableSales_by_Year = new Sales_by_YearDataTable();
     base.Tables.Add(this.tableSales_by_Year);
     this.tableSalesByCategory = new SalesByCategoryDataTable();
     base.Tables.Add(this.tableSalesByCategory);
     this.tableTen_Most_Expensive_Products = new Ten_Most_Expensive_ProductsDataTable();
     base.Tables.Add(this.tableTen_Most_Expensive_Products);
     this.relationFK_CustomerCustomerDemo = new System.Data.DataRelation("FK_CustomerCustomerDemo", new System.Data.DataColumn[] {
                 this.tableCustomerDemographics.CustomerTypeIDColumn}, new System.Data.DataColumn[] {
                 this.tableCustomerCustomerDemo.CustomerTypeIDColumn}, false);
     this.Relations.Add(this.relationFK_CustomerCustomerDemo);
     this.relationFK_CustomerCustomerDemo_Customers = new System.Data.DataRelation("FK_CustomerCustomerDemo_Customers", new System.Data.DataColumn[] {
                 this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
                 this.tableCustomerCustomerDemo.CustomerIDColumn}, false);
     this.Relations.Add(this.relationFK_CustomerCustomerDemo_Customers);
     this.relationFK_Employees_Employees = new System.Data.DataRelation("FK_Employees_Employees", new System.Data.DataColumn[] {
                 this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
                 this.tableEmployees.ReportsToColumn}, false);
     this.Relations.Add(this.relationFK_Employees_Employees);
     this.relationFK_EmployeeTerritories_Employees = new System.Data.DataRelation("FK_EmployeeTerritories_Employees", new System.Data.DataColumn[] {
                 this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
                 this.tableEmployeeTerritories.EmployeeIDColumn}, false);
     this.Relations.Add(this.relationFK_EmployeeTerritories_Employees);
     this.relationFK_EmployeeTerritories_Territories = new System.Data.DataRelation("FK_EmployeeTerritories_Territories", new System.Data.DataColumn[] {
                 this.tableTerritories.TerritoryIDColumn}, new System.Data.DataColumn[] {
                 this.tableEmployeeTerritories.TerritoryIDColumn}, false);
     this.Relations.Add(this.relationFK_EmployeeTerritories_Territories);
     this.relationFK_Order_Details_Orders = new System.Data.DataRelation("FK_Order_Details_Orders", new System.Data.DataColumn[] {
                 this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrder_Details.OrderIDColumn}, false);
     this.Relations.Add(this.relationFK_Order_Details_Orders);
     this.relationFK_Order_Details_Products = new System.Data.DataRelation("FK_Order_Details_Products", new System.Data.DataColumn[] {
                 this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrder_Details.ProductIDColumn}, false);
     this.Relations.Add(this.relationFK_Order_Details_Products);
     this.relationFK_Orders_Customers = new System.Data.DataRelation("FK_Orders_Customers", new System.Data.DataColumn[] {
                 this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.CustomerIDColumn}, false);
     this.Relations.Add(this.relationFK_Orders_Customers);
     this.relationFK_Orders_Employees = new System.Data.DataRelation("FK_Orders_Employees", new System.Data.DataColumn[] {
                 this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.EmployeeIDColumn}, false);
     this.Relations.Add(this.relationFK_Orders_Employees);
     this.relationFK_Orders_Shippers = new System.Data.DataRelation("FK_Orders_Shippers", new System.Data.DataColumn[] {
                 this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.ShipViaColumn}, false);
     this.Relations.Add(this.relationFK_Orders_Shippers);
     this.relationFK_Products_Categories = new System.Data.DataRelation("FK_Products_Categories", new System.Data.DataColumn[] {
                 this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
                 this.tableProducts.CategoryIDColumn}, false);
     this.Relations.Add(this.relationFK_Products_Categories);
     this.relationFK_Products_Suppliers = new System.Data.DataRelation("FK_Products_Suppliers", new System.Data.DataColumn[] {
                 this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
                 this.tableProducts.SupplierIDColumn}, false);
     this.Relations.Add(this.relationFK_Products_Suppliers);
     this.relationFK_Territories_Region = new System.Data.DataRelation("FK_Territories_Region", new System.Data.DataColumn[] {
                 this.tableRegion.RegionIDColumn}, new System.Data.DataColumn[] {
                 this.tableTerritories.RegionIDColumn}, false);
     this.Relations.Add(this.relationFK_Territories_Region);
 }