//------------------------------------------------------------------------------
// <auto-generated>
// This code was generated by a tool.
// Runtime Version:2.0.50727.832
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------
//
// This source code was auto-generated by Microsoft.CompactFramework.Design.Data, Version 2.0.50727.832.
//
namespace GridSample {
using System;
using System.Data;
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
[System.Xml.Serialization.XmlRootAttribute("NorthwindDataSet")]
public partial class NorthwindDataSet : System.Data.DataSet {
private CategoriesDataTable tableCategories;
private CustomersDataTable tableCustomers;
private EmployeesDataTable tableEmployees;
private Order_DetailsDataTable tableOrder_Details;
private OrdersDataTable tableOrders;
private ProductsDataTable tableProducts;
private ShippersDataTable tableShippers;
private SuppliersDataTable tableSuppliers;
private System.Data.DataRelation relationOrder_Details_FK00;
private System.Data.DataRelation relationOrder_Details_FK01;
private System.Data.DataRelation relationOrders_FK00;
private System.Data.DataRelation relationOrders_FK01;
private System.Data.DataRelation relationOrders_FK02;
private System.Data.DataRelation relationProducts_FK00;
private System.Data.DataRelation relationProducts_FK01;
private System.Data.SchemaSerializationMode _schemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public NorthwindDataSet() {
this.BeginInit();
this.InitClass();
System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
base.Tables.CollectionChanged += schemaChangedHandler;
base.Relations.CollectionChanged += schemaChangedHandler;
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesDataTable Categories {
get {
return this.tableCategories;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersDataTable Customers {
get {
return this.tableCustomers;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesDataTable Employees {
get {
return this.tableEmployees;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsDataTable Order_Details {
get {
return this.tableOrder_Details;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersDataTable Orders {
get {
return this.tableOrders;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsDataTable Products {
get {
return this.tableProducts;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersDataTable Shippers {
get {
return this.tableShippers;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersDataTable Suppliers {
get {
return this.tableSuppliers;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.SchemaSerializationMode SchemaSerializationMode {
get {
return this._schemaSerializationMode;
}
set {
this._schemaSerializationMode = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public new System.Data.DataTableCollection Tables {
get {
return base.Tables;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public new System.Data.DataRelationCollection Relations {
get {
return base.Relations;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void InitializeDerivedDataSet() {
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataSet Clone() {
NorthwindDataSet cln = ((NorthwindDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override bool ShouldSerializeTables() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override bool ShouldSerializeRelations() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) {
if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) {
this.Reset();
System.Data.DataSet ds = new System.Data.DataSet();
ds.ReadXml(reader);
if ((ds.Tables["Categories"] != null)) {
base.Tables.Add(new CategoriesDataTable(ds.Tables["Categories"]));
}
if ((ds.Tables["Customers"] != null)) {
base.Tables.Add(new CustomersDataTable(ds.Tables["Customers"]));
}
if ((ds.Tables["Employees"] != null)) {
base.Tables.Add(new EmployeesDataTable(ds.Tables["Employees"]));
}
if ((ds.Tables["Order Details"] != null)) {
base.Tables.Add(new Order_DetailsDataTable(ds.Tables["Order Details"]));
}
if ((ds.Tables["Orders"] != null)) {
base.Tables.Add(new OrdersDataTable(ds.Tables["Orders"]));
}
if ((ds.Tables["Products"] != null)) {
base.Tables.Add(new ProductsDataTable(ds.Tables["Products"]));
}
if ((ds.Tables["Shippers"] != null)) {
base.Tables.Add(new ShippersDataTable(ds.Tables["Shippers"]));
}
if ((ds.Tables["Suppliers"] != null)) {
base.Tables.Add(new SuppliersDataTable(ds.Tables["Suppliers"]));
}
this.DataSetName = ds.DataSetName;
this.Prefix = ds.Prefix;
this.Namespace = ds.Namespace;
this.Locale = ds.Locale;
this.CaseSensitive = ds.CaseSensitive;
this.EnforceConstraints = ds.EnforceConstraints;
this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
this.InitVars();
}
else {
this.ReadXml(reader);
this.InitVars();
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {
System.IO.MemoryStream stream = new System.IO.MemoryStream();
this.WriteXmlSchema(new System.Xml.XmlTextWriter(stream, null));
stream.Position = 0;
return System.Xml.Schema.XmlSchema.Read(new System.Xml.XmlTextReader(stream), null);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.InitVars(true);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars(bool initTable) {
this.tableCategories = ((CategoriesDataTable)(base.Tables["Categories"]));
if ((initTable == true)) {
if ((this.tableCategories != null)) {
this.tableCategories.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.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.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.relationOrder_Details_FK00 = this.Relations["Order Details_FK00"];
this.relationOrder_Details_FK01 = this.Relations["Order Details_FK01"];
this.relationOrders_FK00 = this.Relations["Orders_FK00"];
this.relationOrders_FK01 = this.Relations["Orders_FK01"];
this.relationOrders_FK02 = this.Relations["Orders_FK02"];
this.relationProducts_FK00 = this.Relations["Products_FK00"];
this.relationProducts_FK01 = this.Relations["Products_FK01"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
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.tableCustomers = new CustomersDataTable();
base.Tables.Add(this.tableCustomers);
this.tableEmployees = new EmployeesDataTable();
base.Tables.Add(this.tableEmployees);
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.tableShippers = new ShippersDataTable();
base.Tables.Add(this.tableShippers);
this.tableSuppliers = new SuppliersDataTable();
base.Tables.Add(this.tableSuppliers);
this.relationOrder_Details_FK00 = new System.Data.DataRelation("Order Details_FK00", new System.Data.DataColumn[] {
this.tableProducts.Product_IDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.Product_IDColumn}, false);
this.Relations.Add(this.relationOrder_Details_FK00);
this.relationOrder_Details_FK01 = new System.Data.DataRelation("Order Details_FK01", new System.Data.DataColumn[] {
this.tableOrders.Order_IDColumn}, new System.Data.DataColumn[] {
this.tableOrder_Details.Order_IDColumn}, false);
this.Relations.Add(this.relationOrder_Details_FK01);
this.relationOrders_FK00 = new System.Data.DataRelation("Orders_FK00", new System.Data.DataColumn[] {
this.tableCustomers.Customer_IDColumn}, new System.Data.DataColumn[] {
this.tableOrders.Customer_IDColumn}, false);
this.Relations.Add(this.relationOrders_FK00);
this.relationOrders_FK01 = new System.Data.DataRelation("Orders_FK01", new System.Data.DataColumn[] {
this.tableShippers.Shipper_IDColumn}, new System.Data.DataColumn[] {
this.tableOrders.Ship_ViaColumn}, false);
this.Relations.Add(this.relationOrders_FK01);
this.relationOrders_FK02 = new System.Data.DataRelation("Orders_FK02", new System.Data.DataColumn[] {
this.tableEmployees.Employee_IDColumn}, new System.Data.DataColumn[] {
this.tableOrders.Employee_IDColumn}, false);
this.Relations.Add(this.relationOrders_FK02);
this.relationProducts_FK00 = new System.Data.DataRelation("Products_FK00", new System.Data.DataColumn[] {
this.tableSuppliers.Supplier_IDColumn}, new System.Data.DataColumn[] {
this.tableProducts.Supplier_IDColumn}, false);
this.Relations.Add(this.relationProducts_FK00);
this.relationProducts_FK01 = new System.Data.DataRelation("Products_FK01", new System.Data.DataColumn[] {
this.tableCategories.Category_IDColumn}, new System.Data.DataColumn[] {
this.tableProducts.Category_IDColumn}, false);
this.Relations.Add(this.relationProducts_FK01);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeCategories() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeCustomers() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeEmployees() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeOrder_Details() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeOrders() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeProducts() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeShippers() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeSuppliers() {
return false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {
if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {
this.InitVars();
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs) {
NorthwindDataSet ds = new NorthwindDataSet();
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
return type;
}
public delegate void CategoriesRowChangeEventHandler(object sender, CategoriesRowChangeEvent e);
public delegate void CustomersRowChangeEventHandler(object sender, CustomersRowChangeEvent e);
public delegate void EmployeesRowChangeEventHandler(object sender, EmployeesRowChangeEvent e);
public delegate void Order_DetailsRowChangeEventHandler(object sender, Order_DetailsRowChangeEvent e);
public delegate void OrdersRowChangeEventHandler(object sender, OrdersRowChangeEvent e);
public delegate void ProductsRowChangeEventHandler(object sender, ProductsRowChangeEvent e);
public delegate void ShippersRowChangeEventHandler(object sender, ShippersRowChangeEvent e);
public delegate void SuppliersRowChangeEventHandler(object sender, SuppliersRowChangeEvent e);
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class CategoriesDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnCategory_ID;
private System.Data.DataColumn columnCategory_Name;
private System.Data.DataColumn columnDescription;
private System.Data.DataColumn columnPicture;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesDataTable() {
this.TableName = "Categories";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal CategoriesDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Category_IDColumn {
get {
return this.columnCategory_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Category_NameColumn {
get {
return this.columnCategory_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn DescriptionColumn {
get {
return this.columnDescription;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn PictureColumn {
get {
return this.columnPicture;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRow this[int index] {
get {
return ((CategoriesRow)(this.Rows[index]));
}
}
public event CategoriesRowChangeEventHandler CategoriesRowChanging;
public event CategoriesRowChangeEventHandler CategoriesRowChanged;
public event CategoriesRowChangeEventHandler CategoriesRowDeleting;
public event CategoriesRowChangeEventHandler CategoriesRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddCategoriesRow(CategoriesRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRow AddCategoriesRow(string Category_Name, string Description, byte[] Picture) {
CategoriesRow rowCategoriesRow = ((CategoriesRow)(this.NewRow()));
rowCategoriesRow.ItemArray = new object[] {
null,
Category_Name,
Description,
Picture};
this.Rows.Add(rowCategoriesRow);
return rowCategoriesRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRow FindByCategory_IDCategory_Name(int Category_ID, string Category_Name) {
return ((CategoriesRow)(this.Rows.Find(new object[] {
Category_ID,
Category_Name})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
CategoriesDataTable cln = ((CategoriesDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new CategoriesDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnCategory_ID = base.Columns["Category ID"];
this.columnCategory_Name = base.Columns["Category Name"];
this.columnDescription = base.Columns["Description"];
this.columnPicture = base.Columns["Picture"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnCategory_ID = new System.Data.DataColumn("Category ID", typeof(int), null, System.Data.MappingType.Element);
this.columnCategory_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Category_ID");
this.columnCategory_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Category_IDColumn");
this.columnCategory_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCategory_ID");
this.columnCategory_ID.ExtendedProperties.Add("Generator_UserColumnName", "Category ID");
base.Columns.Add(this.columnCategory_ID);
this.columnCategory_Name = new System.Data.DataColumn("Category Name", typeof(string), null, System.Data.MappingType.Element);
this.columnCategory_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Category_Name");
this.columnCategory_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Category_NameColumn");
this.columnCategory_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCategory_Name");
this.columnCategory_Name.ExtendedProperties.Add("Generator_UserColumnName", "Category Name");
base.Columns.Add(this.columnCategory_Name);
this.columnDescription = new System.Data.DataColumn("Description", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnDescription);
this.columnPicture = new System.Data.DataColumn("Picture", typeof(byte[]), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnPicture);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnCategory_ID,
this.columnCategory_Name}, true));
this.columnCategory_ID.AutoIncrement = true;
this.columnCategory_ID.AllowDBNull = false;
this.columnCategory_ID.ReadOnly = true;
this.columnCategory_Name.AllowDBNull = false;
this.columnCategory_Name.MaxLength = 15;
this.columnDescription.MaxLength = 536870911;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRow NewCategoriesRow() {
return ((CategoriesRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new CategoriesRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(CategoriesRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.CategoriesRowChanged != null)) {
this.CategoriesRowChanged(this, new CategoriesRowChangeEvent(((CategoriesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.CategoriesRowChanging != null)) {
this.CategoriesRowChanging(this, new CategoriesRowChangeEvent(((CategoriesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.CategoriesRowDeleted != null)) {
this.CategoriesRowDeleted(this, new CategoriesRowChangeEvent(((CategoriesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.CategoriesRowDeleting != null)) {
this.CategoriesRowDeleting(this, new CategoriesRowChangeEvent(((CategoriesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveCategoriesRow(CategoriesRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "CategoriesDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class CustomersDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnCustomer_ID;
private System.Data.DataColumn columnCompany_Name;
private System.Data.DataColumn columnContact_Name;
private System.Data.DataColumn columnContact_Title;
private System.Data.DataColumn columnAddress;
private System.Data.DataColumn columnCity;
private System.Data.DataColumn columnRegion;
private System.Data.DataColumn columnPostal_Code;
private System.Data.DataColumn columnCountry;
private System.Data.DataColumn columnPhone;
private System.Data.DataColumn columnFax;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersDataTable() {
this.TableName = "Customers";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal CustomersDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Customer_IDColumn {
get {
return this.columnCustomer_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Company_NameColumn {
get {
return this.columnCompany_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Contact_NameColumn {
get {
return this.columnContact_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Contact_TitleColumn {
get {
return this.columnContact_Title;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn AddressColumn {
get {
return this.columnAddress;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn CityColumn {
get {
return this.columnCity;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn RegionColumn {
get {
return this.columnRegion;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Postal_CodeColumn {
get {
return this.columnPostal_Code;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn CountryColumn {
get {
return this.columnCountry;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn PhoneColumn {
get {
return this.columnPhone;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn FaxColumn {
get {
return this.columnFax;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRow this[int index] {
get {
return ((CustomersRow)(this.Rows[index]));
}
}
public event CustomersRowChangeEventHandler CustomersRowChanging;
public event CustomersRowChangeEventHandler CustomersRowChanged;
public event CustomersRowChangeEventHandler CustomersRowDeleting;
public event CustomersRowChangeEventHandler CustomersRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddCustomersRow(CustomersRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRow AddCustomersRow(string Customer_ID, string Company_Name, string Contact_Name, string Contact_Title, string Address, string City, string Region, string Postal_Code, string Country, string Phone, string Fax) {
CustomersRow rowCustomersRow = ((CustomersRow)(this.NewRow()));
rowCustomersRow.ItemArray = new object[] {
Customer_ID,
Company_Name,
Contact_Name,
Contact_Title,
Address,
City,
Region,
Postal_Code,
Country,
Phone,
Fax};
this.Rows.Add(rowCustomersRow);
return rowCustomersRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRow FindByCustomer_ID(string Customer_ID) {
return ((CustomersRow)(this.Rows.Find(new object[] {
Customer_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
CustomersDataTable cln = ((CustomersDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new CustomersDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnCustomer_ID = base.Columns["Customer ID"];
this.columnCompany_Name = base.Columns["Company Name"];
this.columnContact_Name = base.Columns["Contact Name"];
this.columnContact_Title = base.Columns["Contact Title"];
this.columnAddress = base.Columns["Address"];
this.columnCity = base.Columns["City"];
this.columnRegion = base.Columns["Region"];
this.columnPostal_Code = base.Columns["Postal Code"];
this.columnCountry = base.Columns["Country"];
this.columnPhone = base.Columns["Phone"];
this.columnFax = base.Columns["Fax"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnCustomer_ID = new System.Data.DataColumn("Customer ID", typeof(string), null, System.Data.MappingType.Element);
this.columnCustomer_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Customer_ID");
this.columnCustomer_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Customer_IDColumn");
this.columnCustomer_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCustomer_ID");
this.columnCustomer_ID.ExtendedProperties.Add("Generator_UserColumnName", "Customer ID");
base.Columns.Add(this.columnCustomer_ID);
this.columnCompany_Name = new System.Data.DataColumn("Company Name", typeof(string), null, System.Data.MappingType.Element);
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Company_Name");
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Company_NameColumn");
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCompany_Name");
this.columnCompany_Name.ExtendedProperties.Add("Generator_UserColumnName", "Company Name");
base.Columns.Add(this.columnCompany_Name);
this.columnContact_Name = new System.Data.DataColumn("Contact Name", typeof(string), null, System.Data.MappingType.Element);
this.columnContact_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Contact_Name");
this.columnContact_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Contact_NameColumn");
this.columnContact_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnContact_Name");
this.columnContact_Name.ExtendedProperties.Add("Generator_UserColumnName", "Contact Name");
base.Columns.Add(this.columnContact_Name);
this.columnContact_Title = new System.Data.DataColumn("Contact Title", typeof(string), null, System.Data.MappingType.Element);
this.columnContact_Title.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Contact_Title");
this.columnContact_Title.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Contact_TitleColumn");
this.columnContact_Title.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnContact_Title");
this.columnContact_Title.ExtendedProperties.Add("Generator_UserColumnName", "Contact Title");
base.Columns.Add(this.columnContact_Title);
this.columnAddress = new System.Data.DataColumn("Address", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnAddress);
this.columnCity = new System.Data.DataColumn("City", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnCity);
this.columnRegion = new System.Data.DataColumn("Region", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnRegion);
this.columnPostal_Code = new System.Data.DataColumn("Postal Code", typeof(string), null, System.Data.MappingType.Element);
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Postal_Code");
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Postal_CodeColumn");
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnPostal_Code");
this.columnPostal_Code.ExtendedProperties.Add("Generator_UserColumnName", "Postal Code");
base.Columns.Add(this.columnPostal_Code);
this.columnCountry = new System.Data.DataColumn("Country", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnCountry);
this.columnPhone = new System.Data.DataColumn("Phone", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnPhone);
this.columnFax = new System.Data.DataColumn("Fax", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnFax);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnCustomer_ID}, true));
this.columnCustomer_ID.AllowDBNull = false;
this.columnCustomer_ID.Unique = true;
this.columnCustomer_ID.MaxLength = 5;
this.columnCompany_Name.AllowDBNull = false;
this.columnCompany_Name.MaxLength = 40;
this.columnContact_Name.MaxLength = 30;
this.columnContact_Title.MaxLength = 30;
this.columnAddress.MaxLength = 60;
this.columnCity.MaxLength = 15;
this.columnRegion.MaxLength = 15;
this.columnPostal_Code.MaxLength = 10;
this.columnCountry.MaxLength = 15;
this.columnPhone.MaxLength = 24;
this.columnFax.MaxLength = 24;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRow NewCustomersRow() {
return ((CustomersRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new CustomersRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(CustomersRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.CustomersRowChanged != null)) {
this.CustomersRowChanged(this, new CustomersRowChangeEvent(((CustomersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.CustomersRowChanging != null)) {
this.CustomersRowChanging(this, new CustomersRowChangeEvent(((CustomersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.CustomersRowDeleted != null)) {
this.CustomersRowDeleted(this, new CustomersRowChangeEvent(((CustomersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.CustomersRowDeleting != null)) {
this.CustomersRowDeleting(this, new CustomersRowChangeEvent(((CustomersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveCustomersRow(CustomersRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "CustomersDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class EmployeesDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnEmployee_ID;
private System.Data.DataColumn columnLast_Name;
private System.Data.DataColumn columnFirst_Name;
private System.Data.DataColumn columnTitle;
private System.Data.DataColumn columnBirth_Date;
private System.Data.DataColumn columnHire_Date;
private System.Data.DataColumn columnAddress;
private System.Data.DataColumn columnCity;
private System.Data.DataColumn columnRegion;
private System.Data.DataColumn columnPostal_Code;
private System.Data.DataColumn columnCountry;
private System.Data.DataColumn columnHome_Phone;
private System.Data.DataColumn columnExtension;
private System.Data.DataColumn columnPhoto;
private System.Data.DataColumn columnNotes;
private System.Data.DataColumn columnReports_To;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesDataTable() {
this.TableName = "Employees";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal EmployeesDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Employee_IDColumn {
get {
return this.columnEmployee_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Last_NameColumn {
get {
return this.columnLast_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn First_NameColumn {
get {
return this.columnFirst_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn TitleColumn {
get {
return this.columnTitle;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Birth_DateColumn {
get {
return this.columnBirth_Date;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Hire_DateColumn {
get {
return this.columnHire_Date;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn AddressColumn {
get {
return this.columnAddress;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn CityColumn {
get {
return this.columnCity;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn RegionColumn {
get {
return this.columnRegion;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Postal_CodeColumn {
get {
return this.columnPostal_Code;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn CountryColumn {
get {
return this.columnCountry;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Home_PhoneColumn {
get {
return this.columnHome_Phone;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn ExtensionColumn {
get {
return this.columnExtension;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn PhotoColumn {
get {
return this.columnPhoto;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn NotesColumn {
get {
return this.columnNotes;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Reports_ToColumn {
get {
return this.columnReports_To;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRow this[int index] {
get {
return ((EmployeesRow)(this.Rows[index]));
}
}
public event EmployeesRowChangeEventHandler EmployeesRowChanging;
public event EmployeesRowChangeEventHandler EmployeesRowChanged;
public event EmployeesRowChangeEventHandler EmployeesRowDeleting;
public event EmployeesRowChangeEventHandler EmployeesRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddEmployeesRow(EmployeesRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRow AddEmployeesRow(string Last_Name, string First_Name, string Title, System.DateTime Birth_Date, System.DateTime Hire_Date, string Address, string City, string Region, string Postal_Code, string Country, string Home_Phone, string Extension, byte[] Photo, string Notes, int Reports_To) {
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
rowEmployeesRow.ItemArray = new object[] {
null,
Last_Name,
First_Name,
Title,
Birth_Date,
Hire_Date,
Address,
City,
Region,
Postal_Code,
Country,
Home_Phone,
Extension,
Photo,
Notes,
Reports_To};
this.Rows.Add(rowEmployeesRow);
return rowEmployeesRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRow FindByEmployee_ID(int Employee_ID) {
return ((EmployeesRow)(this.Rows.Find(new object[] {
Employee_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
EmployeesDataTable cln = ((EmployeesDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new EmployeesDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnEmployee_ID = base.Columns["Employee ID"];
this.columnLast_Name = base.Columns["Last Name"];
this.columnFirst_Name = base.Columns["First Name"];
this.columnTitle = base.Columns["Title"];
this.columnBirth_Date = base.Columns["Birth Date"];
this.columnHire_Date = base.Columns["Hire Date"];
this.columnAddress = base.Columns["Address"];
this.columnCity = base.Columns["City"];
this.columnRegion = base.Columns["Region"];
this.columnPostal_Code = base.Columns["Postal Code"];
this.columnCountry = base.Columns["Country"];
this.columnHome_Phone = base.Columns["Home Phone"];
this.columnExtension = base.Columns["Extension"];
this.columnPhoto = base.Columns["Photo"];
this.columnNotes = base.Columns["Notes"];
this.columnReports_To = base.Columns["Reports To"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnEmployee_ID = new System.Data.DataColumn("Employee ID", typeof(int), null, System.Data.MappingType.Element);
this.columnEmployee_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Employee_ID");
this.columnEmployee_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Employee_IDColumn");
this.columnEmployee_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnEmployee_ID");
this.columnEmployee_ID.ExtendedProperties.Add("Generator_UserColumnName", "Employee ID");
base.Columns.Add(this.columnEmployee_ID);
this.columnLast_Name = new System.Data.DataColumn("Last Name", typeof(string), null, System.Data.MappingType.Element);
this.columnLast_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Last_Name");
this.columnLast_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Last_NameColumn");
this.columnLast_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnLast_Name");
this.columnLast_Name.ExtendedProperties.Add("Generator_UserColumnName", "Last Name");
base.Columns.Add(this.columnLast_Name);
this.columnFirst_Name = new System.Data.DataColumn("First Name", typeof(string), null, System.Data.MappingType.Element);
this.columnFirst_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "First_Name");
this.columnFirst_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "First_NameColumn");
this.columnFirst_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnFirst_Name");
this.columnFirst_Name.ExtendedProperties.Add("Generator_UserColumnName", "First Name");
base.Columns.Add(this.columnFirst_Name);
this.columnTitle = new System.Data.DataColumn("Title", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnTitle);
this.columnBirth_Date = new System.Data.DataColumn("Birth Date", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.columnBirth_Date.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Birth_Date");
this.columnBirth_Date.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Birth_DateColumn");
this.columnBirth_Date.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnBirth_Date");
this.columnBirth_Date.ExtendedProperties.Add("Generator_UserColumnName", "Birth Date");
base.Columns.Add(this.columnBirth_Date);
this.columnHire_Date = new System.Data.DataColumn("Hire Date", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.columnHire_Date.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Hire_Date");
this.columnHire_Date.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Hire_DateColumn");
this.columnHire_Date.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnHire_Date");
this.columnHire_Date.ExtendedProperties.Add("Generator_UserColumnName", "Hire Date");
base.Columns.Add(this.columnHire_Date);
this.columnAddress = new System.Data.DataColumn("Address", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnAddress);
this.columnCity = new System.Data.DataColumn("City", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnCity);
this.columnRegion = new System.Data.DataColumn("Region", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnRegion);
this.columnPostal_Code = new System.Data.DataColumn("Postal Code", typeof(string), null, System.Data.MappingType.Element);
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Postal_Code");
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Postal_CodeColumn");
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnPostal_Code");
this.columnPostal_Code.ExtendedProperties.Add("Generator_UserColumnName", "Postal Code");
base.Columns.Add(this.columnPostal_Code);
this.columnCountry = new System.Data.DataColumn("Country", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnCountry);
this.columnHome_Phone = new System.Data.DataColumn("Home Phone", typeof(string), null, System.Data.MappingType.Element);
this.columnHome_Phone.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Home_Phone");
this.columnHome_Phone.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Home_PhoneColumn");
this.columnHome_Phone.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnHome_Phone");
this.columnHome_Phone.ExtendedProperties.Add("Generator_UserColumnName", "Home Phone");
base.Columns.Add(this.columnHome_Phone);
this.columnExtension = new System.Data.DataColumn("Extension", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnExtension);
this.columnPhoto = new System.Data.DataColumn("Photo", typeof(byte[]), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnPhoto);
this.columnNotes = new System.Data.DataColumn("Notes", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnNotes);
this.columnReports_To = new System.Data.DataColumn("Reports To", typeof(int), null, System.Data.MappingType.Element);
this.columnReports_To.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Reports_To");
this.columnReports_To.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Reports_ToColumn");
this.columnReports_To.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnReports_To");
this.columnReports_To.ExtendedProperties.Add("Generator_UserColumnName", "Reports To");
base.Columns.Add(this.columnReports_To);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnEmployee_ID}, true));
this.columnEmployee_ID.AutoIncrement = true;
this.columnEmployee_ID.AllowDBNull = false;
this.columnEmployee_ID.ReadOnly = true;
this.columnEmployee_ID.Unique = true;
this.columnLast_Name.AllowDBNull = false;
this.columnLast_Name.MaxLength = 20;
this.columnFirst_Name.AllowDBNull = false;
this.columnFirst_Name.MaxLength = 10;
this.columnTitle.MaxLength = 30;
this.columnAddress.MaxLength = 60;
this.columnCity.MaxLength = 15;
this.columnRegion.MaxLength = 15;
this.columnPostal_Code.MaxLength = 10;
this.columnCountry.MaxLength = 15;
this.columnHome_Phone.MaxLength = 24;
this.columnExtension.MaxLength = 4;
this.columnNotes.MaxLength = 536870911;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRow NewEmployeesRow() {
return ((EmployeesRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new EmployeesRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(EmployeesRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.EmployeesRowChanged != null)) {
this.EmployeesRowChanged(this, new EmployeesRowChangeEvent(((EmployeesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.EmployeesRowChanging != null)) {
this.EmployeesRowChanging(this, new EmployeesRowChangeEvent(((EmployeesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.EmployeesRowDeleted != null)) {
this.EmployeesRowDeleted(this, new EmployeesRowChangeEvent(((EmployeesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.EmployeesRowDeleting != null)) {
this.EmployeesRowDeleting(this, new EmployeesRowChangeEvent(((EmployeesRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveEmployeesRow(EmployeesRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "EmployeesDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class Order_DetailsDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnOrder_ID;
private System.Data.DataColumn columnProduct_ID;
private System.Data.DataColumn columnUnit_Price;
private System.Data.DataColumn columnQuantity;
private System.Data.DataColumn columnDiscount;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsDataTable() {
this.TableName = "Order Details";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal Order_DetailsDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Order_IDColumn {
get {
return this.columnOrder_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Product_IDColumn {
get {
return this.columnProduct_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Unit_PriceColumn {
get {
return this.columnUnit_Price;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn QuantityColumn {
get {
return this.columnQuantity;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn DiscountColumn {
get {
return this.columnDiscount;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow this[int index] {
get {
return ((Order_DetailsRow)(this.Rows[index]));
}
}
public event Order_DetailsRowChangeEventHandler Order_DetailsRowChanging;
public event Order_DetailsRowChangeEventHandler Order_DetailsRowChanged;
public event Order_DetailsRowChangeEventHandler Order_DetailsRowDeleting;
public event Order_DetailsRowChangeEventHandler Order_DetailsRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddOrder_DetailsRow(Order_DetailsRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow AddOrder_DetailsRow(OrdersRow parentOrdersRowByOrder_Details_FK01, ProductsRow parentProductsRowByOrder_Details_FK00, decimal Unit_Price, short Quantity, float Discount) {
Order_DetailsRow rowOrder_DetailsRow = ((Order_DetailsRow)(this.NewRow()));
rowOrder_DetailsRow.ItemArray = new object[] {
parentOrdersRowByOrder_Details_FK01[0],
parentProductsRowByOrder_Details_FK00[0],
Unit_Price,
Quantity,
Discount};
this.Rows.Add(rowOrder_DetailsRow);
return rowOrder_DetailsRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow FindByOrder_IDProduct_ID(int Order_ID, int Product_ID) {
return ((Order_DetailsRow)(this.Rows.Find(new object[] {
Order_ID,
Product_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
Order_DetailsDataTable cln = ((Order_DetailsDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new Order_DetailsDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnOrder_ID = base.Columns["Order ID"];
this.columnProduct_ID = base.Columns["Product ID"];
this.columnUnit_Price = base.Columns["Unit Price"];
this.columnQuantity = base.Columns["Quantity"];
this.columnDiscount = base.Columns["Discount"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnOrder_ID = new System.Data.DataColumn("Order ID", typeof(int), null, System.Data.MappingType.Element);
this.columnOrder_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Order_ID");
this.columnOrder_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Order_IDColumn");
this.columnOrder_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnOrder_ID");
this.columnOrder_ID.ExtendedProperties.Add("Generator_UserColumnName", "Order ID");
base.Columns.Add(this.columnOrder_ID);
this.columnProduct_ID = new System.Data.DataColumn("Product ID", typeof(int), null, System.Data.MappingType.Element);
this.columnProduct_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Product_ID");
this.columnProduct_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Product_IDColumn");
this.columnProduct_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnProduct_ID");
this.columnProduct_ID.ExtendedProperties.Add("Generator_UserColumnName", "Product ID");
base.Columns.Add(this.columnProduct_ID);
this.columnUnit_Price = new System.Data.DataColumn("Unit Price", typeof(decimal), null, System.Data.MappingType.Element);
this.columnUnit_Price.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Unit_Price");
this.columnUnit_Price.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Unit_PriceColumn");
this.columnUnit_Price.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnUnit_Price");
this.columnUnit_Price.ExtendedProperties.Add("Generator_UserColumnName", "Unit Price");
base.Columns.Add(this.columnUnit_Price);
this.columnQuantity = new System.Data.DataColumn("Quantity", typeof(short), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnQuantity);
this.columnDiscount = new System.Data.DataColumn("Discount", typeof(float), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnDiscount);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnOrder_ID,
this.columnProduct_ID}, true));
this.columnOrder_ID.AllowDBNull = false;
this.columnProduct_ID.AllowDBNull = false;
this.columnUnit_Price.AllowDBNull = false;
this.columnQuantity.AllowDBNull = false;
this.columnDiscount.AllowDBNull = false;
this.ExtendedProperties.Add("Generator_RowClassName", "Order_DetailsRow");
this.ExtendedProperties.Add("Generator_RowEvArgName", "Order_DetailsRowChangeEvent");
this.ExtendedProperties.Add("Generator_RowEvHandlerName", "Order_DetailsRowChangeEventHandler");
this.ExtendedProperties.Add("Generator_TableClassName", "Order_DetailsDataTable");
this.ExtendedProperties.Add("Generator_TablePropName", "Order_Details");
this.ExtendedProperties.Add("Generator_TableVarName", "tableOrder_Details");
this.ExtendedProperties.Add("Generator_UserTableName", "Order Details");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow NewOrder_DetailsRow() {
return ((Order_DetailsRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new Order_DetailsRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(Order_DetailsRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.Order_DetailsRowChanged != null)) {
this.Order_DetailsRowChanged(this, new Order_DetailsRowChangeEvent(((Order_DetailsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.Order_DetailsRowChanging != null)) {
this.Order_DetailsRowChanging(this, new Order_DetailsRowChangeEvent(((Order_DetailsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.Order_DetailsRowDeleted != null)) {
this.Order_DetailsRowDeleted(this, new Order_DetailsRowChangeEvent(((Order_DetailsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.Order_DetailsRowDeleting != null)) {
this.Order_DetailsRowDeleting(this, new Order_DetailsRowChangeEvent(((Order_DetailsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveOrder_DetailsRow(Order_DetailsRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "Order_DetailsDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class OrdersDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnOrder_ID;
private System.Data.DataColumn columnCustomer_ID;
private System.Data.DataColumn columnEmployee_ID;
private System.Data.DataColumn columnShip_Name;
private System.Data.DataColumn columnShip_Address;
private System.Data.DataColumn columnShip_City;
private System.Data.DataColumn columnShip_Region;
private System.Data.DataColumn columnShip_Postal_Code;
private System.Data.DataColumn columnShip_Country;
private System.Data.DataColumn columnShip_Via;
private System.Data.DataColumn columnOrder_Date;
private System.Data.DataColumn columnRequired_Date;
private System.Data.DataColumn columnShipped_Date;
private System.Data.DataColumn columnFreight;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersDataTable() {
this.TableName = "Orders";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal OrdersDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Order_IDColumn {
get {
return this.columnOrder_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Customer_IDColumn {
get {
return this.columnCustomer_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Employee_IDColumn {
get {
return this.columnEmployee_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_NameColumn {
get {
return this.columnShip_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_AddressColumn {
get {
return this.columnShip_Address;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_CityColumn {
get {
return this.columnShip_City;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_RegionColumn {
get {
return this.columnShip_Region;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_Postal_CodeColumn {
get {
return this.columnShip_Postal_Code;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_CountryColumn {
get {
return this.columnShip_Country;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Ship_ViaColumn {
get {
return this.columnShip_Via;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Order_DateColumn {
get {
return this.columnOrder_Date;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Required_DateColumn {
get {
return this.columnRequired_Date;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Shipped_DateColumn {
get {
return this.columnShipped_Date;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn FreightColumn {
get {
return this.columnFreight;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow this[int index] {
get {
return ((OrdersRow)(this.Rows[index]));
}
}
public event OrdersRowChangeEventHandler OrdersRowChanging;
public event OrdersRowChangeEventHandler OrdersRowChanged;
public event OrdersRowChangeEventHandler OrdersRowDeleting;
public event OrdersRowChangeEventHandler OrdersRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddOrdersRow(OrdersRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow AddOrdersRow(int Order_ID, CustomersRow parentCustomersRowByOrders_FK00, EmployeesRow parentEmployeesRowByOrders_FK02, string Ship_Name, string Ship_Address, string Ship_City, string Ship_Region, string Ship_Postal_Code, string Ship_Country, ShippersRow parentShippersRowByOrders_FK01, System.DateTime Order_Date, System.DateTime Required_Date, System.DateTime Shipped_Date, decimal Freight) {
OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
rowOrdersRow.ItemArray = new object[] {
Order_ID,
parentCustomersRowByOrders_FK00[0],
parentEmployeesRowByOrders_FK02[0],
Ship_Name,
Ship_Address,
Ship_City,
Ship_Region,
Ship_Postal_Code,
Ship_Country,
parentShippersRowByOrders_FK01[0],
Order_Date,
Required_Date,
Shipped_Date,
Freight};
this.Rows.Add(rowOrdersRow);
return rowOrdersRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow FindByOrder_ID(int Order_ID) {
return ((OrdersRow)(this.Rows.Find(new object[] {
Order_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
OrdersDataTable cln = ((OrdersDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new OrdersDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnOrder_ID = base.Columns["Order ID"];
this.columnCustomer_ID = base.Columns["Customer ID"];
this.columnEmployee_ID = base.Columns["Employee ID"];
this.columnShip_Name = base.Columns["Ship Name"];
this.columnShip_Address = base.Columns["Ship Address"];
this.columnShip_City = base.Columns["Ship City"];
this.columnShip_Region = base.Columns["Ship Region"];
this.columnShip_Postal_Code = base.Columns["Ship Postal Code"];
this.columnShip_Country = base.Columns["Ship Country"];
this.columnShip_Via = base.Columns["Ship Via"];
this.columnOrder_Date = base.Columns["Order Date"];
this.columnRequired_Date = base.Columns["Required Date"];
this.columnShipped_Date = base.Columns["Shipped Date"];
this.columnFreight = base.Columns["Freight"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnOrder_ID = new System.Data.DataColumn("Order ID", typeof(int), null, System.Data.MappingType.Element);
this.columnOrder_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Order_ID");
this.columnOrder_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Order_IDColumn");
this.columnOrder_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnOrder_ID");
this.columnOrder_ID.ExtendedProperties.Add("Generator_UserColumnName", "Order ID");
base.Columns.Add(this.columnOrder_ID);
this.columnCustomer_ID = new System.Data.DataColumn("Customer ID", typeof(string), null, System.Data.MappingType.Element);
this.columnCustomer_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Customer_ID");
this.columnCustomer_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Customer_IDColumn");
this.columnCustomer_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCustomer_ID");
this.columnCustomer_ID.ExtendedProperties.Add("Generator_UserColumnName", "Customer ID");
base.Columns.Add(this.columnCustomer_ID);
this.columnEmployee_ID = new System.Data.DataColumn("Employee ID", typeof(int), null, System.Data.MappingType.Element);
this.columnEmployee_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Employee_ID");
this.columnEmployee_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Employee_IDColumn");
this.columnEmployee_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnEmployee_ID");
this.columnEmployee_ID.ExtendedProperties.Add("Generator_UserColumnName", "Employee ID");
base.Columns.Add(this.columnEmployee_ID);
this.columnShip_Name = new System.Data.DataColumn("Ship Name", typeof(string), null, System.Data.MappingType.Element);
this.columnShip_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_Name");
this.columnShip_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_NameColumn");
this.columnShip_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_Name");
this.columnShip_Name.ExtendedProperties.Add("Generator_UserColumnName", "Ship Name");
base.Columns.Add(this.columnShip_Name);
this.columnShip_Address = new System.Data.DataColumn("Ship Address", typeof(string), null, System.Data.MappingType.Element);
this.columnShip_Address.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_Address");
this.columnShip_Address.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_AddressColumn");
this.columnShip_Address.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_Address");
this.columnShip_Address.ExtendedProperties.Add("Generator_UserColumnName", "Ship Address");
base.Columns.Add(this.columnShip_Address);
this.columnShip_City = new System.Data.DataColumn("Ship City", typeof(string), null, System.Data.MappingType.Element);
this.columnShip_City.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_City");
this.columnShip_City.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_CityColumn");
this.columnShip_City.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_City");
this.columnShip_City.ExtendedProperties.Add("Generator_UserColumnName", "Ship City");
base.Columns.Add(this.columnShip_City);
this.columnShip_Region = new System.Data.DataColumn("Ship Region", typeof(string), null, System.Data.MappingType.Element);
this.columnShip_Region.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_Region");
this.columnShip_Region.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_RegionColumn");
this.columnShip_Region.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_Region");
this.columnShip_Region.ExtendedProperties.Add("Generator_UserColumnName", "Ship Region");
base.Columns.Add(this.columnShip_Region);
this.columnShip_Postal_Code = new System.Data.DataColumn("Ship Postal Code", typeof(string), null, System.Data.MappingType.Element);
this.columnShip_Postal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_Postal_Code");
this.columnShip_Postal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_Postal_CodeColumn");
this.columnShip_Postal_Code.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_Postal_Code");
this.columnShip_Postal_Code.ExtendedProperties.Add("Generator_UserColumnName", "Ship Postal Code");
base.Columns.Add(this.columnShip_Postal_Code);
this.columnShip_Country = new System.Data.DataColumn("Ship Country", typeof(string), null, System.Data.MappingType.Element);
this.columnShip_Country.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_Country");
this.columnShip_Country.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_CountryColumn");
this.columnShip_Country.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_Country");
this.columnShip_Country.ExtendedProperties.Add("Generator_UserColumnName", "Ship Country");
base.Columns.Add(this.columnShip_Country);
this.columnShip_Via = new System.Data.DataColumn("Ship Via", typeof(int), null, System.Data.MappingType.Element);
this.columnShip_Via.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Ship_Via");
this.columnShip_Via.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Ship_ViaColumn");
this.columnShip_Via.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShip_Via");
this.columnShip_Via.ExtendedProperties.Add("Generator_UserColumnName", "Ship Via");
base.Columns.Add(this.columnShip_Via);
this.columnOrder_Date = new System.Data.DataColumn("Order Date", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.columnOrder_Date.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Order_Date");
this.columnOrder_Date.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Order_DateColumn");
this.columnOrder_Date.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnOrder_Date");
this.columnOrder_Date.ExtendedProperties.Add("Generator_UserColumnName", "Order Date");
base.Columns.Add(this.columnOrder_Date);
this.columnRequired_Date = new System.Data.DataColumn("Required Date", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.columnRequired_Date.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Required_Date");
this.columnRequired_Date.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Required_DateColumn");
this.columnRequired_Date.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnRequired_Date");
this.columnRequired_Date.ExtendedProperties.Add("Generator_UserColumnName", "Required Date");
base.Columns.Add(this.columnRequired_Date);
this.columnShipped_Date = new System.Data.DataColumn("Shipped Date", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.columnShipped_Date.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Shipped_Date");
this.columnShipped_Date.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Shipped_DateColumn");
this.columnShipped_Date.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShipped_Date");
this.columnShipped_Date.ExtendedProperties.Add("Generator_UserColumnName", "Shipped Date");
base.Columns.Add(this.columnShipped_Date);
this.columnFreight = new System.Data.DataColumn("Freight", typeof(decimal), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnFreight);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnOrder_ID}, true));
this.columnOrder_ID.AllowDBNull = false;
this.columnOrder_ID.Unique = true;
this.columnCustomer_ID.AllowDBNull = false;
this.columnCustomer_ID.MaxLength = 5;
this.columnShip_Name.MaxLength = 40;
this.columnShip_Address.MaxLength = 60;
this.columnShip_City.MaxLength = 15;
this.columnShip_Region.MaxLength = 15;
this.columnShip_Postal_Code.MaxLength = 10;
this.columnShip_Country.MaxLength = 15;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow NewOrdersRow() {
return ((OrdersRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new OrdersRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(OrdersRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.OrdersRowChanged != null)) {
this.OrdersRowChanged(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.OrdersRowChanging != null)) {
this.OrdersRowChanging(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.OrdersRowDeleted != null)) {
this.OrdersRowDeleted(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.OrdersRowDeleting != null)) {
this.OrdersRowDeleting(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveOrdersRow(OrdersRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "OrdersDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class ProductsDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnProduct_ID;
private System.Data.DataColumn columnSupplier_ID;
private System.Data.DataColumn columnCategory_ID;
private System.Data.DataColumn columnProduct_Name;
private System.Data.DataColumn columnEnglish_Name;
private System.Data.DataColumn columnQuantity_Per_Unit;
private System.Data.DataColumn columnUnit_Price;
private System.Data.DataColumn columnUnits_In_Stock;
private System.Data.DataColumn columnUnits_On_Order;
private System.Data.DataColumn columnReorder_Level;
private System.Data.DataColumn columnDiscontinued;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsDataTable() {
this.TableName = "Products";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal ProductsDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Product_IDColumn {
get {
return this.columnProduct_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Supplier_IDColumn {
get {
return this.columnSupplier_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Category_IDColumn {
get {
return this.columnCategory_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Product_NameColumn {
get {
return this.columnProduct_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn English_NameColumn {
get {
return this.columnEnglish_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Quantity_Per_UnitColumn {
get {
return this.columnQuantity_Per_Unit;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Unit_PriceColumn {
get {
return this.columnUnit_Price;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Units_In_StockColumn {
get {
return this.columnUnits_In_Stock;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Units_On_OrderColumn {
get {
return this.columnUnits_On_Order;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Reorder_LevelColumn {
get {
return this.columnReorder_Level;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn DiscontinuedColumn {
get {
return this.columnDiscontinued;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow this[int index] {
get {
return ((ProductsRow)(this.Rows[index]));
}
}
public event ProductsRowChangeEventHandler ProductsRowChanging;
public event ProductsRowChangeEventHandler ProductsRowChanged;
public event ProductsRowChangeEventHandler ProductsRowDeleting;
public event ProductsRowChangeEventHandler ProductsRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddProductsRow(ProductsRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow AddProductsRow(SuppliersRow parentSuppliersRowByProducts_FK00, CategoriesRow parentCategoriesRowByProducts_FK01, string Product_Name, string English_Name, string Quantity_Per_Unit, decimal Unit_Price, short Units_In_Stock, short Units_On_Order, short Reorder_Level, bool Discontinued) {
ProductsRow rowProductsRow = ((ProductsRow)(this.NewRow()));
rowProductsRow.ItemArray = new object[] {
null,
parentSuppliersRowByProducts_FK00[0],
parentCategoriesRowByProducts_FK01[0],
Product_Name,
English_Name,
Quantity_Per_Unit,
Unit_Price,
Units_In_Stock,
Units_On_Order,
Reorder_Level,
Discontinued};
this.Rows.Add(rowProductsRow);
return rowProductsRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow FindByProduct_ID(int Product_ID) {
return ((ProductsRow)(this.Rows.Find(new object[] {
Product_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
ProductsDataTable cln = ((ProductsDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new ProductsDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnProduct_ID = base.Columns["Product ID"];
this.columnSupplier_ID = base.Columns["Supplier ID"];
this.columnCategory_ID = base.Columns["Category ID"];
this.columnProduct_Name = base.Columns["Product Name"];
this.columnEnglish_Name = base.Columns["English Name"];
this.columnQuantity_Per_Unit = base.Columns["Quantity Per Unit"];
this.columnUnit_Price = base.Columns["Unit Price"];
this.columnUnits_In_Stock = base.Columns["Units In Stock"];
this.columnUnits_On_Order = base.Columns["Units On Order"];
this.columnReorder_Level = base.Columns["Reorder Level"];
this.columnDiscontinued = base.Columns["Discontinued"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnProduct_ID = new System.Data.DataColumn("Product ID", typeof(int), null, System.Data.MappingType.Element);
this.columnProduct_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Product_ID");
this.columnProduct_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Product_IDColumn");
this.columnProduct_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnProduct_ID");
this.columnProduct_ID.ExtendedProperties.Add("Generator_UserColumnName", "Product ID");
base.Columns.Add(this.columnProduct_ID);
this.columnSupplier_ID = new System.Data.DataColumn("Supplier ID", typeof(int), null, System.Data.MappingType.Element);
this.columnSupplier_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Supplier_ID");
this.columnSupplier_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Supplier_IDColumn");
this.columnSupplier_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnSupplier_ID");
this.columnSupplier_ID.ExtendedProperties.Add("Generator_UserColumnName", "Supplier ID");
base.Columns.Add(this.columnSupplier_ID);
this.columnCategory_ID = new System.Data.DataColumn("Category ID", typeof(int), null, System.Data.MappingType.Element);
this.columnCategory_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Category_ID");
this.columnCategory_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Category_IDColumn");
this.columnCategory_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCategory_ID");
this.columnCategory_ID.ExtendedProperties.Add("Generator_UserColumnName", "Category ID");
base.Columns.Add(this.columnCategory_ID);
this.columnProduct_Name = new System.Data.DataColumn("Product Name", typeof(string), null, System.Data.MappingType.Element);
this.columnProduct_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Product_Name");
this.columnProduct_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Product_NameColumn");
this.columnProduct_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnProduct_Name");
this.columnProduct_Name.ExtendedProperties.Add("Generator_UserColumnName", "Product Name");
base.Columns.Add(this.columnProduct_Name);
this.columnEnglish_Name = new System.Data.DataColumn("English Name", typeof(string), null, System.Data.MappingType.Element);
this.columnEnglish_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "English_Name");
this.columnEnglish_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "English_NameColumn");
this.columnEnglish_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnEnglish_Name");
this.columnEnglish_Name.ExtendedProperties.Add("Generator_UserColumnName", "English Name");
base.Columns.Add(this.columnEnglish_Name);
this.columnQuantity_Per_Unit = new System.Data.DataColumn("Quantity Per Unit", typeof(string), null, System.Data.MappingType.Element);
this.columnQuantity_Per_Unit.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Quantity_Per_Unit");
this.columnQuantity_Per_Unit.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Quantity_Per_UnitColumn");
this.columnQuantity_Per_Unit.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnQuantity_Per_Unit");
this.columnQuantity_Per_Unit.ExtendedProperties.Add("Generator_UserColumnName", "Quantity Per Unit");
base.Columns.Add(this.columnQuantity_Per_Unit);
this.columnUnit_Price = new System.Data.DataColumn("Unit Price", typeof(decimal), null, System.Data.MappingType.Element);
this.columnUnit_Price.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Unit_Price");
this.columnUnit_Price.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Unit_PriceColumn");
this.columnUnit_Price.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnUnit_Price");
this.columnUnit_Price.ExtendedProperties.Add("Generator_UserColumnName", "Unit Price");
base.Columns.Add(this.columnUnit_Price);
this.columnUnits_In_Stock = new System.Data.DataColumn("Units In Stock", typeof(short), null, System.Data.MappingType.Element);
this.columnUnits_In_Stock.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Units_In_Stock");
this.columnUnits_In_Stock.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Units_In_StockColumn");
this.columnUnits_In_Stock.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnUnits_In_Stock");
this.columnUnits_In_Stock.ExtendedProperties.Add("Generator_UserColumnName", "Units In Stock");
base.Columns.Add(this.columnUnits_In_Stock);
this.columnUnits_On_Order = new System.Data.DataColumn("Units On Order", typeof(short), null, System.Data.MappingType.Element);
this.columnUnits_On_Order.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Units_On_Order");
this.columnUnits_On_Order.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Units_On_OrderColumn");
this.columnUnits_On_Order.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnUnits_On_Order");
this.columnUnits_On_Order.ExtendedProperties.Add("Generator_UserColumnName", "Units On Order");
base.Columns.Add(this.columnUnits_On_Order);
this.columnReorder_Level = new System.Data.DataColumn("Reorder Level", typeof(short), null, System.Data.MappingType.Element);
this.columnReorder_Level.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Reorder_Level");
this.columnReorder_Level.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Reorder_LevelColumn");
this.columnReorder_Level.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnReorder_Level");
this.columnReorder_Level.ExtendedProperties.Add("Generator_UserColumnName", "Reorder Level");
base.Columns.Add(this.columnReorder_Level);
this.columnDiscontinued = new System.Data.DataColumn("Discontinued", typeof(bool), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnDiscontinued);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnProduct_ID}, true));
this.columnProduct_ID.AutoIncrement = true;
this.columnProduct_ID.AllowDBNull = false;
this.columnProduct_ID.ReadOnly = true;
this.columnProduct_ID.Unique = true;
this.columnProduct_Name.AllowDBNull = false;
this.columnProduct_Name.MaxLength = 40;
this.columnEnglish_Name.MaxLength = 40;
this.columnQuantity_Per_Unit.MaxLength = 20;
this.columnDiscontinued.AllowDBNull = false;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow NewProductsRow() {
return ((ProductsRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new ProductsRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(ProductsRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.ProductsRowChanged != null)) {
this.ProductsRowChanged(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.ProductsRowChanging != null)) {
this.ProductsRowChanging(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.ProductsRowDeleted != null)) {
this.ProductsRowDeleted(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.ProductsRowDeleting != null)) {
this.ProductsRowDeleting(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveProductsRow(ProductsRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "ProductsDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class ShippersDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnShipper_ID;
private System.Data.DataColumn columnCompany_Name;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersDataTable() {
this.TableName = "Shippers";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal ShippersDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Shipper_IDColumn {
get {
return this.columnShipper_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Company_NameColumn {
get {
return this.columnCompany_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRow this[int index] {
get {
return ((ShippersRow)(this.Rows[index]));
}
}
public event ShippersRowChangeEventHandler ShippersRowChanging;
public event ShippersRowChangeEventHandler ShippersRowChanged;
public event ShippersRowChangeEventHandler ShippersRowDeleting;
public event ShippersRowChangeEventHandler ShippersRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddShippersRow(ShippersRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRow AddShippersRow(string Company_Name) {
ShippersRow rowShippersRow = ((ShippersRow)(this.NewRow()));
rowShippersRow.ItemArray = new object[] {
null,
Company_Name};
this.Rows.Add(rowShippersRow);
return rowShippersRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRow FindByShipper_ID(int Shipper_ID) {
return ((ShippersRow)(this.Rows.Find(new object[] {
Shipper_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
ShippersDataTable cln = ((ShippersDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new ShippersDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnShipper_ID = base.Columns["Shipper ID"];
this.columnCompany_Name = base.Columns["Company Name"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnShipper_ID = new System.Data.DataColumn("Shipper ID", typeof(int), null, System.Data.MappingType.Element);
this.columnShipper_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Shipper_ID");
this.columnShipper_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Shipper_IDColumn");
this.columnShipper_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnShipper_ID");
this.columnShipper_ID.ExtendedProperties.Add("Generator_UserColumnName", "Shipper ID");
base.Columns.Add(this.columnShipper_ID);
this.columnCompany_Name = new System.Data.DataColumn("Company Name", typeof(string), null, System.Data.MappingType.Element);
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Company_Name");
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Company_NameColumn");
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCompany_Name");
this.columnCompany_Name.ExtendedProperties.Add("Generator_UserColumnName", "Company Name");
base.Columns.Add(this.columnCompany_Name);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnShipper_ID}, true));
this.columnShipper_ID.AutoIncrement = true;
this.columnShipper_ID.AllowDBNull = false;
this.columnShipper_ID.ReadOnly = true;
this.columnShipper_ID.Unique = true;
this.columnCompany_Name.AllowDBNull = false;
this.columnCompany_Name.MaxLength = 40;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRow NewShippersRow() {
return ((ShippersRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new ShippersRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(ShippersRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.ShippersRowChanged != null)) {
this.ShippersRowChanged(this, new ShippersRowChangeEvent(((ShippersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.ShippersRowChanging != null)) {
this.ShippersRowChanging(this, new ShippersRowChangeEvent(((ShippersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.ShippersRowDeleted != null)) {
this.ShippersRowDeleted(this, new ShippersRowChangeEvent(((ShippersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.ShippersRowDeleting != null)) {
this.ShippersRowDeleting(this, new ShippersRowChangeEvent(((ShippersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveShippersRow(ShippersRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "ShippersDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class SuppliersDataTable : System.Data.DataTable, System.Collections.IEnumerable {
private System.Data.DataColumn columnSupplier_ID;
private System.Data.DataColumn columnCompany_Name;
private System.Data.DataColumn columnContact_Name;
private System.Data.DataColumn columnContact_Title;
private System.Data.DataColumn columnAddress;
private System.Data.DataColumn columnCity;
private System.Data.DataColumn columnRegion;
private System.Data.DataColumn columnPostal_Code;
private System.Data.DataColumn columnCountry;
private System.Data.DataColumn columnPhone;
private System.Data.DataColumn columnFax;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersDataTable() {
this.TableName = "Suppliers";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal SuppliersDataTable(System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Supplier_IDColumn {
get {
return this.columnSupplier_ID;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Company_NameColumn {
get {
return this.columnCompany_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Contact_NameColumn {
get {
return this.columnContact_Name;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Contact_TitleColumn {
get {
return this.columnContact_Title;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn AddressColumn {
get {
return this.columnAddress;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn CityColumn {
get {
return this.columnCity;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn RegionColumn {
get {
return this.columnRegion;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn Postal_CodeColumn {
get {
return this.columnPostal_Code;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn CountryColumn {
get {
return this.columnCountry;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn PhoneColumn {
get {
return this.columnPhone;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataColumn FaxColumn {
get {
return this.columnFax;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Count {
get {
return this.Rows.Count;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRow this[int index] {
get {
return ((SuppliersRow)(this.Rows[index]));
}
}
public event SuppliersRowChangeEventHandler SuppliersRowChanging;
public event SuppliersRowChangeEventHandler SuppliersRowChanged;
public event SuppliersRowChangeEventHandler SuppliersRowDeleting;
public event SuppliersRowChangeEventHandler SuppliersRowDeleted;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddSuppliersRow(SuppliersRow row) {
this.Rows.Add(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRow AddSuppliersRow(string Company_Name, string Contact_Name, string Contact_Title, string Address, string City, string Region, string Postal_Code, string Country, string Phone, string Fax) {
SuppliersRow rowSuppliersRow = ((SuppliersRow)(this.NewRow()));
rowSuppliersRow.ItemArray = new object[] {
null,
Company_Name,
Contact_Name,
Contact_Title,
Address,
City,
Region,
Postal_Code,
Country,
Phone,
Fax};
this.Rows.Add(rowSuppliersRow);
return rowSuppliersRow;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRow FindBySupplier_ID(int Supplier_ID) {
return ((SuppliersRow)(this.Rows.Find(new object[] {
Supplier_ID})));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public override System.Data.DataTable Clone() {
SuppliersDataTable cln = ((SuppliersDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataTable CreateInstance() {
return new SuppliersDataTable();
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnSupplier_ID = base.Columns["Supplier ID"];
this.columnCompany_Name = base.Columns["Company Name"];
this.columnContact_Name = base.Columns["Contact Name"];
this.columnContact_Title = base.Columns["Contact Title"];
this.columnAddress = base.Columns["Address"];
this.columnCity = base.Columns["City"];
this.columnRegion = base.Columns["Region"];
this.columnPostal_Code = base.Columns["Postal Code"];
this.columnCountry = base.Columns["Country"];
this.columnPhone = base.Columns["Phone"];
this.columnFax = base.Columns["Fax"];
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnSupplier_ID = new System.Data.DataColumn("Supplier ID", typeof(int), null, System.Data.MappingType.Element);
this.columnSupplier_ID.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Supplier_ID");
this.columnSupplier_ID.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Supplier_IDColumn");
this.columnSupplier_ID.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnSupplier_ID");
this.columnSupplier_ID.ExtendedProperties.Add("Generator_UserColumnName", "Supplier ID");
base.Columns.Add(this.columnSupplier_ID);
this.columnCompany_Name = new System.Data.DataColumn("Company Name", typeof(string), null, System.Data.MappingType.Element);
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Company_Name");
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Company_NameColumn");
this.columnCompany_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnCompany_Name");
this.columnCompany_Name.ExtendedProperties.Add("Generator_UserColumnName", "Company Name");
base.Columns.Add(this.columnCompany_Name);
this.columnContact_Name = new System.Data.DataColumn("Contact Name", typeof(string), null, System.Data.MappingType.Element);
this.columnContact_Name.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Contact_Name");
this.columnContact_Name.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Contact_NameColumn");
this.columnContact_Name.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnContact_Name");
this.columnContact_Name.ExtendedProperties.Add("Generator_UserColumnName", "Contact Name");
base.Columns.Add(this.columnContact_Name);
this.columnContact_Title = new System.Data.DataColumn("Contact Title", typeof(string), null, System.Data.MappingType.Element);
this.columnContact_Title.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Contact_Title");
this.columnContact_Title.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Contact_TitleColumn");
this.columnContact_Title.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnContact_Title");
this.columnContact_Title.ExtendedProperties.Add("Generator_UserColumnName", "Contact Title");
base.Columns.Add(this.columnContact_Title);
this.columnAddress = new System.Data.DataColumn("Address", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnAddress);
this.columnCity = new System.Data.DataColumn("City", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnCity);
this.columnRegion = new System.Data.DataColumn("Region", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnRegion);
this.columnPostal_Code = new System.Data.DataColumn("Postal Code", typeof(string), null, System.Data.MappingType.Element);
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInRow", "Postal_Code");
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnPropNameInTable", "Postal_CodeColumn");
this.columnPostal_Code.ExtendedProperties.Add("Generator_ColumnVarNameInTable", "columnPostal_Code");
this.columnPostal_Code.ExtendedProperties.Add("Generator_UserColumnName", "Postal Code");
base.Columns.Add(this.columnPostal_Code);
this.columnCountry = new System.Data.DataColumn("Country", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnCountry);
this.columnPhone = new System.Data.DataColumn("Phone", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnPhone);
this.columnFax = new System.Data.DataColumn("Fax", typeof(string), null, System.Data.MappingType.Element);
base.Columns.Add(this.columnFax);
this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
this.columnSupplier_ID}, true));
this.columnSupplier_ID.AutoIncrement = true;
this.columnSupplier_ID.AllowDBNull = false;
this.columnSupplier_ID.ReadOnly = true;
this.columnSupplier_ID.Unique = true;
this.columnCompany_Name.AllowDBNull = false;
this.columnCompany_Name.MaxLength = 40;
this.columnContact_Name.MaxLength = 30;
this.columnContact_Title.MaxLength = 30;
this.columnAddress.MaxLength = 60;
this.columnCity.MaxLength = 15;
this.columnRegion.MaxLength = 15;
this.columnPostal_Code.MaxLength = 10;
this.columnCountry.MaxLength = 15;
this.columnPhone.MaxLength = 24;
this.columnFax.MaxLength = 24;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRow NewSuppliersRow() {
return ((SuppliersRow)(this.NewRow()));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
return new SuppliersRow(builder);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override System.Type GetRowType() {
return typeof(SuppliersRow);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.SuppliersRowChanged != null)) {
this.SuppliersRowChanged(this, new SuppliersRowChangeEvent(((SuppliersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.SuppliersRowChanging != null)) {
this.SuppliersRowChanging(this, new SuppliersRowChangeEvent(((SuppliersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.SuppliersRowDeleted != null)) {
this.SuppliersRowDeleted(this, new SuppliersRowChangeEvent(((SuppliersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.SuppliersRowDeleting != null)) {
this.SuppliersRowDeleting(this, new SuppliersRowChangeEvent(((SuppliersRow)(e.Row)), e.Action));
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveSuppliersRow(SuppliersRow row) {
this.Rows.Remove(row);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "SuppliersDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return type;
}
}
public partial class CategoriesRow : System.Data.DataRow {
private CategoriesDataTable tableCategories;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal CategoriesRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableCategories = ((CategoriesDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Category_ID {
get {
return ((int)(this[this.tableCategories.Category_IDColumn]));
}
set {
this[this.tableCategories.Category_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Category_Name {
get {
return ((string)(this[this.tableCategories.Category_NameColumn]));
}
set {
this[this.tableCategories.Category_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Description {
get {
try {
return ((string)(this[this.tableCategories.DescriptionColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Description\' in table \'Categories\' is DBNull.", e);
}
}
set {
this[this.tableCategories.DescriptionColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public byte[] Picture {
get {
try {
return ((byte[])(this[this.tableCategories.PictureColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Picture\' in table \'Categories\' is DBNull.", e);
}
}
set {
this[this.tableCategories.PictureColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsDescriptionNull() {
return this.IsNull(this.tableCategories.DescriptionColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetDescriptionNull() {
this[this.tableCategories.DescriptionColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPictureNull() {
return this.IsNull(this.tableCategories.PictureColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPictureNull() {
this[this.tableCategories.PictureColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow[] GetProductsRows() {
return ((ProductsRow[])(base.GetChildRows(this.Table.ChildRelations["Products_FK01"])));
}
}
public partial class CustomersRow : System.Data.DataRow {
private CustomersDataTable tableCustomers;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal CustomersRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableCustomers = ((CustomersDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Customer_ID {
get {
return ((string)(this[this.tableCustomers.Customer_IDColumn]));
}
set {
this[this.tableCustomers.Customer_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Company_Name {
get {
return ((string)(this[this.tableCustomers.Company_NameColumn]));
}
set {
this[this.tableCustomers.Company_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Contact_Name {
get {
try {
return ((string)(this[this.tableCustomers.Contact_NameColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Contact Name\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.Contact_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Contact_Title {
get {
try {
return ((string)(this[this.tableCustomers.Contact_TitleColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Contact Title\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.Contact_TitleColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Address {
get {
try {
return ((string)(this[this.tableCustomers.AddressColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Address\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.AddressColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string City {
get {
try {
return ((string)(this[this.tableCustomers.CityColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'City\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.CityColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Region {
get {
try {
return ((string)(this[this.tableCustomers.RegionColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Region\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.RegionColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Postal_Code {
get {
try {
return ((string)(this[this.tableCustomers.Postal_CodeColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Postal Code\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.Postal_CodeColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Country {
get {
try {
return ((string)(this[this.tableCustomers.CountryColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Country\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.CountryColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Phone {
get {
try {
return ((string)(this[this.tableCustomers.PhoneColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Phone\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.PhoneColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Fax {
get {
try {
return ((string)(this[this.tableCustomers.FaxColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Fax\' in table \'Customers\' is DBNull.", e);
}
}
set {
this[this.tableCustomers.FaxColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsContact_NameNull() {
return this.IsNull(this.tableCustomers.Contact_NameColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetContact_NameNull() {
this[this.tableCustomers.Contact_NameColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsContact_TitleNull() {
return this.IsNull(this.tableCustomers.Contact_TitleColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetContact_TitleNull() {
this[this.tableCustomers.Contact_TitleColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAddressNull() {
return this.IsNull(this.tableCustomers.AddressColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAddressNull() {
this[this.tableCustomers.AddressColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCityNull() {
return this.IsNull(this.tableCustomers.CityColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCityNull() {
this[this.tableCustomers.CityColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRegionNull() {
return this.IsNull(this.tableCustomers.RegionColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRegionNull() {
this[this.tableCustomers.RegionColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPostal_CodeNull() {
return this.IsNull(this.tableCustomers.Postal_CodeColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPostal_CodeNull() {
this[this.tableCustomers.Postal_CodeColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCountryNull() {
return this.IsNull(this.tableCustomers.CountryColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCountryNull() {
this[this.tableCustomers.CountryColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPhoneNull() {
return this.IsNull(this.tableCustomers.PhoneColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPhoneNull() {
this[this.tableCustomers.PhoneColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsFaxNull() {
return this.IsNull(this.tableCustomers.FaxColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetFaxNull() {
this[this.tableCustomers.FaxColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow[] GetOrdersRows() {
return ((OrdersRow[])(base.GetChildRows(this.Table.ChildRelations["Orders_FK00"])));
}
}
public partial class EmployeesRow : System.Data.DataRow {
private EmployeesDataTable tableEmployees;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal EmployeesRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableEmployees = ((EmployeesDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Employee_ID {
get {
return ((int)(this[this.tableEmployees.Employee_IDColumn]));
}
set {
this[this.tableEmployees.Employee_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Last_Name {
get {
return ((string)(this[this.tableEmployees.Last_NameColumn]));
}
set {
this[this.tableEmployees.Last_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string First_Name {
get {
return ((string)(this[this.tableEmployees.First_NameColumn]));
}
set {
this[this.tableEmployees.First_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Title {
get {
try {
return ((string)(this[this.tableEmployees.TitleColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Title\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.TitleColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime Birth_Date {
get {
try {
return ((System.DateTime)(this[this.tableEmployees.Birth_DateColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Birth Date\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.Birth_DateColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime Hire_Date {
get {
try {
return ((System.DateTime)(this[this.tableEmployees.Hire_DateColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Hire Date\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.Hire_DateColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Address {
get {
try {
return ((string)(this[this.tableEmployees.AddressColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Address\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.AddressColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string City {
get {
try {
return ((string)(this[this.tableEmployees.CityColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'City\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.CityColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Region {
get {
try {
return ((string)(this[this.tableEmployees.RegionColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Region\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.RegionColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Postal_Code {
get {
try {
return ((string)(this[this.tableEmployees.Postal_CodeColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Postal Code\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.Postal_CodeColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Country {
get {
try {
return ((string)(this[this.tableEmployees.CountryColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Country\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.CountryColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Home_Phone {
get {
try {
return ((string)(this[this.tableEmployees.Home_PhoneColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Home Phone\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.Home_PhoneColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Extension {
get {
try {
return ((string)(this[this.tableEmployees.ExtensionColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Extension\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.ExtensionColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public byte[] Photo {
get {
try {
return ((byte[])(this[this.tableEmployees.PhotoColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Photo\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.PhotoColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Notes {
get {
try {
return ((string)(this[this.tableEmployees.NotesColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Notes\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.NotesColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Reports_To {
get {
try {
return ((int)(this[this.tableEmployees.Reports_ToColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Reports To\' in table \'Employees\' is DBNull.", e);
}
}
set {
this[this.tableEmployees.Reports_ToColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsTitleNull() {
return this.IsNull(this.tableEmployees.TitleColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetTitleNull() {
this[this.tableEmployees.TitleColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsBirth_DateNull() {
return this.IsNull(this.tableEmployees.Birth_DateColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetBirth_DateNull() {
this[this.tableEmployees.Birth_DateColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsHire_DateNull() {
return this.IsNull(this.tableEmployees.Hire_DateColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetHire_DateNull() {
this[this.tableEmployees.Hire_DateColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAddressNull() {
return this.IsNull(this.tableEmployees.AddressColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAddressNull() {
this[this.tableEmployees.AddressColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCityNull() {
return this.IsNull(this.tableEmployees.CityColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCityNull() {
this[this.tableEmployees.CityColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRegionNull() {
return this.IsNull(this.tableEmployees.RegionColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRegionNull() {
this[this.tableEmployees.RegionColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPostal_CodeNull() {
return this.IsNull(this.tableEmployees.Postal_CodeColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPostal_CodeNull() {
this[this.tableEmployees.Postal_CodeColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCountryNull() {
return this.IsNull(this.tableEmployees.CountryColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCountryNull() {
this[this.tableEmployees.CountryColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsHome_PhoneNull() {
return this.IsNull(this.tableEmployees.Home_PhoneColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetHome_PhoneNull() {
this[this.tableEmployees.Home_PhoneColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsExtensionNull() {
return this.IsNull(this.tableEmployees.ExtensionColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetExtensionNull() {
this[this.tableEmployees.ExtensionColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPhotoNull() {
return this.IsNull(this.tableEmployees.PhotoColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPhotoNull() {
this[this.tableEmployees.PhotoColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsNotesNull() {
return this.IsNull(this.tableEmployees.NotesColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetNotesNull() {
this[this.tableEmployees.NotesColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsReports_ToNull() {
return this.IsNull(this.tableEmployees.Reports_ToColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetReports_ToNull() {
this[this.tableEmployees.Reports_ToColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow[] GetOrdersRows() {
return ((OrdersRow[])(base.GetChildRows(this.Table.ChildRelations["Orders_FK02"])));
}
}
public partial class Order_DetailsRow : System.Data.DataRow {
private Order_DetailsDataTable tableOrder_Details;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal Order_DetailsRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableOrder_Details = ((Order_DetailsDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Order_ID {
get {
return ((int)(this[this.tableOrder_Details.Order_IDColumn]));
}
set {
this[this.tableOrder_Details.Order_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Product_ID {
get {
return ((int)(this[this.tableOrder_Details.Product_IDColumn]));
}
set {
this[this.tableOrder_Details.Product_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public decimal Unit_Price {
get {
return ((decimal)(this[this.tableOrder_Details.Unit_PriceColumn]));
}
set {
this[this.tableOrder_Details.Unit_PriceColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public short Quantity {
get {
return ((short)(this[this.tableOrder_Details.QuantityColumn]));
}
set {
this[this.tableOrder_Details.QuantityColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public float Discount {
get {
return ((float)(this[this.tableOrder_Details.DiscountColumn]));
}
set {
this[this.tableOrder_Details.DiscountColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow ProductsRow {
get {
return ((ProductsRow)(this.GetParentRow(this.Table.ParentRelations["Order Details_FK00"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Order Details_FK00"]);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow OrdersRow {
get {
return ((OrdersRow)(this.GetParentRow(this.Table.ParentRelations["Order Details_FK01"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Order Details_FK01"]);
}
}
}
public partial class OrdersRow : System.Data.DataRow {
private OrdersDataTable tableOrders;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal OrdersRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableOrders = ((OrdersDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Order_ID {
get {
return ((int)(this[this.tableOrders.Order_IDColumn]));
}
set {
this[this.tableOrders.Order_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Customer_ID {
get {
return ((string)(this[this.tableOrders.Customer_IDColumn]));
}
set {
this[this.tableOrders.Customer_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Employee_ID {
get {
try {
return ((int)(this[this.tableOrders.Employee_IDColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Employee ID\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Employee_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Ship_Name {
get {
try {
return ((string)(this[this.tableOrders.Ship_NameColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship Name\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Ship_Address {
get {
try {
return ((string)(this[this.tableOrders.Ship_AddressColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship Address\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_AddressColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Ship_City {
get {
try {
return ((string)(this[this.tableOrders.Ship_CityColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship City\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_CityColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Ship_Region {
get {
try {
return ((string)(this[this.tableOrders.Ship_RegionColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship Region\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_RegionColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Ship_Postal_Code {
get {
try {
return ((string)(this[this.tableOrders.Ship_Postal_CodeColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship Postal Code\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_Postal_CodeColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Ship_Country {
get {
try {
return ((string)(this[this.tableOrders.Ship_CountryColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship Country\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_CountryColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Ship_Via {
get {
try {
return ((int)(this[this.tableOrders.Ship_ViaColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Ship Via\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Ship_ViaColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime Order_Date {
get {
try {
return ((System.DateTime)(this[this.tableOrders.Order_DateColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Order Date\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Order_DateColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime Required_Date {
get {
try {
return ((System.DateTime)(this[this.tableOrders.Required_DateColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Required Date\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Required_DateColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.DateTime Shipped_Date {
get {
try {
return ((System.DateTime)(this[this.tableOrders.Shipped_DateColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Shipped Date\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.Shipped_DateColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public decimal Freight {
get {
try {
return ((decimal)(this[this.tableOrders.FreightColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Freight\' in table \'Orders\' is DBNull.", e);
}
}
set {
this[this.tableOrders.FreightColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRow CustomersRow {
get {
return ((CustomersRow)(this.GetParentRow(this.Table.ParentRelations["Orders_FK00"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Orders_FK00"]);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRow ShippersRow {
get {
return ((ShippersRow)(this.GetParentRow(this.Table.ParentRelations["Orders_FK01"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Orders_FK01"]);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRow EmployeesRow {
get {
return ((EmployeesRow)(this.GetParentRow(this.Table.ParentRelations["Orders_FK02"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Orders_FK02"]);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsEmployee_IDNull() {
return this.IsNull(this.tableOrders.Employee_IDColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetEmployee_IDNull() {
this[this.tableOrders.Employee_IDColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_NameNull() {
return this.IsNull(this.tableOrders.Ship_NameColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_NameNull() {
this[this.tableOrders.Ship_NameColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_AddressNull() {
return this.IsNull(this.tableOrders.Ship_AddressColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_AddressNull() {
this[this.tableOrders.Ship_AddressColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_CityNull() {
return this.IsNull(this.tableOrders.Ship_CityColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_CityNull() {
this[this.tableOrders.Ship_CityColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_RegionNull() {
return this.IsNull(this.tableOrders.Ship_RegionColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_RegionNull() {
this[this.tableOrders.Ship_RegionColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_Postal_CodeNull() {
return this.IsNull(this.tableOrders.Ship_Postal_CodeColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_Postal_CodeNull() {
this[this.tableOrders.Ship_Postal_CodeColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_CountryNull() {
return this.IsNull(this.tableOrders.Ship_CountryColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_CountryNull() {
this[this.tableOrders.Ship_CountryColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShip_ViaNull() {
return this.IsNull(this.tableOrders.Ship_ViaColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShip_ViaNull() {
this[this.tableOrders.Ship_ViaColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsOrder_DateNull() {
return this.IsNull(this.tableOrders.Order_DateColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetOrder_DateNull() {
this[this.tableOrders.Order_DateColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRequired_DateNull() {
return this.IsNull(this.tableOrders.Required_DateColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRequired_DateNull() {
this[this.tableOrders.Required_DateColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsShipped_DateNull() {
return this.IsNull(this.tableOrders.Shipped_DateColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetShipped_DateNull() {
this[this.tableOrders.Shipped_DateColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsFreightNull() {
return this.IsNull(this.tableOrders.FreightColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetFreightNull() {
this[this.tableOrders.FreightColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow[] GetOrder_DetailsRows() {
return ((Order_DetailsRow[])(base.GetChildRows(this.Table.ChildRelations["Order Details_FK01"])));
}
}
public partial class ProductsRow : System.Data.DataRow {
private ProductsDataTable tableProducts;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal ProductsRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableProducts = ((ProductsDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Product_ID {
get {
return ((int)(this[this.tableProducts.Product_IDColumn]));
}
set {
this[this.tableProducts.Product_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Supplier_ID {
get {
try {
return ((int)(this[this.tableProducts.Supplier_IDColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Supplier ID\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Supplier_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Category_ID {
get {
try {
return ((int)(this[this.tableProducts.Category_IDColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Category ID\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Category_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Product_Name {
get {
return ((string)(this[this.tableProducts.Product_NameColumn]));
}
set {
this[this.tableProducts.Product_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string English_Name {
get {
try {
return ((string)(this[this.tableProducts.English_NameColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'English Name\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.English_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Quantity_Per_Unit {
get {
try {
return ((string)(this[this.tableProducts.Quantity_Per_UnitColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Quantity Per Unit\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Quantity_Per_UnitColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public decimal Unit_Price {
get {
try {
return ((decimal)(this[this.tableProducts.Unit_PriceColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Unit Price\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Unit_PriceColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public short Units_In_Stock {
get {
try {
return ((short)(this[this.tableProducts.Units_In_StockColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Units In Stock\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Units_In_StockColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public short Units_On_Order {
get {
try {
return ((short)(this[this.tableProducts.Units_On_OrderColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Units On Order\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Units_On_OrderColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public short Reorder_Level {
get {
try {
return ((short)(this[this.tableProducts.Reorder_LevelColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Reorder Level\' in table \'Products\' is DBNull.", e);
}
}
set {
this[this.tableProducts.Reorder_LevelColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool Discontinued {
get {
return ((bool)(this[this.tableProducts.DiscontinuedColumn]));
}
set {
this[this.tableProducts.DiscontinuedColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRow SuppliersRow {
get {
return ((SuppliersRow)(this.GetParentRow(this.Table.ParentRelations["Products_FK00"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Products_FK00"]);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRow CategoriesRow {
get {
return ((CategoriesRow)(this.GetParentRow(this.Table.ParentRelations["Products_FK01"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["Products_FK01"]);
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsSupplier_IDNull() {
return this.IsNull(this.tableProducts.Supplier_IDColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetSupplier_IDNull() {
this[this.tableProducts.Supplier_IDColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCategory_IDNull() {
return this.IsNull(this.tableProducts.Category_IDColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCategory_IDNull() {
this[this.tableProducts.Category_IDColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsEnglish_NameNull() {
return this.IsNull(this.tableProducts.English_NameColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetEnglish_NameNull() {
this[this.tableProducts.English_NameColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsQuantity_Per_UnitNull() {
return this.IsNull(this.tableProducts.Quantity_Per_UnitColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetQuantity_Per_UnitNull() {
this[this.tableProducts.Quantity_Per_UnitColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsUnit_PriceNull() {
return this.IsNull(this.tableProducts.Unit_PriceColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetUnit_PriceNull() {
this[this.tableProducts.Unit_PriceColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsUnits_In_StockNull() {
return this.IsNull(this.tableProducts.Units_In_StockColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetUnits_In_StockNull() {
this[this.tableProducts.Units_In_StockColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsUnits_On_OrderNull() {
return this.IsNull(this.tableProducts.Units_On_OrderColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetUnits_On_OrderNull() {
this[this.tableProducts.Units_On_OrderColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsReorder_LevelNull() {
return this.IsNull(this.tableProducts.Reorder_LevelColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetReorder_LevelNull() {
this[this.tableProducts.Reorder_LevelColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow[] GetOrder_DetailsRows() {
return ((Order_DetailsRow[])(base.GetChildRows(this.Table.ChildRelations["Order Details_FK00"])));
}
}
public partial class ShippersRow : System.Data.DataRow {
private ShippersDataTable tableShippers;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal ShippersRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableShippers = ((ShippersDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Shipper_ID {
get {
return ((int)(this[this.tableShippers.Shipper_IDColumn]));
}
set {
this[this.tableShippers.Shipper_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Company_Name {
get {
return ((string)(this[this.tableShippers.Company_NameColumn]));
}
set {
this[this.tableShippers.Company_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow[] GetOrdersRows() {
return ((OrdersRow[])(base.GetChildRows(this.Table.ChildRelations["Orders_FK01"])));
}
}
public partial class SuppliersRow : System.Data.DataRow {
private SuppliersDataTable tableSuppliers;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal SuppliersRow(System.Data.DataRowBuilder rb) :
base(rb) {
this.tableSuppliers = ((SuppliersDataTable)(this.Table));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int Supplier_ID {
get {
return ((int)(this[this.tableSuppliers.Supplier_IDColumn]));
}
set {
this[this.tableSuppliers.Supplier_IDColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Company_Name {
get {
return ((string)(this[this.tableSuppliers.Company_NameColumn]));
}
set {
this[this.tableSuppliers.Company_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Contact_Name {
get {
try {
return ((string)(this[this.tableSuppliers.Contact_NameColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Contact Name\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.Contact_NameColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Contact_Title {
get {
try {
return ((string)(this[this.tableSuppliers.Contact_TitleColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Contact Title\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.Contact_TitleColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Address {
get {
try {
return ((string)(this[this.tableSuppliers.AddressColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Address\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.AddressColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string City {
get {
try {
return ((string)(this[this.tableSuppliers.CityColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'City\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.CityColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Region {
get {
try {
return ((string)(this[this.tableSuppliers.RegionColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Region\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.RegionColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Postal_Code {
get {
try {
return ((string)(this[this.tableSuppliers.Postal_CodeColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Postal Code\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.Postal_CodeColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Country {
get {
try {
return ((string)(this[this.tableSuppliers.CountryColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Country\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.CountryColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Phone {
get {
try {
return ((string)(this[this.tableSuppliers.PhoneColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Phone\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.PhoneColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Fax {
get {
try {
return ((string)(this[this.tableSuppliers.FaxColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("The value for column \'Fax\' in table \'Suppliers\' is DBNull.", e);
}
}
set {
this[this.tableSuppliers.FaxColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsContact_NameNull() {
return this.IsNull(this.tableSuppliers.Contact_NameColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetContact_NameNull() {
this[this.tableSuppliers.Contact_NameColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsContact_TitleNull() {
return this.IsNull(this.tableSuppliers.Contact_TitleColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetContact_TitleNull() {
this[this.tableSuppliers.Contact_TitleColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAddressNull() {
return this.IsNull(this.tableSuppliers.AddressColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAddressNull() {
this[this.tableSuppliers.AddressColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCityNull() {
return this.IsNull(this.tableSuppliers.CityColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCityNull() {
this[this.tableSuppliers.CityColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRegionNull() {
return this.IsNull(this.tableSuppliers.RegionColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRegionNull() {
this[this.tableSuppliers.RegionColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPostal_CodeNull() {
return this.IsNull(this.tableSuppliers.Postal_CodeColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPostal_CodeNull() {
this[this.tableSuppliers.Postal_CodeColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsCountryNull() {
return this.IsNull(this.tableSuppliers.CountryColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetCountryNull() {
this[this.tableSuppliers.CountryColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsPhoneNull() {
return this.IsNull(this.tableSuppliers.PhoneColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetPhoneNull() {
this[this.tableSuppliers.PhoneColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsFaxNull() {
return this.IsNull(this.tableSuppliers.FaxColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetFaxNull() {
this[this.tableSuppliers.FaxColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow[] GetProductsRows() {
return ((ProductsRow[])(base.GetChildRows(this.Table.ChildRelations["Products_FK00"])));
}
}
public class CategoriesRowChangeEvent : System.EventArgs {
private CategoriesRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRowChangeEvent(CategoriesRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class CustomersRowChangeEvent : System.EventArgs {
private CustomersRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRowChangeEvent(CustomersRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class EmployeesRowChangeEvent : System.EventArgs {
private EmployeesRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRowChangeEvent(EmployeesRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class Order_DetailsRowChangeEvent : System.EventArgs {
private Order_DetailsRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRowChangeEvent(Order_DetailsRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class OrdersRowChangeEvent : System.EventArgs {
private OrdersRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRowChangeEvent(OrdersRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class ProductsRowChangeEvent : System.EventArgs {
private ProductsRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRowChangeEvent(ProductsRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class ShippersRowChangeEvent : System.EventArgs {
private ShippersRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRowChangeEvent(ShippersRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
public class SuppliersRowChangeEvent : System.EventArgs {
private SuppliersRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRowChangeEvent(SuppliersRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}
namespace GridSample.NorthwindDataSetTableAdapters {
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class CategoriesTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CategoriesTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Categories";
tableMapping.ColumnMappings.Add("Category ID", "Category ID");
tableMapping.ColumnMappings.Add("Category Name", "Category Name");
tableMapping.ColumnMappings.Add("Description", "Description");
tableMapping.ColumnMappings.Add("Picture", "Picture");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Categories] WHERE (([Category ID] = @p1) AND ([Category Name] = @p2)" +
")";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Category ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Category Name";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [Categories] ([Category Name], [Description], [Picture]) VALUES (@p1," +
" @p2, @p3)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Category Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Description";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.Binary;
param.IsNullable = true;
param.SourceColumn = "Picture";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [Categories] SET [Category Name] = @p1, [Description] = @p2, [Picture] = @" +
"p3 WHERE (([Category ID] = @p4) AND ([Category Name] = @p5))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Category Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Description";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.Binary;
param.IsNullable = true;
param.SourceColumn = "Picture";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Category ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Category Name";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Category ID], [Category Name], [Description], [Picture] FROM [Categories]" +
"";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.CategoriesDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.CategoriesDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.CategoriesDataTable dataTable = new NorthwindDataSet.CategoriesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.CategoriesDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Categories");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1, string p2) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.DeleteCommand.Parameters[1].Value = ((string)(p2));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(string p1, string p2, byte[] p3) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((byte[])(p3));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string p1, string p2, byte[] p3, int p4, string p5) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((byte[])(p3));
}
this.Adapter.UpdateCommand.Parameters[3].Value = ((int)(p4));
if ((p5 == null)) {
throw new System.ArgumentNullException("p5");
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(p5));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class CustomersTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public CustomersTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Customers";
tableMapping.ColumnMappings.Add("Customer ID", "Customer ID");
tableMapping.ColumnMappings.Add("Company Name", "Company Name");
tableMapping.ColumnMappings.Add("Contact Name", "Contact Name");
tableMapping.ColumnMappings.Add("Contact Title", "Contact Title");
tableMapping.ColumnMappings.Add("Address", "Address");
tableMapping.ColumnMappings.Add("City", "City");
tableMapping.ColumnMappings.Add("Region", "Region");
tableMapping.ColumnMappings.Add("Postal Code", "Postal Code");
tableMapping.ColumnMappings.Add("Country", "Country");
tableMapping.ColumnMappings.Add("Phone", "Phone");
tableMapping.ColumnMappings.Add("Fax", "Fax");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Customers] WHERE (([Customer ID] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Customer ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [Customers] ([Customer ID], [Company Name], [Contact Name], [Contact " +
"Title], [Address], [City], [Region], [Postal Code], [Country], [Phone], [Fax]) V" +
"ALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Customer ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Company Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Contact Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "Contact Title";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Address";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "City";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "Region";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Postal Code";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Country";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.IsNullable = true;
param.SourceColumn = "Phone";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.IsNullable = true;
param.SourceColumn = "Fax";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [Customers] SET [Customer ID] = @p1, [Company Name] = @p2, [Contact Name] " +
"= @p3, [Contact Title] = @p4, [Address] = @p5, [City] = @p6, [Region] = @p7, [Po" +
"stal Code] = @p8, [Country] = @p9, [Phone] = @p10, [Fax] = @p11 WHERE (([Custome" +
"r ID] = @p12))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Customer ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Company Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Contact Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "Contact Title";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Address";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "City";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "Region";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Postal Code";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Country";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.IsNullable = true;
param.SourceColumn = "Phone";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.IsNullable = true;
param.SourceColumn = "Fax";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p12";
param.IsNullable = true;
param.SourceColumn = "Customer ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Customer ID], [Company Name], [Contact Name], [Contact Title], [Address]," +
" [City], [Region], [Postal Code], [Country], [Phone], [Fax] FROM [Customers]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.CustomersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.CustomersDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.CustomersDataTable dataTable = new NorthwindDataSet.CustomersDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.CustomersDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Customers");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(string p1) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(p1));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4 == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6 == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10 == null)) {
this.Adapter.InsertCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[9].Value = ((string)(p10));
}
if ((p11 == null)) {
this.Adapter.InsertCommand.Parameters[10].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[10].Value = ((string)(p11));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11, string p12) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4 == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6 == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10 == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(p10));
}
if ((p11 == null)) {
this.Adapter.UpdateCommand.Parameters[10].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(p11));
}
if ((p12 == null)) {
throw new System.ArgumentNullException("p12");
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(p12));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class EmployeesTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public EmployeesTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Employees";
tableMapping.ColumnMappings.Add("Employee ID", "Employee ID");
tableMapping.ColumnMappings.Add("Last Name", "Last Name");
tableMapping.ColumnMappings.Add("First Name", "First Name");
tableMapping.ColumnMappings.Add("Title", "Title");
tableMapping.ColumnMappings.Add("Birth Date", "Birth Date");
tableMapping.ColumnMappings.Add("Hire Date", "Hire Date");
tableMapping.ColumnMappings.Add("Address", "Address");
tableMapping.ColumnMappings.Add("City", "City");
tableMapping.ColumnMappings.Add("Region", "Region");
tableMapping.ColumnMappings.Add("Postal Code", "Postal Code");
tableMapping.ColumnMappings.Add("Country", "Country");
tableMapping.ColumnMappings.Add("Home Phone", "Home Phone");
tableMapping.ColumnMappings.Add("Extension", "Extension");
tableMapping.ColumnMappings.Add("Photo", "Photo");
tableMapping.ColumnMappings.Add("Notes", "Notes");
tableMapping.ColumnMappings.Add("Reports To", "Reports To");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Employees] WHERE (([Employee ID] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Employee ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = @"INSERT INTO [Employees] ([Last Name], [First Name], [Title], [Birth Date], [Hire Date], [Address], [City], [Region], [Postal Code], [Country], [Home Phone], [Extension], [Photo], [Notes], [Reports To]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Last Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "First Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Title";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Birth Date";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Hire Date";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "Address";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "City";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Region";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Postal Code";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.IsNullable = true;
param.SourceColumn = "Country";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.IsNullable = true;
param.SourceColumn = "Home Phone";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p12";
param.IsNullable = true;
param.SourceColumn = "Extension";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p13";
param.DbType = System.Data.DbType.Binary;
param.IsNullable = true;
param.SourceColumn = "Photo";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p14";
param.IsNullable = true;
param.SourceColumn = "Notes";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p15";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Reports To";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE [Employees] SET [Last Name] = @p1, [First Name] = @p2, [Title] = @p3, [Birth Date] = @p4, [Hire Date] = @p5, [Address] = @p6, [City] = @p7, [Region] = @p8, [Postal Code] = @p9, [Country] = @p10, [Home Phone] = @p11, [Extension] = @p12, [Photo] = @p13, [Notes] = @p14, [Reports To] = @p15 WHERE (([Employee ID] = @p16))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Last Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "First Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Title";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Birth Date";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Hire Date";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "Address";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "City";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Region";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Postal Code";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.IsNullable = true;
param.SourceColumn = "Country";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.IsNullable = true;
param.SourceColumn = "Home Phone";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p12";
param.IsNullable = true;
param.SourceColumn = "Extension";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p13";
param.DbType = System.Data.DbType.Binary;
param.IsNullable = true;
param.SourceColumn = "Photo";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p14";
param.IsNullable = true;
param.SourceColumn = "Notes";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p15";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Reports To";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p16";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Employee ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Employee ID], [Last Name], [First Name], [Title], [Birth Date], [Hire Dat" +
"e], [Address], [City], [Region], [Postal Code], [Country], [Home Phone], [Extens" +
"ion], [Photo], [Notes], [Reports To] FROM [Employees]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.EmployeesDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.EmployeesDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.EmployeesDataTable dataTable = new NorthwindDataSet.EmployeesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.EmployeesDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Employees");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(string p1, string p2, string p3, System.Nullable<System.DateTime> p4, System.Nullable<System.DateTime> p5, string p6, string p7, string p8, string p9, string p10, string p11, string p12, byte[] p13, string p14, System.Nullable<int> p15) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[3].Value = ((System.DateTime)(p4.Value));
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
}
if ((p5.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[4].Value = ((System.DateTime)(p5.Value));
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
}
if ((p6 == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10 == null)) {
this.Adapter.InsertCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[9].Value = ((string)(p10));
}
if ((p11 == null)) {
this.Adapter.InsertCommand.Parameters[10].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[10].Value = ((string)(p11));
}
if ((p12 == null)) {
this.Adapter.InsertCommand.Parameters[11].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[11].Value = ((string)(p12));
}
if ((p13 == null)) {
this.Adapter.InsertCommand.Parameters[12].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[12].Value = ((byte[])(p13));
}
if ((p14 == null)) {
this.Adapter.InsertCommand.Parameters[13].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[13].Value = ((string)(p14));
}
if ((p15.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[14].Value = ((int)(p15.Value));
}
else {
this.Adapter.InsertCommand.Parameters[14].Value = System.DBNull.Value;
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(
string p1,
string p2,
string p3,
System.Nullable<System.DateTime> p4,
System.Nullable<System.DateTime> p5,
string p6,
string p7,
string p8,
string p9,
string p10,
string p11,
string p12,
byte[] p13,
string p14,
System.Nullable<int> p15,
int p16) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[3].Value = ((System.DateTime)(p4.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
if ((p5.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[4].Value = ((System.DateTime)(p5.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
if ((p6 == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10 == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(p10));
}
if ((p11 == null)) {
this.Adapter.UpdateCommand.Parameters[10].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(p11));
}
if ((p12 == null)) {
this.Adapter.UpdateCommand.Parameters[11].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(p12));
}
if ((p13 == null)) {
this.Adapter.UpdateCommand.Parameters[12].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[12].Value = ((byte[])(p13));
}
if ((p14 == null)) {
this.Adapter.UpdateCommand.Parameters[13].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[13].Value = ((string)(p14));
}
if ((p15.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[14].Value = ((int)(p15.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[14].Value = System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[15].Value = ((int)(p16));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class Order_DetailsTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public Order_DetailsTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Order Details";
tableMapping.ColumnMappings.Add("Order ID", "Order ID");
tableMapping.ColumnMappings.Add("Product ID", "Product ID");
tableMapping.ColumnMappings.Add("Unit Price", "Unit Price");
tableMapping.ColumnMappings.Add("Quantity", "Quantity");
tableMapping.ColumnMappings.Add("Discount", "Discount");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Order Details] WHERE (([Order ID] = @p1) AND ([Product ID] = @p2))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Product ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [Order Details] ([Order ID], [Product ID], [Unit Price], [Quantity], " +
"[Discount]) VALUES (@p1, @p2, @p3, @p4, @p5)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Product ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.Currency;
param.IsNullable = true;
param.SourceColumn = "Unit Price";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Quantity";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.DbType = System.Data.DbType.Single;
param.IsNullable = true;
param.SourceColumn = "Discount";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [Order Details] SET [Order ID] = @p1, [Product ID] = @p2, [Unit Price] = @" +
"p3, [Quantity] = @p4, [Discount] = @p5 WHERE (([Order ID] = @p6) AND ([Product I" +
"D] = @p7))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Product ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.Currency;
param.IsNullable = true;
param.SourceColumn = "Unit Price";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Quantity";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.DbType = System.Data.DbType.Single;
param.IsNullable = true;
param.SourceColumn = "Discount";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Product ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Order ID], [Product ID], [Unit Price], [Quantity], [Discount] FROM [Order" +
" Details]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.Order_DetailsDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.Order_DetailsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.Order_DetailsDataTable dataTable = new NorthwindDataSet.Order_DetailsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.Order_DetailsDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Order Details");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1, int p2) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
this.Adapter.DeleteCommand.Parameters[1].Value = ((int)(p2));
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(int p1, int p2, decimal p3, short p4, float p5) {
this.Adapter.InsertCommand.Parameters[0].Value = ((int)(p1));
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(p2));
this.Adapter.InsertCommand.Parameters[2].Value = ((decimal)(p3));
this.Adapter.InsertCommand.Parameters[3].Value = ((short)(p4));
this.Adapter.InsertCommand.Parameters[4].Value = ((float)(p5));
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(int p1, int p2, decimal p3, short p4, float p5, int p6, int p7) {
this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(p1));
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(p2));
this.Adapter.UpdateCommand.Parameters[2].Value = ((decimal)(p3));
this.Adapter.UpdateCommand.Parameters[3].Value = ((short)(p4));
this.Adapter.UpdateCommand.Parameters[4].Value = ((float)(p5));
this.Adapter.UpdateCommand.Parameters[5].Value = ((int)(p6));
this.Adapter.UpdateCommand.Parameters[6].Value = ((int)(p7));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class OrdersTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public OrdersTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Orders";
tableMapping.ColumnMappings.Add("Order ID", "Order ID");
tableMapping.ColumnMappings.Add("Customer ID", "Customer ID");
tableMapping.ColumnMappings.Add("Employee ID", "Employee ID");
tableMapping.ColumnMappings.Add("Ship Name", "Ship Name");
tableMapping.ColumnMappings.Add("Ship Address", "Ship Address");
tableMapping.ColumnMappings.Add("Ship City", "Ship City");
tableMapping.ColumnMappings.Add("Ship Region", "Ship Region");
tableMapping.ColumnMappings.Add("Ship Postal Code", "Ship Postal Code");
tableMapping.ColumnMappings.Add("Ship Country", "Ship Country");
tableMapping.ColumnMappings.Add("Ship Via", "Ship Via");
tableMapping.ColumnMappings.Add("Order Date", "Order Date");
tableMapping.ColumnMappings.Add("Required Date", "Required Date");
tableMapping.ColumnMappings.Add("Shipped Date", "Shipped Date");
tableMapping.ColumnMappings.Add("Freight", "Freight");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Orders] WHERE (([Order ID] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = @"INSERT INTO [Orders] ([Order ID], [Customer ID], [Employee ID], [Ship Name], [Ship Address], [Ship City], [Ship Region], [Ship Postal Code], [Ship Country], [Ship Via], [Order Date], [Required Date], [Shipped Date], [Freight]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Customer ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Employee ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "Ship Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Ship Address";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "Ship City";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "Ship Region";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Ship Postal Code";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Ship Country";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Ship Via";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Order Date";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p12";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Required Date";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p13";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Shipped Date";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p14";
param.DbType = System.Data.DbType.Currency;
param.IsNullable = true;
param.SourceColumn = "Freight";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE [Orders] SET [Order ID] = @p1, [Customer ID] = @p2, [Employee ID] = @p3, [Ship Name] = @p4, [Ship Address] = @p5, [Ship City] = @p6, [Ship Region] = @p7, [Ship Postal Code] = @p8, [Ship Country] = @p9, [Ship Via] = @p10, [Order Date] = @p11, [Required Date] = @p12, [Shipped Date] = @p13, [Freight] = @p14 WHERE (([Order ID] = @p15))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Customer ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Employee ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "Ship Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Ship Address";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "Ship City";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "Ship Region";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Ship Postal Code";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Ship Country";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Ship Via";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Order Date";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p12";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Required Date";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p13";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Shipped Date";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p14";
param.DbType = System.Data.DbType.Currency;
param.IsNullable = true;
param.SourceColumn = "Freight";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p15";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Order ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Order ID], [Customer ID], [Employee ID], [Ship Name], [Ship Address], [Sh" +
"ip City], [Ship Region], [Ship Postal Code], [Ship Country], [Ship Via], [Order " +
"Date], [Required Date], [Shipped Date], [Freight] FROM [Orders]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.OrdersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.OrdersDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.OrdersDataTable dataTable = new NorthwindDataSet.OrdersDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.OrdersDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Orders");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(int p1, string p2, System.Nullable<int> p3, string p4, string p5, string p6, string p7, string p8, string p9, System.Nullable<int> p10, System.Nullable<System.DateTime> p11, System.Nullable<System.DateTime> p12, System.Nullable<System.DateTime> p13, System.Nullable<decimal> p14) {
this.Adapter.InsertCommand.Parameters[0].Value = ((int)(p1));
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[2].Value = ((int)(p3.Value));
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
if ((p4 == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6 == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[9].Value = ((int)(p10.Value));
}
else {
this.Adapter.InsertCommand.Parameters[9].Value = System.DBNull.Value;
}
if ((p11.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[10].Value = ((System.DateTime)(p11.Value));
}
else {
this.Adapter.InsertCommand.Parameters[10].Value = System.DBNull.Value;
}
if ((p12.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[11].Value = ((System.DateTime)(p12.Value));
}
else {
this.Adapter.InsertCommand.Parameters[11].Value = System.DBNull.Value;
}
if ((p13.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[12].Value = ((System.DateTime)(p13.Value));
}
else {
this.Adapter.InsertCommand.Parameters[12].Value = System.DBNull.Value;
}
if ((p14.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[13].Value = ((decimal)(p14.Value));
}
else {
this.Adapter.InsertCommand.Parameters[13].Value = System.DBNull.Value;
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(int p1, string p2, System.Nullable<int> p3, string p4, string p5, string p6, string p7, string p8, string p9, System.Nullable<int> p10, System.Nullable<System.DateTime> p11, System.Nullable<System.DateTime> p12, System.Nullable<System.DateTime> p13, System.Nullable<decimal> p14, int p15) {
this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(p1));
if ((p2 == null)) {
throw new System.ArgumentNullException("p2");
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[2].Value = ((int)(p3.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
}
if ((p4 == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6 == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[9].Value = ((int)(p10.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
}
if ((p11.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[10].Value = ((System.DateTime)(p11.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[10].Value = System.DBNull.Value;
}
if ((p12.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[11].Value = ((System.DateTime)(p12.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = System.DBNull.Value;
}
if ((p13.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[12].Value = ((System.DateTime)(p13.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[12].Value = System.DBNull.Value;
}
if ((p14.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[13].Value = ((decimal)(p14.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[13].Value = System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[14].Value = ((int)(p15));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class ProductsTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ProductsTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Products";
tableMapping.ColumnMappings.Add("Product ID", "Product ID");
tableMapping.ColumnMappings.Add("Supplier ID", "Supplier ID");
tableMapping.ColumnMappings.Add("Category ID", "Category ID");
tableMapping.ColumnMappings.Add("Product Name", "Product Name");
tableMapping.ColumnMappings.Add("English Name", "English Name");
tableMapping.ColumnMappings.Add("Quantity Per Unit", "Quantity Per Unit");
tableMapping.ColumnMappings.Add("Unit Price", "Unit Price");
tableMapping.ColumnMappings.Add("Units In Stock", "Units In Stock");
tableMapping.ColumnMappings.Add("Units On Order", "Units On Order");
tableMapping.ColumnMappings.Add("Reorder Level", "Reorder Level");
tableMapping.ColumnMappings.Add("Discontinued", "Discontinued");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Products] WHERE (([Product ID] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Product ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [Products] ([Supplier ID], [Category ID], [Product Name], [English Na" +
"me], [Quantity Per Unit], [Unit Price], [Units In Stock], [Units On Order], [Reo" +
"rder Level], [Discontinued]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9" +
", @p10)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Supplier ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Category ID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Product Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "English Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Quantity Per Unit";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.DbType = System.Data.DbType.Currency;
param.IsNullable = true;
param.SourceColumn = "Unit Price";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Units In Stock";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Units On Order";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Reorder Level";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.DbType = System.Data.DbType.Boolean;
param.IsNullable = true;
param.SourceColumn = "Discontinued";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE [Products] SET [Supplier ID] = @p1, [Category ID] = @p2, [Product Name] = @p3, [English Name] = @p4, [Quantity Per Unit] = @p5, [Unit Price] = @p6, [Units In Stock] = @p7, [Units On Order] = @p8, [Reorder Level] = @p9, [Discontinued] = @p10 WHERE (([Product ID] = @p11))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Supplier ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Category ID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Product Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "English Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "Quantity Per Unit";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.DbType = System.Data.DbType.Currency;
param.IsNullable = true;
param.SourceColumn = "Unit Price";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Units In Stock";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Units On Order";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.DbType = System.Data.DbType.Int16;
param.IsNullable = true;
param.SourceColumn = "Reorder Level";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.DbType = System.Data.DbType.Boolean;
param.IsNullable = true;
param.SourceColumn = "Discontinued";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Product ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Product ID], [Supplier ID], [Category ID], [Product Name], [English Name]" +
", [Quantity Per Unit], [Unit Price], [Units In Stock], [Units On Order], [Reorde" +
"r Level], [Discontinued] FROM [Products]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.ProductsDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.ProductsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.ProductsDataTable dataTable = new NorthwindDataSet.ProductsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.ProductsDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Products");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(System.Nullable<int> p1, System.Nullable<int> p2, string p3, string p4, string p5, System.Nullable<decimal> p6, System.Nullable<short> p7, System.Nullable<short> p8, System.Nullable<short> p9, bool p10) {
if ((p1.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[0].Value = ((int)(p1.Value));
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
}
if ((p2.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(p2.Value));
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((p3 == null)) {
throw new System.ArgumentNullException("p3");
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4 == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[5].Value = ((decimal)(p6.Value));
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
}
if ((p7.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[6].Value = ((short)(p7.Value));
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
}
if ((p8.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[7].Value = ((short)(p8.Value));
}
else {
this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
}
if ((p9.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[8].Value = ((short)(p9.Value));
}
else {
this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
}
this.Adapter.InsertCommand.Parameters[9].Value = ((bool)(p10));
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(System.Nullable<int> p1, System.Nullable<int> p2, string p3, string p4, string p5, System.Nullable<decimal> p6, System.Nullable<short> p7, System.Nullable<short> p8, System.Nullable<short> p9, bool p10, int p11) {
if ((p1.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(p1.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
}
if ((p2.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(p2.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((p3 == null)) {
throw new System.ArgumentNullException("p3");
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4 == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[5].Value = ((decimal)(p6.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
}
if ((p7.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[6].Value = ((short)(p7.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
if ((p8.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[7].Value = ((short)(p8.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
}
if ((p9.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[8].Value = ((short)(p9.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[9].Value = ((bool)(p10));
this.Adapter.UpdateCommand.Parameters[10].Value = ((int)(p11));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class ShippersTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ShippersTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Shippers";
tableMapping.ColumnMappings.Add("Shipper ID", "Shipper ID");
tableMapping.ColumnMappings.Add("Company Name", "Company Name");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Shippers] WHERE (([Shipper ID] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Shipper ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [Shippers] ([Company Name]) VALUES (@p1)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Company Name";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [Shippers] SET [Company Name] = @p1 WHERE (([Shipper ID] = @p2))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Company Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Shipper ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Shipper ID], [Company Name] FROM [Shippers]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.ShippersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.ShippersDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.ShippersDataTable dataTable = new NorthwindDataSet.ShippersDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.ShippersDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Shippers");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(string p1) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string p1, int p2) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
}
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(p2));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.DataObjectAttribute(true)]
public partial class SuppliersTableAdapter : System.ComponentModel.Component {
private System.Data.SqlServerCe.SqlCeDataAdapter _adapter;
private System.Data.SqlServerCe.SqlCeConnection _connection;
private System.Data.SqlServerCe.SqlCeCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public SuppliersTableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlServerCe.SqlCeConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlServerCe.SqlCeCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlServerCe.SqlCeCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Suppliers";
tableMapping.ColumnMappings.Add("Supplier ID", "Supplier ID");
tableMapping.ColumnMappings.Add("Company Name", "Company Name");
tableMapping.ColumnMappings.Add("Contact Name", "Contact Name");
tableMapping.ColumnMappings.Add("Contact Title", "Contact Title");
tableMapping.ColumnMappings.Add("Address", "Address");
tableMapping.ColumnMappings.Add("City", "City");
tableMapping.ColumnMappings.Add("Region", "Region");
tableMapping.ColumnMappings.Add("Postal Code", "Postal Code");
tableMapping.ColumnMappings.Add("Country", "Country");
tableMapping.ColumnMappings.Add("Phone", "Phone");
tableMapping.ColumnMappings.Add("Fax", "Fax");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Suppliers] WHERE (([Supplier ID] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Supplier ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [Suppliers] ([Company Name], [Contact Name], [Contact Title], [Addres" +
"s], [City], [Region], [Postal Code], [Country], [Phone], [Fax]) VALUES (@p1, @p2" +
", @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Company Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Contact Name";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Contact Title";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "Address";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "City";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "Region";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "Postal Code";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Country";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Phone";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.IsNullable = true;
param.SourceColumn = "Fax";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [Suppliers] SET [Company Name] = @p1, [Contact Name] = @p2, [Contact Title" +
"] = @p3, [Address] = @p4, [City] = @p5, [Region] = @p6, [Postal Code] = @p7, [Co" +
"untry] = @p8, [Phone] = @p9, [Fax] = @p10 WHERE (([Supplier ID] = @p11))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.IsNullable = true;
param.SourceColumn = "Company Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.IsNullable = true;
param.SourceColumn = "Contact Name";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.IsNullable = true;
param.SourceColumn = "Contact Title";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.IsNullable = true;
param.SourceColumn = "Address";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p5";
param.IsNullable = true;
param.SourceColumn = "City";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p6";
param.IsNullable = true;
param.SourceColumn = "Region";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p7";
param.IsNullable = true;
param.SourceColumn = "Postal Code";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p8";
param.IsNullable = true;
param.SourceColumn = "Country";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p9";
param.IsNullable = true;
param.SourceColumn = "Phone";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p10";
param.IsNullable = true;
param.SourceColumn = "Fax";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p11";
param.DbType = System.Data.DbType.Int32;
param.IsNullable = true;
param.SourceColumn = "Supplier ID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlServerCe.SqlCeConnection();
this._connection.ConnectionString = ("Data Source ="
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\Northwind.sdf;"));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlServerCe.SqlCeCommand[1];
this._commandCollection[0] = new System.Data.SqlServerCe.SqlCeCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT [Supplier ID], [Company Name], [Contact Name], [Contact Title], [Address]," +
" [City], [Region], [Postal Code], [Country], [Phone], [Fax] FROM [Suppliers]";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(NorthwindDataSet.SuppliersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual NorthwindDataSet.SuppliersDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
NorthwindDataSet.SuppliersDataTable dataTable = new NorthwindDataSet.SuppliersDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet.SuppliersDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Suppliers");
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow dataRow) {
return this.Adapter.Update(new System.Data.DataRow[] {
dataRow});
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public virtual int Update(System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(int p1) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4 == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6 == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10 == null)) {
this.Adapter.InsertCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[9].Value = ((string)(p10));
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, int p11) {
if ((p1 == null)) {
throw new System.ArgumentNullException("p1");
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
}
if ((p2 == null)) {
this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(p2));
}
if ((p3 == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(p3));
}
if ((p4 == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
}
if ((p5 == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(p5));
}
if ((p6 == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(p6));
}
if ((p7 == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(p7));
}
if ((p8 == null)) {
this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(p8));
}
if ((p9 == null)) {
this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(p9));
}
if ((p10 == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(p10));
}
this.Adapter.UpdateCommand.Parameters[10].Value = ((int)(p11));
System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
}
namespace NorthwindDataSetUtil {
using System;
using System.Data;
public partial class DesignerUtil {
public static bool IsDesignTime() {
// Determine if this instance is running against .NET Framework by using the MSCoreLib PublicKeyToken
System.Reflection.Assembly mscorlibAssembly = typeof(int).Assembly;
if ((mscorlibAssembly != null)) {
if (mscorlibAssembly.FullName.ToUpper().EndsWith("B77A5C561934E089")) {
return true;
}
}
return false;
}
public static bool IsRunTime() {
// Determine if this instance is running against .NET Compact Framework by using the MSCoreLib PublicKeyToken
System.Reflection.Assembly mscorlibAssembly = typeof(int).Assembly;
if ((mscorlibAssembly != null)) {
if (mscorlibAssembly.FullName.ToUpper().EndsWith("969DB8053D3322AC")) {
return true;
}
}
return false;
}
}
}