private void menuImportInfoFromWinShooter_Click(object sender, System.EventArgs e) { this.openFileDialog1.Filter = "*.wsk|*.wsk"; DialogResult res = this.openFileDialog1.ShowDialog(); if (res != DialogResult.OK) return; string filename = this.openFileDialog1.FileName; try { this.oleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=\"" + filename + "\";Jet OLEDB:Engine Type=5;Provider=\"Microsoft.Jet.OLEDB.4.0\";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"; dataSetWinShooter1 = new DataSetWinShooter(); this.DAClubs.Fill(dataSetWinShooter1, "Clubs"); this.DAShooters.Fill(dataSetWinShooter1, "Shooters"); } catch(Exception exc) { MessageBox.Show(exc.ToString()); return; } foreach(DataSetWinShooter.ClubsRow clubRow in this.dataSetWinShooter1.Clubs) { checkToUpdate(clubRow); } foreach(DataSetWinShooter.ShootersRow shooterRow in this.dataSetWinShooter1.Shooters) { if (int.Parse(shooterRow.Cardnr) > 0) checkToUpdate(shooterRow); } MessageBox.Show("Done!"); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog(); this.tabControl1 = new System.Windows.Forms.TabControl(); this.tabClubs = new System.Windows.Forms.TabPage(); this.dataGridClubs = new System.Windows.Forms.DataGrid(); this.tabWeapons = new System.Windows.Forms.TabPage(); this.dataGridWeapons = new System.Windows.Forms.DataGrid(); this.tabShooters = new System.Windows.Forms.TabPage(); this.dataGridShooters = new System.Windows.Forms.DataGrid(); this.mainMenu1 = new System.Windows.Forms.MainMenu(this.components); this.menuFile = new System.Windows.Forms.MenuItem(); this.menuFileOpen = new System.Windows.Forms.MenuItem(); this.menuFileSave = new System.Windows.Forms.MenuItem(); this.menuFileExit = new System.Windows.Forms.MenuItem(); this.menuItem1 = new System.Windows.Forms.MenuItem(); this.menuImportClubsFromFile = new System.Windows.Forms.MenuItem(); this.menuImportShootersFromFile = new System.Windows.Forms.MenuItem(); this.menuImportInfoFromWinShooter = new System.Windows.Forms.MenuItem(); this.menuImportInfoFromWinShooterCaache = new System.Windows.Forms.MenuItem(); this.menuVrfyBankgiro = new System.Windows.Forms.MenuItem(); this.menuItem2 = new System.Windows.Forms.MenuItem(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.DAShooters = new System.Data.OleDb.OleDbDataAdapter(); this.dataSetWinShooter1 = new ManageEmbeddedResources.DataSetWinShooter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand(); this.DAClubs = new System.Data.OleDb.OleDbDataAdapter(); this.tabControl1.SuspendLayout(); this.tabClubs.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridClubs)).BeginInit(); this.tabWeapons.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridWeapons)).BeginInit(); this.tabShooters.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridShooters)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSetWinShooter1)).BeginInit(); this.SuspendLayout(); // // tabControl1 // this.tabControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.tabControl1.Controls.Add(this.tabClubs); this.tabControl1.Controls.Add(this.tabWeapons); this.tabControl1.Controls.Add(this.tabShooters); this.tabControl1.Location = new System.Drawing.Point(0, 0); this.tabControl1.Name = "tabControl1"; this.tabControl1.SelectedIndex = 0; this.tabControl1.Size = new System.Drawing.Size(552, 328); this.tabControl1.TabIndex = 1; // // tabClubs // this.tabClubs.Controls.Add(this.dataGridClubs); this.tabClubs.Location = new System.Drawing.Point(4, 22); this.tabClubs.Name = "tabClubs"; this.tabClubs.Size = new System.Drawing.Size(544, 302); this.tabClubs.TabIndex = 0; this.tabClubs.Text = "Clubs"; // // dataGridClubs // this.dataGridClubs.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dataGridClubs.DataMember = ""; this.dataGridClubs.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGridClubs.Location = new System.Drawing.Point(0, 0); this.dataGridClubs.Name = "dataGridClubs"; this.dataGridClubs.PreferredColumnWidth = 90; this.dataGridClubs.Size = new System.Drawing.Size(544, 296); this.dataGridClubs.TabIndex = 0; // // tabWeapons // this.tabWeapons.Controls.Add(this.dataGridWeapons); this.tabWeapons.Location = new System.Drawing.Point(4, 22); this.tabWeapons.Name = "tabWeapons"; this.tabWeapons.Size = new System.Drawing.Size(544, 302); this.tabWeapons.TabIndex = 1; this.tabWeapons.Text = "Weapons"; // // dataGridWeapons // this.dataGridWeapons.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dataGridWeapons.DataMember = ""; this.dataGridWeapons.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGridWeapons.Location = new System.Drawing.Point(0, 0); this.dataGridWeapons.Name = "dataGridWeapons"; this.dataGridWeapons.Size = new System.Drawing.Size(544, 296); this.dataGridWeapons.TabIndex = 0; // // tabShooters // this.tabShooters.Controls.Add(this.dataGridShooters); this.tabShooters.Location = new System.Drawing.Point(4, 22); this.tabShooters.Name = "tabShooters"; this.tabShooters.Size = new System.Drawing.Size(544, 302); this.tabShooters.TabIndex = 2; this.tabShooters.Text = "Shooters"; // // dataGridShooters // this.dataGridShooters.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dataGridShooters.DataMember = ""; this.dataGridShooters.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGridShooters.Location = new System.Drawing.Point(0, 0); this.dataGridShooters.Name = "dataGridShooters"; this.dataGridShooters.Size = new System.Drawing.Size(544, 296); this.dataGridShooters.TabIndex = 0; // // mainMenu1 // this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuFile, this.menuItem1, this.menuVrfyBankgiro, this.menuItem2}); // // menuFile // this.menuFile.Index = 0; this.menuFile.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuFileOpen, this.menuFileSave, this.menuFileExit}); this.menuFile.Text = "Arkiv"; // // menuFileOpen // this.menuFileOpen.Index = 0; this.menuFileOpen.Text = "Öppna"; this.menuFileOpen.Click += new System.EventHandler(this.menuFileOpen_Click); // // menuFileSave // this.menuFileSave.Index = 1; this.menuFileSave.Text = "Spara"; this.menuFileSave.Click += new System.EventHandler(this.menuFileSave_Click); // // menuFileExit // this.menuFileExit.Index = 2; this.menuFileExit.Text = "Avsluta"; this.menuFileExit.Click += new System.EventHandler(this.menuFileExit_Click); // // menuItem1 // this.menuItem1.Index = 1; this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuImportClubsFromFile, this.menuImportShootersFromFile, this.menuImportInfoFromWinShooter, this.menuImportInfoFromWinShooterCaache}); this.menuItem1.Text = "Importera"; // // menuImportClubsFromFile // this.menuImportClubsFromFile.Index = 0; this.menuImportClubsFromFile.Text = "Klubbar från fil"; this.menuImportClubsFromFile.Click += new System.EventHandler(this.menuImportClubsFromFile_Click); // // menuImportShootersFromFile // this.menuImportShootersFromFile.Index = 1; this.menuImportShootersFromFile.Text = "Skyttar från fil"; this.menuImportShootersFromFile.Click += new System.EventHandler(this.menuImportShootersFromFile_Click); // // menuImportInfoFromWinShooter // this.menuImportInfoFromWinShooter.Index = 2; this.menuImportInfoFromWinShooter.Text = "Info från WinShooter"; this.menuImportInfoFromWinShooter.Click += new System.EventHandler(this.menuImportInfoFromWinShooter_Click); // // menuImportInfoFromWinShooterCaache // this.menuImportInfoFromWinShooterCaache.Index = 3; this.menuImportInfoFromWinShooterCaache.Text = "Cache från WinShooter"; this.menuImportInfoFromWinShooterCaache.Click += new System.EventHandler(this.menuImportInfoFromWinShooterCaache_Click); // // menuVrfyBankgiro // this.menuVrfyBankgiro.Index = 2; this.menuVrfyBankgiro.Text = "Verifiera PFBG"; this.menuVrfyBankgiro.Click += new System.EventHandler(this.menuVrfyBankgiro_Click); // // menuItem2 // this.menuItem2.Index = 3; this.menuItem2.Text = "Temp"; this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT Arrived, Automatic, Cardnr, Class, ClubId, Email, EmailResult, Givenname, " + "Payed, ShooterId, Surname, ToAutomatic FROM Shooters"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = resources.GetString("oleDbConnection1.ConnectionString"); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = "INSERT INTO Shooters(Arrived, Automatic, Cardnr, Class, ClubId, Email, EmailResul" + "t, Givenname, Payed, Surname, ToAutomatic) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?," + " ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Arrived", System.Data.OleDb.OleDbType.Boolean, 2, "Arrived"), new System.Data.OleDb.OleDbParameter("Automatic", System.Data.OleDb.OleDbType.Boolean, 2, "Automatic"), new System.Data.OleDb.OleDbParameter("Cardnr", System.Data.OleDb.OleDbType.VarWChar, 150, "Cardnr"), new System.Data.OleDb.OleDbParameter("Class", System.Data.OleDb.OleDbType.Integer, 0, "Class"), new System.Data.OleDb.OleDbParameter("ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, "ClubId"), new System.Data.OleDb.OleDbParameter("Email", System.Data.OleDb.OleDbType.VarWChar, 150, "Email"), new System.Data.OleDb.OleDbParameter("EmailResult", System.Data.OleDb.OleDbType.Boolean, 2, "EmailResult"), new System.Data.OleDb.OleDbParameter("Givenname", System.Data.OleDb.OleDbType.VarWChar, 150, "Givenname"), new System.Data.OleDb.OleDbParameter("Payed", System.Data.OleDb.OleDbType.Integer, 0, "Payed"), new System.Data.OleDb.OleDbParameter("Surname", System.Data.OleDb.OleDbType.VarWChar, 150, "Surname"), new System.Data.OleDb.OleDbParameter("ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, "ToAutomatic")}); // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = resources.GetString("oleDbUpdateCommand1.CommandText"); this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Arrived", System.Data.OleDb.OleDbType.Boolean, 2, "Arrived"), new System.Data.OleDb.OleDbParameter("Automatic", System.Data.OleDb.OleDbType.Boolean, 2, "Automatic"), new System.Data.OleDb.OleDbParameter("Cardnr", System.Data.OleDb.OleDbType.VarWChar, 150, "Cardnr"), new System.Data.OleDb.OleDbParameter("Class", System.Data.OleDb.OleDbType.Integer, 0, "Class"), new System.Data.OleDb.OleDbParameter("ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, "ClubId"), new System.Data.OleDb.OleDbParameter("Email", System.Data.OleDb.OleDbType.VarWChar, 150, "Email"), new System.Data.OleDb.OleDbParameter("EmailResult", System.Data.OleDb.OleDbType.Boolean, 2, "EmailResult"), new System.Data.OleDb.OleDbParameter("Givenname", System.Data.OleDb.OleDbType.VarWChar, 150, "Givenname"), new System.Data.OleDb.OleDbParameter("Payed", System.Data.OleDb.OleDbType.Integer, 0, "Payed"), new System.Data.OleDb.OleDbParameter("Surname", System.Data.OleDb.OleDbType.VarWChar, 150, "Surname"), new System.Data.OleDb.OleDbParameter("ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, "ToAutomatic"), new System.Data.OleDb.OleDbParameter("Original_ShooterId", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShooterId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Arrived", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Arrived", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Automatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Automatic", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Cardnr", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Cardnr", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Cardnr1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Cardnr", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Class", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Class", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Class1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Class", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ClubId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ClubId1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ClubId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_EmailResult", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "EmailResult", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Givenname", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Givenname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Givenname1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Givenname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Payed", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Payed", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Payed1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Payed", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Surname", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Surname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Surname1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Surname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ToAutomatic", System.Data.DataRowVersion.Original, null)}); // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = resources.GetString("oleDbDeleteCommand1.CommandText"); this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Original_ShooterId", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShooterId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Arrived", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Arrived", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Automatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Automatic", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Cardnr", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Cardnr", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Cardnr1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Cardnr", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Class", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Class", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Class1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Class", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ClubId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ClubId1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ClubId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_EmailResult", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "EmailResult", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Givenname", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Givenname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Givenname1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Givenname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Payed", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Payed", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Payed1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Payed", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Surname", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Surname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Surname1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Surname", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ToAutomatic", System.Data.DataRowVersion.Original, null)}); // // DAShooters // this.DAShooters.DeleteCommand = this.oleDbDeleteCommand1; this.DAShooters.InsertCommand = this.oleDbInsertCommand1; this.DAShooters.SelectCommand = this.oleDbSelectCommand1; this.DAShooters.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Shooters", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Arrived", "Arrived"), new System.Data.Common.DataColumnMapping("Automatic", "Automatic"), new System.Data.Common.DataColumnMapping("Cardnr", "Cardnr"), new System.Data.Common.DataColumnMapping("Class", "Class"), new System.Data.Common.DataColumnMapping("ClubId", "ClubId"), new System.Data.Common.DataColumnMapping("Email", "Email"), new System.Data.Common.DataColumnMapping("EmailResult", "EmailResult"), new System.Data.Common.DataColumnMapping("Givenname", "Givenname"), new System.Data.Common.DataColumnMapping("Payed", "Payed"), new System.Data.Common.DataColumnMapping("ShooterId", "ShooterId"), new System.Data.Common.DataColumnMapping("Surname", "Surname"), new System.Data.Common.DataColumnMapping("ToAutomatic", "ToAutomatic")})}); this.DAShooters.UpdateCommand = this.oleDbUpdateCommand1; // // dataSetWinShooter1 // this.dataSetWinShooter1.DataSetName = "DataSetWinShooter"; this.dataSetWinShooter1.Locale = new System.Globalization.CultureInfo("sv-SE"); this.dataSetWinShooter1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT Automatic, Bankgiro, ClubId, Country, Email, Name, Plusgiro, ToAutomatic F" + "ROM Clubs"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbInsertCommand2 // this.oleDbInsertCommand2.CommandText = "INSERT INTO Clubs(Automatic, Bankgiro, ClubId, Country, Email, Name, Plusgiro, To" + "Automatic) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; this.oleDbInsertCommand2.Connection = this.oleDbConnection1; this.oleDbInsertCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Automatic", System.Data.OleDb.OleDbType.Boolean, 2, "Automatic"), new System.Data.OleDb.OleDbParameter("Bankgiro", System.Data.OleDb.OleDbType.VarWChar, 150, "Bankgiro"), new System.Data.OleDb.OleDbParameter("ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, "ClubId"), new System.Data.OleDb.OleDbParameter("Country", System.Data.OleDb.OleDbType.VarWChar, 150, "Country"), new System.Data.OleDb.OleDbParameter("Email", System.Data.OleDb.OleDbType.VarWChar, 150, "Email"), new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 150, "Name"), new System.Data.OleDb.OleDbParameter("Plusgiro", System.Data.OleDb.OleDbType.VarWChar, 150, "Plusgiro"), new System.Data.OleDb.OleDbParameter("ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, "ToAutomatic")}); // // oleDbUpdateCommand2 // this.oleDbUpdateCommand2.CommandText = resources.GetString("oleDbUpdateCommand2.CommandText"); this.oleDbUpdateCommand2.Connection = this.oleDbConnection1; this.oleDbUpdateCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Automatic", System.Data.OleDb.OleDbType.Boolean, 2, "Automatic"), new System.Data.OleDb.OleDbParameter("Bankgiro", System.Data.OleDb.OleDbType.VarWChar, 150, "Bankgiro"), new System.Data.OleDb.OleDbParameter("ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, "ClubId"), new System.Data.OleDb.OleDbParameter("Country", System.Data.OleDb.OleDbType.VarWChar, 150, "Country"), new System.Data.OleDb.OleDbParameter("Email", System.Data.OleDb.OleDbType.VarWChar, 150, "Email"), new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 150, "Name"), new System.Data.OleDb.OleDbParameter("Plusgiro", System.Data.OleDb.OleDbType.VarWChar, 150, "Plusgiro"), new System.Data.OleDb.OleDbParameter("ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, "ToAutomatic"), new System.Data.OleDb.OleDbParameter("Original_ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ClubId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Automatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Automatic", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Bankgiro", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Bankgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Bankgiro1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Bankgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Country", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Country", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Country1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Country", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Name", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Name1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Plusgiro", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Plusgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Plusgiro1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Plusgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ToAutomatic", System.Data.DataRowVersion.Original, null)}); // // oleDbDeleteCommand2 // this.oleDbDeleteCommand2.CommandText = resources.GetString("oleDbDeleteCommand2.CommandText"); this.oleDbDeleteCommand2.Connection = this.oleDbConnection1; this.oleDbDeleteCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Original_ClubId", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ClubId", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Automatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Automatic", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Bankgiro", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Bankgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Bankgiro1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Bankgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Country", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Country", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Country1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Country", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Email1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Email", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Name", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Name1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Name", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Plusgiro", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Plusgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Plusgiro1", System.Data.OleDb.OleDbType.VarWChar, 150, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Plusgiro", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ToAutomatic", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ToAutomatic", System.Data.DataRowVersion.Original, null)}); // // DAClubs // this.DAClubs.DeleteCommand = this.oleDbDeleteCommand2; this.DAClubs.InsertCommand = this.oleDbInsertCommand2; this.DAClubs.SelectCommand = this.oleDbSelectCommand2; this.DAClubs.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Clubs", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Automatic", "Automatic"), new System.Data.Common.DataColumnMapping("Bankgiro", "Bankgiro"), new System.Data.Common.DataColumnMapping("ClubId", "ClubId"), new System.Data.Common.DataColumnMapping("Country", "Country"), new System.Data.Common.DataColumnMapping("Email", "Email"), new System.Data.Common.DataColumnMapping("Name", "Name"), new System.Data.Common.DataColumnMapping("Plusgiro", "Plusgiro"), new System.Data.Common.DataColumnMapping("ToAutomatic", "ToAutomatic")})}); this.DAClubs.UpdateCommand = this.oleDbUpdateCommand2; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(552, 326); this.Controls.Add(this.tabControl1); this.Menu = this.mainMenu1; this.Name = "Form1"; this.Text = "Manage Embedded Resources"; this.tabControl1.ResumeLayout(false); this.tabClubs.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridClubs)).EndInit(); this.tabWeapons.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridWeapons)).EndInit(); this.tabShooters.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridShooters)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSetWinShooter1)).EndInit(); this.ResumeLayout(false); }