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