internal Order_SubtotalsRow(System.Data.DataRowBuilder rb) : base(rb) { this.tableOrder_Subtotals = ((Order_SubtotalsDataTable)(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); }