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);
}
