internal void InitVars() { this.tableProducts = ((ProductsDataTable)(this.Tables["Products"])); if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } }
private void InitClass() { this.DataSetName = "Dataset1"; this.Prefix = ""; this.Namespace = "http://tempuri.org/Dataset1.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); }
private void InitClass() { this.DataSetName = "ProductDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/ProductDataSet.xsd"; this.Locale = new System.Globalization.CultureInfo("en-US"); this.CaseSensitive = false; this.EnforceConstraints = true; this.tableProducts = new ProductsDataTable(); this.Tables.Add(this.tableProducts); }
internal void InitVars(bool initTable) { this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } }
internal void InitVars() { this.tableProducts = ((ProductsDataTable)(this.Tables["Products"])); if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } this.tableOrder_Details = ((Order_DetailsDataTable)(this.Tables["Order Details"])); if ((this.tableOrder_Details != null)) { this.tableOrder_Details.InitVars(); } }
internal void InitVars() { this.tableCategories = ((CategoriesDataTable)(this.Tables["Categories"])); if ((this.tableCategories != null)) { this.tableCategories.InitVars(); } this.tableProducts = ((ProductsDataTable)(this.Tables["Products"])); if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } this.relationCategoriesProducts = this.Relations["CategoriesProducts"]; }
private void InitClass() { this.DataSetName = "dataDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/dataDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; this.tableImages = new ImagesDataTable(); base.Tables.Add(this.tableImages); this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); }
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"); }
internal void InitVars(bool initTable) { this.tableImages = ((ImagesDataTable)(base.Tables["Images"])); if ((initTable == true)) { if ((this.tableImages != null)) { this.tableImages.InitVars(); } } this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } }
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 = "NorthwindDataSet"; this.Prefix = ""; this.Namespace = "http://www.tempuri.org/NorthwindDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableCustomers = new CustomersDataTable(); base.Tables.Add(this.tableCustomers); this.tableEmployees = new EmployeesDataTable(); base.Tables.Add(this.tableEmployees); this.tableOrderDetails = new OrderDetailsDataTable(); base.Tables.Add(this.tableOrderDetails); this.tableOrders = new OrdersDataTable(); base.Tables.Add(this.tableOrders); this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); global::System.Data.ForeignKeyConstraint fkc; fkc = new global::System.Data.ForeignKeyConstraint("OrdersOrderDetails", new global::System.Data.DataColumn[] { this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] { this.tableOrderDetails.OrderIDColumn}); this.tableOrderDetails.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.Cascade; fkc.UpdateRule = global::System.Data.Rule.Cascade; this.relationOrdersOrderDetails = new global::System.Data.DataRelation("OrdersOrderDetails", new global::System.Data.DataColumn[] { this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] { this.tableOrderDetails.OrderIDColumn}, false); this.Relations.Add(this.relationOrdersOrderDetails); }
private void InitClass() { this.DataSetName = "SuppliersProductsDataSet"; this.Prefix = ""; this.Namespace = "http://www.tempuri.org/SuppliersProductsDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); this.tableSuppliers = new SuppliersDataTable(); base.Tables.Add(this.tableSuppliers); global::System.Data.ForeignKeyConstraint fkc; fkc = new global::System.Data.ForeignKeyConstraint("FK_Suppliers_Products", new global::System.Data.DataColumn[] { this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] { this.tableProducts.SupplierIDColumn}); this.tableProducts.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.Cascade; fkc.UpdateRule = global::System.Data.Rule.Cascade; this.relationFK_Suppliers_Products = new global::System.Data.DataRelation("FK_Suppliers_Products", new global::System.Data.DataColumn[] { this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] { this.tableProducts.SupplierIDColumn}, false); this.Relations.Add(this.relationFK_Suppliers_Products); }
internal ProductsRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableProducts = ((ProductsDataTable)(this.Table)); }
internal void InitVars(bool initTable) { this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"])); if ((initTable == true)) { if ((this.tableCustomers != null)) { this.tableCustomers.InitVars(); } } this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"])); if ((initTable == true)) { if ((this.tableCategories != null)) { this.tableCategories.InitVars(); } } }
private void InitClass() { this.DataSetName = "DataSet1"; this.Prefix = ""; this.Namespace = "http://www.tempuri.org/DataSet1.xsd"; this.Locale = new global::System.Globalization.CultureInfo("zh-CN"); this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableCustomers = new CustomersDataTable(); base.Tables.Add(this.tableCustomers); this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); this.tableCategories = new CategoriesDataTable(); base.Tables.Add(this.tableCategories); }
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"]; }
public ViewModel() { Items = new dsProductsTableAdapters.ProductsTableAdapter().GetData(); }
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); }
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.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); this.tableSuppliers = new SuppliersDataTable(); base.Tables.Add(this.tableSuppliers); this.relationCategoriesProducts = new global::System.Data.DataRelation("CategoriesProducts", new global::System.Data.DataColumn[] { this.tableCategories.CategoryIDColumn}, new global::System.Data.DataColumn[] { this.tableProducts.CategoryIDColumn}, false); this.Relations.Add(this.relationCategoriesProducts); this.relationSuppliersProducts = new global::System.Data.DataRelation("SuppliersProducts", new global::System.Data.DataColumn[] { this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] { this.tableProducts.SupplierIDColumn}, false); this.Relations.Add(this.relationSuppliersProducts); }
internal void InitVars(bool initTable) { this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"])); if ((initTable == true)) { if ((this.tableCategories != null)) { this.tableCategories.InitVars(); } } this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"])); if ((initTable == true)) { if ((this.tableSuppliers != null)) { this.tableSuppliers.InitVars(); } } this.relationCategoriesProducts = this.Relations["CategoriesProducts"]; this.relationSuppliersProducts = this.Relations["SuppliersProducts"]; }
internal void InitVars(bool initTable) { 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.tableOrderDetails = ((OrderDetailsDataTable)(base.Tables["OrderDetails"])); if ((initTable == true)) { if ((this.tableOrderDetails != null)) { this.tableOrderDetails.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.relationOrders_OrderDetails = this.Relations["Orders_OrderDetails"]; }
private void InitClass() { this.DataSetName = "JSNorthWindDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/JSNorthWindDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableCustomers = new CustomersDataTable(); base.Tables.Add(this.tableCustomers); this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); this.tableSuppliers = new SuppliersDataTable(); base.Tables.Add(this.tableSuppliers); this._relation_C70C25CC_5318_47C2_BAE2_3DB01283F6C0_ = new global::System.Data.DataRelation("{C70C25CC-5318-47C2-BAE2-3DB01283F6C0}", new global::System.Data.DataColumn[] { this.tableSuppliers.SupplierIDColumn}, new global::System.Data.DataColumn[] { this.tableProducts.SupplierIDColumn}, false); this.Relations.Add(this._relation_C70C25CC_5318_47C2_BAE2_3DB01283F6C0_); }
private void InitClass() { this.DataSetName = "NorthwindDataSet"; this.Prefix = ""; this.Namespace = "http://www.tempuri.org/NorthwindDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableCustomers = new CustomersDataTable(); base.Tables.Add(this.tableCustomers); this.tableEmployees = new EmployeesDataTable(); base.Tables.Add(this.tableEmployees); this.tableOrderDetails = new OrderDetailsDataTable(); base.Tables.Add(this.tableOrderDetails); this.tableOrders = new OrdersDataTable(); base.Tables.Add(this.tableOrders); this.tableProducts = new ProductsDataTable(); base.Tables.Add(this.tableProducts); this.relationOrders_OrderDetails = new global::System.Data.DataRelation("Orders_OrderDetails", new global::System.Data.DataColumn[] { this.tableOrders.OrderIDColumn}, new global::System.Data.DataColumn[] { this.tableOrderDetails.OrderIDColumn}, false); this.Relations.Add(this.relationOrders_OrderDetails); }
internal void InitVars(bool initTable) { this.tableCustomers = ((CustomersDataTable)(base.Tables["Customers"])); if ((initTable == true)) { if ((this.tableCustomers != null)) { this.tableCustomers.InitVars(); } } this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"])); if ((initTable == true)) { if ((this.tableSuppliers != null)) { this.tableSuppliers.InitVars(); } } this._relation_C70C25CC_5318_47C2_BAE2_3DB01283F6C0_ = this.Relations["{C70C25CC-5318-47C2-BAE2-3DB01283F6C0}"]; }
internal void InitVars(bool initTable) { this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } this.tableSuppliers = ((SuppliersDataTable)(base.Tables["Suppliers"])); if ((initTable == true)) { if ((this.tableSuppliers != null)) { this.tableSuppliers.InitVars(); } } this.relationFK_Suppliers_Products = this.Relations["FK_Suppliers_Products"]; }
internal ProductsRow(System.Data.DataRowBuilder builder) : base(builder) { this.tableProducts = ((ProductsDataTable)(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.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"]; }
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 ProductsRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableProducts = ((ProductsDataTable)(this.Table)); }
public ProductsRow(System.Data.DataRowBuilder rb) : base(rb) { this.tableProducts = ((ProductsDataTable)(this.Table)); }
public void InitVars(bool initTable) { this.tableProducts = ((ProductsDataTable)(base.Tables["Products"])); if ((initTable == true)) { if ((this.tableProducts != null)) { this.tableProducts.InitVars(); } } }
public ProductsRow(System.Data.DataRowBuilder rb) : base(rb) { this.tableProducts = ((ProductsDataTable)(this.Table)); }
internal ProductsRow(DataRowBuilder rb) : base(rb) { this.tableProducts = ((ProductsDataTable)(this.Table)); }
internal void InitializeClass() { this.DataSetName = "SuposDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/TestDataSet.xsd"; this.Locale = new System.Globalization.CultureInfo("fr-BE"); this.CaseSensitive = false; this.EnforceConstraints = true; this.__tableCategories = new CategoriesDataTable(); this.Tables.Add(this.__tableCategories); this.__tableProducts = new ProductsDataTable(); this.Tables.Add(this.__tableProducts); this.__tableTaxes = new TaxesDataTable(); this.Tables.Add(this.__tableTaxes); this.__tableCustomers = new CustomersDataTable(); this.Tables.Add(this.__tableCustomers); this.__tableOrders = new OrdersDataTable(); this.Tables.Add(this.__tableOrders); this.__tableOrderDetails = new OrderDetailsDataTable(); this.Tables.Add(this.__tableOrderDetails); this.__tablePayments = new PaymentsDataTable(); this.Tables.Add(this.__tablePayments); this.__tableMeta = new MetaDataTable(); this.Tables.Add(this.__tableMeta); System.Data.UniqueConstraint uc; uc = new System.Data.UniqueConstraint("PK_Categories", new System.Data.DataColumn[] { this.__tableCategories.Columns["Id"]}, true); this.__tableCategories.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_Products", new System.Data.DataColumn[] { this.__tableProducts.Columns["Id"]}, true); this.__tableProducts.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_Taxes", new System.Data.DataColumn[] { this.__tableTaxes.Columns["Id"]}, true); this.__tableTaxes.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_Clients", new System.Data.DataColumn[] { this.__tableCustomers.Columns["Id"]}, true); this.__tableCustomers.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_Orders", new System.Data.DataColumn[] { this.__tableOrders.Columns["Id"]}, true); this.__tableOrders.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_OrderDetails", new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["Id"]}, true); this.__tableOrderDetails.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_Payment", new System.Data.DataColumn[] { this.__tablePayments.Columns["Id"]}, true); this.__tablePayments.Constraints.Add(uc); uc = new System.Data.UniqueConstraint("PK_Meta", new System.Data.DataColumn[] { this.__tableMeta.Columns["Id"]}, true); this.__tableMeta.Constraints.Add(uc); System.Data.ForeignKeyConstraint fkc; fkc = new System.Data.ForeignKeyConstraint("FK_Categories_Products", new System.Data.DataColumn[] { this.__tableCategories.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableProducts.Columns["CategoryId"]}); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.__tableProducts.Constraints.Add(fkc); fkc = new System.Data.ForeignKeyConstraint("FK_Taxes_Products", new System.Data.DataColumn[] { this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableProducts.Columns["DefaultTaxId"]}); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.__tableProducts.Constraints.Add(fkc); fkc = new System.Data.ForeignKeyConstraint("FK_Customers_Orders", new System.Data.DataColumn[] { this.__tableCustomers.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrders.Columns["CustomerId"]}); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.__tableOrders.Constraints.Add(fkc); fkc = new System.Data.ForeignKeyConstraint("FK_Orders_OrderDetails", new System.Data.DataColumn[] { this.__tableOrders.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["OrderId"]}); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.__tableOrderDetails.Constraints.Add(fkc); fkc = new System.Data.ForeignKeyConstraint("PK_Products_OrderDetails", new System.Data.DataColumn[] { this.__tableProducts.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["ProductId"]}); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.__tableOrderDetails.Constraints.Add(fkc); fkc = new System.Data.ForeignKeyConstraint("PK_Taxes_OrderDetails", new System.Data.DataColumn[] { this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["TaxId"]}); fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None; fkc.DeleteRule = System.Data.Rule.Cascade; fkc.UpdateRule = System.Data.Rule.Cascade; this.__tableOrderDetails.Constraints.Add(fkc); this.__relationFK_Orders_OrderDetailsRelation = new System.Data.DataRelation("FK_Orders_OrderDetails", new System.Data.DataColumn[] { this.__tableOrders.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["OrderId"]}, false); this.__relationFK_Orders_OrderDetailsRelation.Nested = false; this.Relations.Add(this.__relationFK_Orders_OrderDetailsRelation); this.__relationPK_Products_OrderDetailsRelation = new System.Data.DataRelation("PK_Products_OrderDetails", new System.Data.DataColumn[] { this.__tableProducts.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["ProductId"]}, false); this.__relationPK_Products_OrderDetailsRelation.Nested = false; this.Relations.Add(this.__relationPK_Products_OrderDetailsRelation); this.__relationPK_Taxes_OrderDetailsRelation = new System.Data.DataRelation("PK_Taxes_OrderDetails", new System.Data.DataColumn[] { this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrderDetails.Columns["TaxId"]}, false); this.__relationPK_Taxes_OrderDetailsRelation.Nested = false; this.Relations.Add(this.__relationPK_Taxes_OrderDetailsRelation); this.__relationFK_Customers_OrdersRelation = new System.Data.DataRelation("FK_Customers_Orders", new System.Data.DataColumn[] { this.__tableCustomers.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrders.Columns["CustomerId"]}, false); this.__relationFK_Customers_OrdersRelation.Nested = false; this.Relations.Add(this.__relationFK_Customers_OrdersRelation); this.__relationFK_Categories_ProductsRelation = new System.Data.DataRelation("FK_Categories_Products", new System.Data.DataColumn[] { this.__tableCategories.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableProducts.Columns["CategoryId"]}, false); this.__relationFK_Categories_ProductsRelation.Nested = false; this.Relations.Add(this.__relationFK_Categories_ProductsRelation); this.__relationFK_Taxes_ProductsRelation = new System.Data.DataRelation("FK_Taxes_Products", new System.Data.DataColumn[] { this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableProducts.Columns["DefaultTaxId"]}, false); this.__relationFK_Taxes_ProductsRelation.Nested = false; this.Relations.Add(this.__relationFK_Taxes_ProductsRelation); this.__relationR_Taxes_OrdersRelation = new System.Data.DataRelation("R_Taxes_Orders", new System.Data.DataColumn[] { this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrders.Columns["TaxId"]}, false); this.__relationR_Taxes_OrdersRelation.Nested = false; this.Relations.Add(this.__relationR_Taxes_OrdersRelation); this.__relationR_Payments_OrdersRelation = new System.Data.DataRelation("R_Payments_Orders", new System.Data.DataColumn[] { this.__tablePayments.Columns["Id"]}, new System.Data.DataColumn[] { this.__tableOrders.Columns["PaymentId"]}, false); this.__relationR_Payments_OrdersRelation.Nested = false; this.Relations.Add(this.__relationR_Payments_OrdersRelation); }