示例#1
0
 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;
 }
示例#2
0
        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();
        }
示例#3
0
 public override global::System.Data.DataSet Clone() {
     defaultDataSet cln = ((defaultDataSet)(base.Clone()));
     cln.InitVars();
     cln.SchemaSerializationMode = this.SchemaSerializationMode;
     return cln;
 }