public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { defaultDataSet ds = new defaultDataSet(); 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; }
private void ListViewClick(object sender, SelectionChangedEventArgs e) { DependencyObject obj = (DependencyObject)e.OriginalSource; File DbFile = (File)DBListBox.SelectedItem; string version = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(); string configurations_folder = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\Sanco S.A\\Mega-X Configurator\\V" + version + "\\"; //My documents folder QueriesTableAdapter("attachdbfilename =" + configurations_folder + DbFile.Name + "; data source = " + configurations_folder + DbFile.Name); //QueriesTableAdapter("attachdbfilename =| DataDirectory |\\Database\\" + DbFile.Name + "; data source = Database\\" + DbFile.Name); // Opens an unencrypted database //SQLiteConnection cnn = new SQLiteConnection("Data Source=" + System.IO.Path.GetDirectoryName(Process.GetCurrentProcess().MainModule.FileName) + @"\database\sqlitetest.prgy"); //cnn.SetPassword(""); //cnn.Open(); ////cnn.ChangePassword("1234"); defaultDataSet databaseDataSet = ((defaultDataSet)(this.FindResource("databaseDataSet"))); // Load data into the table Zone. You can modify this code as needed. MainInfoTableAdapter databaseDataSetMainInfoTableAdapter = new MainInfoTableAdapter(); databaseDataSetMainInfoTableAdapter.Fill(databaseDataSet.MainInfo); this.ClientName.Text = databaseDataSet.MainInfo.Rows[0]["ClientName"].ToString(); this.ClientAddr1.Text = databaseDataSet.MainInfo.Rows[0]["Address_1"].ToString(); this.ClientAddr2.Text = databaseDataSet.MainInfo.Rows[0]["Address_2"].ToString(); this.ClientCity.Text = databaseDataSet.MainInfo.Rows[0]["City"].ToString(); this.ClientPostalCode.Text = databaseDataSet.MainInfo.Rows[0]["PostalCode"].ToString(); this.ClientDistrict.Text = databaseDataSet.MainInfo.Rows[0]["District"].ToString(); this.ClientPhone.Text = databaseDataSet.MainInfo.Rows[0]["PhoneNumber"].ToString(); this.ClientFax.Text = databaseDataSet.MainInfo.Rows[0]["FaxNumber"].ToString(); this.ClientEmail.Text = databaseDataSet.MainInfo.Rows[0]["Email"].ToString(); this.ClientWebSite.Text = databaseDataSet.MainInfo.Rows[0]["WebPage"].ToString(); }
public override global::System.Data.DataSet Clone() { defaultDataSet cln = ((defaultDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return cln; }