public override System.Data.DataTable Clone()
{
ShippersDataTable cln = ((ShippersDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
internal void InitVars()
{
this.tableShippers = ((ShippersDataTable)(this.Tables["Shippers"]));
if ((this.tableShippers != null))
{
this.tableShippers.InitVars();
}
}
private void InitClass()
{
this.DataSetName = "ShippersDataSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/ShippersDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
}
internal void InitVars(bool initTable)
{
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true))
{
if ((this.tableShippers != null))
{
this.tableShippers.InitVars();
}
}
}
private void InitClass()
{
this.DataSetName = "ShippersDataSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/ShippersDataSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableShippers = new ShippersDataTable();
this.Tables.Add(this.tableShippers);
}
private void InitClass() {
this.DataSetName = "AFIDBDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/AFIDBDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableColor = new ColorDataTable();
base.Tables.Add(this.tableColor);
this.tableLowColor = new LowColorDataTable();
base.Tables.Add(this.tableLowColor);
this.tableOpen_Orders = new Open_OrdersDataTable();
base.Tables.Add(this.tableOpen_Orders);
this.tableParts = new PartsDataTable();
base.Tables.Add(this.tableParts);
this.tablePartCustLink = new PartCustLinkDataTable();
base.Tables.Add(this.tablePartCustLink);
this.tablePartMaskLink = new PartMaskLinkDataTable();
base.Tables.Add(this.tablePartMaskLink);
}
private void InitClass() {
this.DataSetName = "NorthwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableProducts = new ProductsDataTable();
base.Tables.Add(this.tableProducts);
this.tableOrders = new OrdersDataTable();
base.Tables.Add(this.tableOrders);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableCategories = new CategoriesDataTable();
base.Tables.Add(this.tableCategories);
this.tableOrder_Details = new Order_DetailsDataTable();
base.Tables.Add(this.tableOrder_Details);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
System.Data.ForeignKeyConstraint fkc;
fkc = new System.Data.ForeignKeyConstraint("SuppliersProducts", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn});
this.tableProducts.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("CategoriesProducts", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn});
this.tableProducts.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("ShippersOrders", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("CustomersOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("EmployeesOrders", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn});
this.tableOrders.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("ProductsOrder Details", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
fkc = new System.Data.ForeignKeyConstraint("OrdersOrder Details", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn});
this.tableOrder_Details.Constraints.Add(fkc);
fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
fkc.DeleteRule = System.Data.Rule.Cascade;
fkc.UpdateRule = System.Data.Rule.Cascade;
this.relationSuppliersProducts = new System.Data.DataRelation("SuppliersProducts", new System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationSuppliersProducts);
this.relationCategoriesProducts = new System.Data.DataRelation("CategoriesProducts", new System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationCategoriesProducts);
this.relationShippersOrders = new System.Data.DataRelation("ShippersOrders", new System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationShippersOrders);
this.relationCustomersOrders = new System.Data.DataRelation("CustomersOrders", new System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationCustomersOrders);
this.relationEmployeesOrders = new System.Data.DataRelation("EmployeesOrders", new System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationEmployeesOrders);
this.relationProductsOrder_Details = new System.Data.DataRelation("ProductsOrder Details", new System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationProductsOrder_Details);
this.relationOrdersOrder_Details = new System.Data.DataRelation("OrdersOrder Details", new System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationOrdersOrder_Details);
this.ExtendedProperties.Add("DSGenerator_DataSetName", "NorthwindDataSet");
this.ExtendedProperties.Add("User_DataSetName", "NorthwindDataSet");
}
private void InitClass() {
this.DataSetName = "northwindDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/northwindDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::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.relationFK_CustomerCustomerDemo = new global::System.Data.DataRelation("FK_CustomerCustomerDemo", new global::System.Data.DataColumn[] {
this.tableCustomerDemographics.CustomerTypeIDColumn}, new global::System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerTypeIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo);
this.relationFK_CustomerCustomerDemo_Customers = new global::System.Data.DataRelation("FK_CustomerCustomerDemo_Customers", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableCustomerCustomerDemo.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_CustomerCustomerDemo_Customers);
this.relationFK_Employees_Employees = new global::System.Data.DataRelation("FK_Employees_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployees.ReportsToColumn}, false);
this.Relations.Add(this.relationFK_Employees_Employees);
this.relationFK_EmployeeTerritories_Employees = new global::System.Data.DataRelation("FK_EmployeeTerritories_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployeeTerritories.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Employees);
this.relationFK_EmployeeTerritories_Territories = new global::System.Data.DataRelation("FK_EmployeeTerritories_Territories", new global::System.Data.DataColumn[] {
this.tableTerritories.TerritoryIDColumn}, new global::System.Data.DataColumn[] {
this.tableEmployeeTerritories.TerritoryIDColumn}, false);
this.Relations.Add(this.relationFK_EmployeeTerritories_Territories);
this.relationFK_Order_Details_Orders = new global::System.Data.DataRelation("FK_Order_Details_Orders", new global::System.Data.DataColumn[] {
this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.OrderIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Orders);
this.relationFK_Order_Details_Products = new global::System.Data.DataRelation("FK_Order_Details_Products", new global::System.Data.DataColumn[] {
this.tableProducts.ProductIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrder_Details.ProductIDColumn}, false);
this.Relations.Add(this.relationFK_Order_Details_Products);
this.relationFK_Orders_Customers = new global::System.Data.DataRelation("FK_Orders_Customers", new global::System.Data.DataColumn[] {
this.tableCustomers.CustomerIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.CustomerIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Customers);
this.relationFK_Orders_Employees = new global::System.Data.DataRelation("FK_Orders_Employees", new global::System.Data.DataColumn[] {
this.tableEmployees.EmployeeIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.EmployeeIDColumn}, false);
this.Relations.Add(this.relationFK_Orders_Employees);
this.relationFK_Orders_Shippers = new global::System.Data.DataRelation("FK_Orders_Shippers", new global::System.Data.DataColumn[] {
this.tableShippers.ShipperIDColumn}, new global::System.Data.DataColumn[] {
this.tableOrders.ShipViaColumn}, false);
this.Relations.Add(this.relationFK_Orders_Shippers);
this.relationFK_Products_Categories = new global::System.Data.DataRelation("FK_Products_Categories", new global::System.Data.DataColumn[] {
this.tableCategories.CategoryIDColumn}, new global::System.Data.DataColumn[] {
this.tableProducts.CategoryIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Categories);
this.relationFK_Products_Suppliers = new global::System.Data.DataRelation("FK_Products_Suppliers", new global::System.Data.DataColumn[] {
this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] {
this.tableProducts.SupplierIDColumn}, false);
this.Relations.Add(this.relationFK_Products_Suppliers);
this.relationFK_Territories_Region = new global::System.Data.DataRelation("FK_Territories_Region", new global::System.Data.DataColumn[] {
this.tableRegion.RegionIDColumn}, new global::System.Data.DataColumn[] {
this.tableTerritories.RegionIDColumn}, false);
this.Relations.Add(this.relationFK_Territories_Region);
}
private void InitClass() {
this.DataSetName = "AFIDBDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/AFIDBDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
}
internal void InitVars(bool initTable) {
this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));
if ((initTable == true)) {
if ((this.tableProducts != null)) {
this.tableProducts.InitVars();
}
}
this.tableOrders = ((OrdersDataTable)(base.Tables["Orders"]));
if ((initTable == true)) {
if ((this.tableOrders != null)) {
this.tableOrders.InitVars();
}
}
this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"]));
if ((initTable == true)) {
if ((this.tableSuppliers != null)) {
this.tableSuppliers.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"]));
if ((initTable == true)) {
if ((this.tableCustomers != null)) {
this.tableCustomers.InitVars();
}
}
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.InitVars();
}
}
this.tableOrder_Details = ((Order_DetailsDataTable)(base.Tables["Order Details"]));
if ((initTable == true)) {
if ((this.tableOrder_Details != null)) {
this.tableOrder_Details.InitVars();
}
}
this.tableEmployees = ((EmployeesDataTable)(base.Tables["Employees"]));
if ((initTable == true)) {
if ((this.tableEmployees != null)) {
this.tableEmployees.InitVars();
}
}
this.relationSuppliersProducts = this.Relations["SuppliersProducts"];
this.relationCategoriesProducts = this.Relations["CategoriesProducts"];
this.relationShippersOrders = this.Relations["ShippersOrders"];
this.relationCustomersOrders = this.Relations["CustomersOrders"];
this.relationEmployeesOrders = this.Relations["EmployeesOrders"];
this.relationProductsOrder_Details = this.Relations["ProductsOrder Details"];
this.relationOrdersOrder_Details = this.Relations["OrdersOrder Details"];
}
internal void InitVars(bool initTable) {
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
}
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);
}
internal ShippersRow(System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableShippers = ((ShippersDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableCustomer = ((CustomerDataTable)(base.Tables["Customer"]));
if ((initTable == true)) {
if ((this.tableCustomer != null)) {
this.tableCustomer.InitVars();
}
}
this.tablePartCustLink = ((PartCustLinkDataTable)(base.Tables["PartCustLink"]));
if ((initTable == true)) {
if ((this.tablePartCustLink != null)) {
this.tablePartCustLink.InitVars();
}
}
this.tablePO = ((PODataTable)(base.Tables["PO"]));
if ((initTable == true)) {
if ((this.tablePO != null)) {
this.tablePO.InitVars();
}
}
this.tableSTATES = ((STATESDataTable)(base.Tables["STATES"]));
if ((initTable == true)) {
if ((this.tableSTATES != null)) {
this.tableSTATES.InitVars();
}
}
this.tableCustBillShipAddr = ((CustBillShipAddrDataTable)(base.Tables["CustBillShipAddr"]));
if ((initTable == true)) {
if ((this.tableCustBillShipAddr != null)) {
this.tableCustBillShipAddr.InitVars();
}
}
this.tableColor = ((ColorDataTable)(base.Tables["Color"]));
if ((initTable == true)) {
if ((this.tableColor != null)) {
this.tableColor.InitVars();
}
}
this.tableParts = ((PartsDataTable)(base.Tables["Parts"]));
if ((initTable == true)) {
if ((this.tableParts != null)) {
this.tableParts.InitVars();
}
}
this.tableLINESPEED = ((LINESPEEDDataTable)(base.Tables["LINESPEED"]));
if ((initTable == true)) {
if ((this.tableLINESPEED != null)) {
this.tableLINESPEED.InitVars();
}
}
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
}
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.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 = "AFIPartsDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/AFIPartsDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableCustomer = new CustomerDataTable();
base.Tables.Add(this.tableCustomer);
this.tablePartCustLink = new PartCustLinkDataTable();
base.Tables.Add(this.tablePartCustLink);
this.tablePO = new PODataTable();
base.Tables.Add(this.tablePO);
this.tableSTATES = new STATESDataTable();
base.Tables.Add(this.tableSTATES);
this.tableCustBillShipAddr = new CustBillShipAddrDataTable();
base.Tables.Add(this.tableCustBillShipAddr);
this.tableColor = new ColorDataTable();
base.Tables.Add(this.tableColor);
this.tableParts = new PartsDataTable();
base.Tables.Add(this.tableParts);
this.tableLINESPEED = new LINESPEEDDataTable();
base.Tables.Add(this.tableLINESPEED);
this.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
}
internal ShippersRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableShippers = ((ShippersDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableShippers = ((ShippersDataTable)(base.Tables["Shippers"]));
if ((initTable == true)) {
if ((this.tableShippers != null)) {
this.tableShippers.InitVars();
}
}
this.tableColor = ((ColorDataTable)(base.Tables["Color"]));
if ((initTable == true)) {
if ((this.tableColor != null)) {
this.tableColor.InitVars();
}
}
this.tableLowColor = ((LowColorDataTable)(base.Tables["LowColor"]));
if ((initTable == true)) {
if ((this.tableLowColor != null)) {
this.tableLowColor.InitVars();
}
}
this.tableOpen_Orders = ((Open_OrdersDataTable)(base.Tables["Open Orders"]));
if ((initTable == true)) {
if ((this.tableOpen_Orders != null)) {
this.tableOpen_Orders.InitVars();
}
}
this.tableParts = ((PartsDataTable)(base.Tables["Parts"]));
if ((initTable == true)) {
if ((this.tableParts != null)) {
this.tableParts.InitVars();
}
}
this.tablePartCustLink = ((PartCustLinkDataTable)(base.Tables["PartCustLink"]));
if ((initTable == true)) {
if ((this.tablePartCustLink != null)) {
this.tablePartCustLink.InitVars();
}
}
this.tablePartMaskLink = ((PartMaskLinkDataTable)(base.Tables["PartMaskLink"]));
if ((initTable == true)) {
if ((this.tablePartMaskLink != null)) {
this.tablePartMaskLink.InitVars();
}
}
}
