public Form1() { InitializeComponent(); adventureWorksDS = new AdventureWorksDataSet(); salesPersonTA = new AdventureWorksDataSetTableAdapters.SalesPersonTableAdapter(); salesTerritoryTA = new AdventureWorksDataSetTableAdapters.SalesTerritoryTableAdapter(); }
public override global::System.Data.DataSet Clone() { AdventureWorksDataSet cln = ((AdventureWorksDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { AdventureWorksDataSet ds = new AdventureWorksDataSet(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public virtual int FillByModifiedDate(AdventureWorksDataSet.ProductPhotoDataTable dataTable, System.DateTime Date1, System.DateTime Date2) { this.Adapter.SelectCommand = this.CommandCollection[1]; this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(Date1)); this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(Date2)); if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
protected void Page_Load(object sender, EventArgs e) { this.adventureWorksDataSet = new AdventureWorksDataSet(); if (!this.IsPostBack) { this.loadEmployeeName(); this.loadShipMethod(); this.loadVendors(); this.loadPurchaseOrderDescriptions(); this.loadSelectedPurchaseOrder(); } }