/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.companyList = new System.Windows.Forms.ListBox();
this.emDataSet = new EM.EMDataSet();
this.m_locationList = new System.Windows.Forms.ListBox();
this.nameEdit = new System.Windows.Forms.TextBox();
this.addressEdit = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.countryCombo = new System.Windows.Forms.ComboBox();
this.attnEdt = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.ccEdt = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).BeginInit();
this.SuspendLayout();
//
// companyList
//
this.companyList.Location = new System.Drawing.Point(8, 32);
this.companyList.Name = "companyList";
this.companyList.Size = new System.Drawing.Size(200, 160);
this.companyList.TabIndex = 2;
this.companyList.SelectedIndexChanged += new System.EventHandler(this.OnCompanySelectedIndexChanged);
//
// emDataSet
//
this.emDataSet.DataSetName = "EMDataSet";
this.emDataSet.Locale = new System.Globalization.CultureInfo("en-US");
this.emDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// m_locationList
//
this.m_locationList.Location = new System.Drawing.Point(424, 32);
this.m_locationList.Name = "m_locationList";
this.m_locationList.Size = new System.Drawing.Size(168, 160);
this.m_locationList.TabIndex = 3;
this.m_locationList.SelectedIndexChanged += new System.EventHandler(this.OnLocationSelectedChanged);
//
// nameEdit
//
this.nameEdit.Location = new System.Drawing.Point(200, 200);
this.nameEdit.Name = "nameEdit";
this.nameEdit.Size = new System.Drawing.Size(368, 20);
this.nameEdit.TabIndex = 5;
//
// addressEdit
//
this.addressEdit.Location = new System.Drawing.Point(200, 240);
this.addressEdit.Multiline = true;
this.addressEdit.Name = "addressEdit";
this.addressEdit.Size = new System.Drawing.Size(376, 88);
this.addressEdit.TabIndex = 7;
//
// label1
//
this.label1.Location = new System.Drawing.Point(432, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(56, 23);
this.label1.TabIndex = 1;
this.label1.Text = "Locations:";
//
// label2
//
this.label2.Location = new System.Drawing.Point(8, 8);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(88, 23);
this.label2.TabIndex = 0;
this.label2.Text = "Companies:";
//
// label3
//
this.label3.Location = new System.Drawing.Point(8, 200);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(100, 23);
this.label3.TabIndex = 4;
this.label3.Text = "Location Name:";
//
// label4
//
this.label4.Location = new System.Drawing.Point(8, 240);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(100, 23);
this.label4.TabIndex = 6;
this.label4.Text = "Address:";
//
// label8
//
this.label8.Location = new System.Drawing.Point(8, 336);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(100, 23);
this.label8.TabIndex = 8;
this.label8.Text = "Country:";
//
// countryCombo
//
this.countryCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.countryCombo.Location = new System.Drawing.Point(200, 336);
this.countryCombo.Name = "countryCombo";
this.countryCombo.Size = new System.Drawing.Size(376, 21);
this.countryCombo.TabIndex = 9;
//
// attnEdt
//
this.attnEdt.Location = new System.Drawing.Point(200, 384);
this.attnEdt.Multiline = true;
this.attnEdt.Name = "attnEdt";
this.attnEdt.Size = new System.Drawing.Size(376, 88);
this.attnEdt.TabIndex = 10;
//
// label5
//
this.label5.Location = new System.Drawing.Point(8, 392);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(100, 23);
this.label5.TabIndex = 11;
this.label5.Text = "Attn:";
//
// ccEdt
//
this.ccEdt.Location = new System.Drawing.Point(200, 480);
this.ccEdt.Multiline = true;
this.ccEdt.Name = "ccEdt";
this.ccEdt.Size = new System.Drawing.Size(376, 88);
this.ccEdt.TabIndex = 12;
//
// label6
//
this.label6.Location = new System.Drawing.Point(8, 488);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(100, 23);
this.label6.TabIndex = 13;
this.label6.Text = "CC";
//
// LocationForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(600, 583);
this.Controls.Add(this.label6);
this.Controls.Add(this.ccEdt);
this.Controls.Add(this.label5);
this.Controls.Add(this.attnEdt);
this.Controls.Add(this.countryCombo);
this.Controls.Add(this.label8);
this.Controls.Add(this.addressEdit);
this.Controls.Add(this.nameEdit);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.m_locationList);
this.Controls.Add(this.companyList);
this.Name = "LocationForm";
this.Text = "LocationForm";
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.m_itemEdt = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.m_descriptionEdt = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.m_companyCombo = new System.Windows.Forms.ComboBox();
this.m_emDataSet = new EM.EMDataSet();
this.label4 = new System.Windows.Forms.Label();
this.m_itemList = new System.Windows.Forms.ListBox();
((System.ComponentModel.ISupportInitialize)(this.m_emDataSet)).BeginInit();
this.SuspendLayout();
//
// m_itemEdt
//
this.m_itemEdt.Location = new System.Drawing.Point(392, 8);
this.m_itemEdt.Name = "m_itemEdt";
this.m_itemEdt.Size = new System.Drawing.Size(216, 20);
this.m_itemEdt.TabIndex = 5;
this.m_itemEdt.Text = "textBox1";
//
// label1
//
this.label1.Location = new System.Drawing.Point(320, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(64, 16);
this.label1.TabIndex = 4;
this.label1.Text = "Item Name:";
//
// m_descriptionEdt
//
this.m_descriptionEdt.Location = new System.Drawing.Point(328, 56);
this.m_descriptionEdt.Multiline = true;
this.m_descriptionEdt.Name = "m_descriptionEdt";
this.m_descriptionEdt.ScrollBars = System.Windows.Forms.ScrollBars.Vertical;
this.m_descriptionEdt.Size = new System.Drawing.Size(280, 96);
this.m_descriptionEdt.TabIndex = 7;
this.m_descriptionEdt.Text = "textBox2";
//
// label2
//
this.label2.Location = new System.Drawing.Point(320, 40);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(100, 16);
this.label2.TabIndex = 6;
this.label2.Text = "Description:";
//
// label3
//
this.label3.Location = new System.Drawing.Point(8, 16);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(64, 16);
this.label3.TabIndex = 0;
this.label3.Text = "Company:";
//
// m_companyCombo
//
this.m_companyCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.m_companyCombo.Location = new System.Drawing.Point(80, 8);
this.m_companyCombo.Name = "m_companyCombo";
this.m_companyCombo.Size = new System.Drawing.Size(216, 21);
this.m_companyCombo.TabIndex = 1;
this.m_companyCombo.SelectedIndexChanged += new System.EventHandler(this.OnCompanyChanged);
//
// m_emDataSet
//
this.m_emDataSet.DataSetName = "EMDataSet";
this.m_emDataSet.Locale = new System.Globalization.CultureInfo("en-US");
this.m_emDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label4
//
this.label4.Location = new System.Drawing.Point(8, 40);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(64, 16);
this.label4.TabIndex = 2;
this.label4.Text = "Items:";
//
// m_itemList
//
this.m_itemList.Location = new System.Drawing.Point(80, 32);
this.m_itemList.Name = "m_itemList";
this.m_itemList.Size = new System.Drawing.Size(216, 407);
this.m_itemList.TabIndex = 3;
this.m_itemList.SelectedIndexChanged += new System.EventHandler(this.OnItemSelectedChanged);
//
// ItemForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(664, 453);
this.Controls.Add(this.m_itemList);
this.Controls.Add(this.label4);
this.Controls.Add(this.m_companyCombo);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.m_descriptionEdt);
this.Controls.Add(this.m_itemEdt);
this.Controls.Add(this.label1);
this.Name = "ItemForm";
this.Text = "Item";
((System.ComponentModel.ISupportInitialize)(this.m_emDataSet)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.m_itemList = new System.Windows.Forms.ListBox();
this.emDataSet = new EM.EMDataSet();
this.OKbtn = new System.Windows.Forms.Button();
this.cancelBtn = new System.Windows.Forms.Button();
this.countBox = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.finishCombo = new System.Windows.Forms.ComboBox();
this.treatmentCombo = new System.Windows.Forms.ComboBox();
this.bottomPanel = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).BeginInit();
this.bottomPanel.SuspendLayout();
this.SuspendLayout();
//
// m_itemList
//
this.m_itemList.Dock = System.Windows.Forms.DockStyle.Fill;
this.m_itemList.Location = new System.Drawing.Point(0, 24);
this.m_itemList.Name = "m_itemList";
this.m_itemList.Size = new System.Drawing.Size(448, 485);
this.m_itemList.TabIndex = 0;
this.m_itemList.DoubleClick += new System.EventHandler(this.OnChooseItemDblClick);
//
// emDataSet
//
this.emDataSet.DataSetName = "EMDataSet";
this.emDataSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// OKbtn
//
this.OKbtn.DialogResult = System.Windows.Forms.DialogResult.OK;
this.OKbtn.Location = new System.Drawing.Point(328, 48);
this.OKbtn.Name = "OKbtn";
this.OKbtn.Size = new System.Drawing.Size(56, 24);
this.OKbtn.TabIndex = 4;
this.OKbtn.Text = "OK";
//
// cancelBtn
//
this.cancelBtn.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.cancelBtn.Location = new System.Drawing.Point(248, 48);
this.cancelBtn.Name = "cancelBtn";
this.cancelBtn.Size = new System.Drawing.Size(72, 23);
this.cancelBtn.TabIndex = 3;
this.cancelBtn.Text = "Cancel";
//
// countBox
//
this.countBox.Location = new System.Drawing.Point(56, 16);
this.countBox.Name = "countBox";
this.countBox.Size = new System.Drawing.Size(32, 20);
this.countBox.TabIndex = 2;
this.countBox.Text = "1";
//
// label1
//
this.label1.Location = new System.Drawing.Point(16, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(40, 16);
this.label1.TabIndex = 1;
this.label1.Text = "Count";
//
// label2
//
this.label2.Location = new System.Drawing.Point(96, 16);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(40, 23);
this.label2.TabIndex = 5;
this.label2.Text = "Finish:";
//
// label3
//
this.label3.Location = new System.Drawing.Point(224, 16);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(64, 23);
this.label3.TabIndex = 6;
this.label3.Text = "Treatment:";
//
// label4
//
this.label4.Dock = System.Windows.Forms.DockStyle.Top;
this.label4.Location = new System.Drawing.Point(0, 0);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(448, 24);
this.label4.TabIndex = 7;
this.label4.Text = "Grades:";
//
// finishCombo
//
this.finishCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.finishCombo.Location = new System.Drawing.Point(136, 16);
this.finishCombo.Name = "finishCombo";
this.finishCombo.Size = new System.Drawing.Size(80, 21);
this.finishCombo.TabIndex = 8;
//
// treatmentCombo
//
this.treatmentCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.treatmentCombo.Location = new System.Drawing.Point(296, 16);
this.treatmentCombo.Name = "treatmentCombo";
this.treatmentCombo.Size = new System.Drawing.Size(88, 21);
this.treatmentCombo.TabIndex = 9;
//
// bottomPanel
//
this.bottomPanel.Controls.Add(this.OKbtn);
this.bottomPanel.Controls.Add(this.cancelBtn);
this.bottomPanel.Controls.Add(this.countBox);
this.bottomPanel.Controls.Add(this.label1);
this.bottomPanel.Controls.Add(this.label2);
this.bottomPanel.Controls.Add(this.label3);
this.bottomPanel.Controls.Add(this.finishCombo);
this.bottomPanel.Controls.Add(this.treatmentCombo);
this.bottomPanel.Dock = System.Windows.Forms.DockStyle.Bottom;
this.bottomPanel.Location = new System.Drawing.Point(0, 429);
this.bottomPanel.Name = "bottomPanel";
this.bottomPanel.Size = new System.Drawing.Size(448, 88);
this.bottomPanel.TabIndex = 10;
//
// ChooseItem
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(448, 517);
this.Controls.Add(this.bottomPanel);
this.Controls.Add(this.m_itemList);
this.Controls.Add(this.label4);
this.Name = "ChooseItem";
this.Text = "ChooseItem";
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).EndInit();
this.bottomPanel.ResumeLayout(false);
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.poHeaderAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.emConnection = new System.Data.OleDb.OleDbConnection();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
this.poItemAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand();
this.emDataSet1 = new EM.EMDataSet();
((System.ComponentModel.ISupportInitialize)(this.emDataSet1)).BeginInit();
//
// poHeaderAdapter
//
this.poHeaderAdapter.DeleteCommand = this.oleDbDeleteCommand1;
this.poHeaderAdapter.InsertCommand = this.oleDbInsertCommand1;
this.poHeaderAdapter.SelectCommand = this.oleDbSelectCommand1;
this.poHeaderAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblPOHeader2", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("POID", "POID"),
new System.Data.Common.DataColumnMapping("PONumber", "PONumber")})});
this.poHeaderAdapter.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM tblPOHeader2 WHERE (POID = ?)";
this.oleDbDeleteCommand1.Connection = this.emConnection;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_POID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "POID", System.Data.DataRowVersion.Original, null));
//
// emConnection
//
this.emConnection.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""m:\em_prog_2002.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:New Database Password=;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:Encrypt Database=False";
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO tblPOHeader2(POID, PONumber) VALUES (?, ?)";
this.oleDbInsertCommand1.Connection = this.emConnection;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("POID", System.Data.OleDb.OleDbType.Integer, 0, "POID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("PONumber", System.Data.OleDb.OleDbType.VarWChar, 20, "PONumber"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT POID, PONumber FROM tblPOHeader2";
this.oleDbSelectCommand1.Connection = this.emConnection;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE tblPOHeader2 SET POID = ?, PONumber = ? WHERE (POID = ?)";
this.oleDbUpdateCommand1.Connection = this.emConnection;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("POID", System.Data.OleDb.OleDbType.Integer, 0, "POID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("PONumber", System.Data.OleDb.OleDbType.VarWChar, 20, "PONumber"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_POID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "POID", System.Data.DataRowVersion.Original, null));
//
// poItemAdapter
//
this.poItemAdapter.DeleteCommand = this.oleDbDeleteCommand2;
this.poItemAdapter.InsertCommand = this.oleDbInsertCommand2;
this.poItemAdapter.SelectCommand = this.oleDbSelectCommand2;
this.poItemAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblPOItem2", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("POItemNumber", "POItemNumber"),
new System.Data.Common.DataColumnMapping("POID", "POID"),
new System.Data.Common.DataColumnMapping("ItemName", "ItemName"),
new System.Data.Common.DataColumnMapping("SeqNumber", "SeqNumber")})});
this.poItemAdapter.UpdateCommand = this.oleDbUpdateCommand2;
//
// oleDbDeleteCommand2
//
this.oleDbDeleteCommand2.CommandText = "DELETE FROM tblPOItem2 WHERE (POItemNumber = ?)";
this.oleDbDeleteCommand2.Connection = this.emConnection;
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_POItemNumber", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "POItemNumber", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO tblPOItem2(POItemNumber, POID, ItemName, SeqNumber) VALUES (?, ?, ?, " +
"?)";
this.oleDbInsertCommand2.Connection = this.emConnection;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("POItemNumber", System.Data.OleDb.OleDbType.Integer, 0, "POItemNumber"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("POID", System.Data.OleDb.OleDbType.Integer, 0, "POID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ItemName", System.Data.OleDb.OleDbType.VarWChar, 30, "ItemName"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SeqNumber", System.Data.OleDb.OleDbType.SmallInt, 0, "SeqNumber"));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT POItemNumber, POID, ItemName, SeqNumber FROM tblPOItem2";
this.oleDbSelectCommand2.Connection = this.emConnection;
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = "UPDATE tblPOItem2 SET POItemNumber = ?, POID = ?, ItemName = ?, SeqNumber = ? WHE" +
"RE (POItemNumber = ?)";
this.oleDbUpdateCommand2.Connection = this.emConnection;
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("POItemNumber", System.Data.OleDb.OleDbType.Integer, 0, "POItemNumber"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("POID", System.Data.OleDb.OleDbType.Integer, 0, "POID"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ItemName", System.Data.OleDb.OleDbType.VarWChar, 30, "ItemName"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SeqNumber", System.Data.OleDb.OleDbType.SmallInt, 0, "SeqNumber"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_POItemNumber", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "POItemNumber", System.Data.DataRowVersion.Original, null));
//
// emDataSet1
//
this.emDataSet1.DataSetName = "EMDataSet";
this.emDataSet1.Locale = new System.Globalization.CultureInfo("en-US");
//
// DummyForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(292, 266);
this.Name = "DummyForm";
this.Text = "DummyForm";
((System.ComponentModel.ISupportInitialize)(this.emDataSet1)).EndInit();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.countryEdt = new System.Windows.Forms.TextBox();
this.recordIdEdt = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.emConnection = new System.Data.OleDb.OleDbConnection();
this.countryAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
this.emDataSet = new EM.EMDataSet();
this.locationAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).BeginInit();
this.SuspendLayout();
//
// countryEdt
//
this.countryEdt.Location = new System.Drawing.Point(96, 72);
this.countryEdt.Name = "countryEdt";
this.countryEdt.Size = new System.Drawing.Size(176, 20);
this.countryEdt.TabIndex = 3;
this.countryEdt.Text = "textBox1";
//
// recordIdEdt
//
this.recordIdEdt.Location = new System.Drawing.Point(96, 32);
this.recordIdEdt.Name = "recordIdEdt";
this.recordIdEdt.ReadOnly = true;
this.recordIdEdt.TabIndex = 1;
this.recordIdEdt.Text = "textBox2";
//
// label1
//
this.label1.Location = new System.Drawing.Point(16, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(64, 23);
this.label1.TabIndex = 0;
this.label1.Text = "Record ID:";
//
// label2
//
this.label2.Location = new System.Drawing.Point(8, 72);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(80, 16);
this.label2.TabIndex = 2;
this.label2.Text = "Country Name:";
//
// emConnection
//
this.emConnection.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""m:\em_prog_2002.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=ReadWrite;Jet OLEDB:New Database Password=;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:Encrypt Database=False";
//
// countryAdapter
//
this.countryAdapter.DeleteCommand = this.oleDbDeleteCommand1;
this.countryAdapter.InsertCommand = this.oleDbInsertCommand1;
this.countryAdapter.SelectCommand = this.oleDbSelectCommand1;
this.countryAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblCountry", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("CountryName", "CountryName")})});
this.countryAdapter.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM tblCountry WHERE (CountryID = ?) AND (CountryName = ?)";
this.oleDbDeleteCommand1.Connection = this.emConnection;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CountryID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CountryID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CountryName", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CountryName", System.Data.DataRowVersion.Original, null));
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO tblCountry(CountryID, CountryName) VALUES (?, ?)";
this.oleDbInsertCommand1.Connection = this.emConnection;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CountryID", System.Data.OleDb.OleDbType.Integer, 0, "CountryID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CountryName", System.Data.OleDb.OleDbType.VarWChar, 30, "CountryName"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT CountryID, CountryName FROM tblCountry ORDER BY CountryName";
this.oleDbSelectCommand1.Connection = this.emConnection;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE tblCountry SET CountryID = ?, CountryName = ? WHERE (CountryID = ?) AND (C" +
"ountryName = ?)";
this.oleDbUpdateCommand1.Connection = this.emConnection;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CountryID", System.Data.OleDb.OleDbType.Integer, 0, "CountryID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CountryName", System.Data.OleDb.OleDbType.VarWChar, 30, "CountryName"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CountryID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CountryID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CountryName", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CountryName", System.Data.DataRowVersion.Original, null));
//
// emDataSet
//
this.emDataSet.DataSetName = "EMDataSet";
this.emDataSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// locationAdapter
//
this.locationAdapter.SelectCommand = this.oleDbSelectCommand2;
this.locationAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblLocation2", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Address", "Address"),
new System.Data.Common.DataColumnMapping("CompID", "CompID"),
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("LocID", "LocID"),
new System.Data.Common.DataColumnMapping("LocName", "LocName")})});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT Address, CompID, CountryID, LocID, LocName FROM tblLocation2 WHERE (Countr" +
"yID = ?)";
this.oleDbSelectCommand2.Connection = this.emConnection;
this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CountryID", System.Data.OleDb.OleDbType.Integer, 0, "CountryID"));
//
// CountryForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(292, 109);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.recordIdEdt);
this.Controls.Add(this.countryEdt);
this.Name = "CountryForm";
this.Text = "CountryForm";
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.companyCombo = new System.Windows.Forms.ComboBox();
this.label1 = new System.Windows.Forms.Label();
this.contactList = new System.Windows.Forms.ListBox();
this.firstNameEdt = new System.Windows.Forms.TextBox();
this.lastNameEdt = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.phoneEdt = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.faxEdt = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.emailEdt = new System.Windows.Forms.TextBox();
this.emDataSet = new EM.EMDataSet();
this.companyAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.emConnection = new System.Data.OleDb.OleDbConnection();
this.contactsAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = 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.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).BeginInit();
this.SuspendLayout();
//
// companyCombo
//
this.companyCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.companyCombo.Location = new System.Drawing.Point(72, 8);
this.companyCombo.Name = "companyCombo";
this.companyCombo.Size = new System.Drawing.Size(168, 21);
this.companyCombo.TabIndex = 0;
this.companyCombo.SelectedIndexChanged += new System.EventHandler(this.OnCompanyChanged);
//
// label1
//
this.label1.Location = new System.Drawing.Point(8, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(56, 24);
this.label1.TabIndex = 1;
this.label1.Text = "Company:";
//
// contactList
//
this.contactList.Location = new System.Drawing.Point(8, 40);
this.contactList.Name = "contactList";
this.contactList.Size = new System.Drawing.Size(264, 498);
this.contactList.TabIndex = 2;
this.contactList.SelectedIndexChanged += new System.EventHandler(this.OnContactChanged);
//
// firstNameEdt
//
this.firstNameEdt.Location = new System.Drawing.Point(328, 64);
this.firstNameEdt.Name = "firstNameEdt";
this.firstNameEdt.Size = new System.Drawing.Size(160, 20);
this.firstNameEdt.TabIndex = 3;
this.firstNameEdt.Text = "textBox1";
//
// lastNameEdt
//
this.lastNameEdt.Location = new System.Drawing.Point(496, 64);
this.lastNameEdt.Name = "lastNameEdt";
this.lastNameEdt.Size = new System.Drawing.Size(176, 20);
this.lastNameEdt.TabIndex = 4;
this.lastNameEdt.Text = "textBox2";
//
// label2
//
this.label2.Location = new System.Drawing.Point(280, 64);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(48, 23);
this.label2.TabIndex = 5;
this.label2.Text = "Name:";
//
// label3
//
this.label3.Location = new System.Drawing.Point(280, 88);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(48, 23);
this.label3.TabIndex = 6;
this.label3.Text = "Phone:";
//
// phoneEdt
//
this.phoneEdt.Location = new System.Drawing.Point(328, 88);
this.phoneEdt.Name = "phoneEdt";
this.phoneEdt.Size = new System.Drawing.Size(216, 20);
this.phoneEdt.TabIndex = 7;
this.phoneEdt.Text = "textBox3";
//
// label4
//
this.label4.Location = new System.Drawing.Point(280, 112);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(48, 23);
this.label4.TabIndex = 8;
this.label4.Text = "Fax:";
//
// faxEdt
//
this.faxEdt.Location = new System.Drawing.Point(328, 112);
this.faxEdt.Name = "faxEdt";
this.faxEdt.Size = new System.Drawing.Size(216, 20);
this.faxEdt.TabIndex = 9;
this.faxEdt.Text = "textBox4";
//
// label5
//
this.label5.Location = new System.Drawing.Point(280, 136);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(48, 23);
this.label5.TabIndex = 10;
this.label5.Text = "EMail:";
//
// emailEdt
//
this.emailEdt.Location = new System.Drawing.Point(328, 136);
this.emailEdt.Name = "emailEdt";
this.emailEdt.Size = new System.Drawing.Size(216, 20);
this.emailEdt.TabIndex = 11;
this.emailEdt.Text = "textBox5";
//
// emDataSet
//
this.emDataSet.DataSetName = "EMDataSet";
this.emDataSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// companyAdapter
//
this.companyAdapter.DeleteCommand = this.oleDbDeleteCommand2;
this.companyAdapter.InsertCommand = this.oleDbInsertCommand2;
this.companyAdapter.SelectCommand = this.oleDbSelectCommand1;
this.companyAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblCompany", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CompID", "CompID"),
new System.Data.Common.DataColumnMapping("CompName", "CompName"),
new System.Data.Common.DataColumnMapping("CompType", "CompType")})});
this.companyAdapter.UpdateCommand = this.oleDbUpdateCommand2;
//
// emConnection
//
this.emConnection.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""m:\\EM_Prog_2002.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;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:Encrypt Database=False";
//
// contactsAdapter
//
this.contactsAdapter.DeleteCommand = this.oleDbDeleteCommand1;
this.contactsAdapter.InsertCommand = this.oleDbInsertCommand1;
this.contactsAdapter.SelectCommand = this.oleDbSelectCommand2;
this.contactsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "tblContacts", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CompID", "CompID"),
new System.Data.Common.DataColumnMapping("ContactID", "ContactID"),
new System.Data.Common.DataColumnMapping("EMail", "EMail"),
new System.Data.Common.DataColumnMapping("Fax", "Fax"),
new System.Data.Common.DataColumnMapping("FirstName", "FirstName"),
new System.Data.Common.DataColumnMapping("LastName", "LastName"),
new System.Data.Common.DataColumnMapping("Phone", "Phone")})});
this.contactsAdapter.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT CompID, CompName, CompType FROM tblCompany ORDER BY CompName";
this.oleDbSelectCommand1.Connection = this.emConnection;
//
// oleDbInsertCommand2
//
this.oleDbInsertCommand2.CommandText = "INSERT INTO tblCompany(CompID, CompName, CompType) VALUES (?, ?, ?)";
this.oleDbInsertCommand2.Connection = this.emConnection;
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompID", System.Data.OleDb.OleDbType.Integer, 0, "CompID"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompName", System.Data.OleDb.OleDbType.VarWChar, 50, "CompName"));
this.oleDbInsertCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompType", System.Data.OleDb.OleDbType.VarWChar, 15, "CompType"));
//
// oleDbUpdateCommand2
//
this.oleDbUpdateCommand2.CommandText = "UPDATE tblCompany SET CompID = ?, CompName = ?, CompType = ? WHERE (CompID = ?) A" +
"ND (CompName = ? OR ? IS NULL AND CompName IS NULL) AND (CompType = ? OR ? IS NU" +
"LL AND CompType IS NULL)";
this.oleDbUpdateCommand2.Connection = this.emConnection;
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompID", System.Data.OleDb.OleDbType.Integer, 0, "CompID"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompName", System.Data.OleDb.OleDbType.VarWChar, 50, "CompName"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompType", System.Data.OleDb.OleDbType.VarWChar, 15, "CompType"));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompType", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompType", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompType1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompType", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand2
//
this.oleDbDeleteCommand2.CommandText = "DELETE FROM tblCompany WHERE (CompID = ?) AND (CompName = ? OR ? IS NULL AND Comp" +
"Name IS NULL) AND (CompType = ? OR ? IS NULL AND CompType IS NULL)";
this.oleDbDeleteCommand2.Connection = this.emConnection;
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompName1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompType", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompType1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompType", System.Data.DataRowVersion.Original, null));
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT CompID, ContactID, EMail, Fax, FirstName, LastName, Phone FROM tblContacts" +
" WHERE (CompID = ?) ORDER BY LastName, FirstName";
this.oleDbSelectCommand2.Connection = this.emConnection;
this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompID", System.Data.OleDb.OleDbType.Integer, 0, "CompID"));
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = "INSERT INTO tblContacts(CompID, ContactID, EMail, Fax, FirstName, LastName, Phone" +
") VALUES (?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.emConnection;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompID", System.Data.OleDb.OleDbType.Integer, 0, "CompID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ContactID", System.Data.OleDb.OleDbType.Integer, 0, "ContactID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("EMail", System.Data.OleDb.OleDbType.VarWChar, 50, "EMail"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Fax", System.Data.OleDb.OleDbType.VarWChar, 50, "Fax"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FirstName", System.Data.OleDb.OleDbType.VarWChar, 50, "FirstName"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("LastName", System.Data.OleDb.OleDbType.VarWChar, 50, "LastName"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Phone", System.Data.OleDb.OleDbType.VarWChar, 50, "Phone"));
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = "UPDATE tblContacts SET CompID = ?, ContactID = ?, EMail = ?, Fax = ?, FirstName =" +
" ?, LastName = ?, Phone = ? WHERE (ContactID = ?) AND (CompID = ?) AND (EMail = " +
"?) AND (Fax = ?) AND (FirstName = ?) AND (LastName = ?) AND (Phone = ?)";
this.oleDbUpdateCommand1.Connection = this.emConnection;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("CompID", System.Data.OleDb.OleDbType.Integer, 0, "CompID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ContactID", System.Data.OleDb.OleDbType.Integer, 0, "ContactID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("EMail", System.Data.OleDb.OleDbType.VarWChar, 50, "EMail"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Fax", System.Data.OleDb.OleDbType.VarWChar, 50, "Fax"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("FirstName", System.Data.OleDb.OleDbType.VarWChar, 50, "FirstName"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("LastName", System.Data.OleDb.OleDbType.VarWChar, 50, "LastName"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Phone", System.Data.OleDb.OleDbType.VarWChar, 50, "Phone"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ContactID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ContactID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompID", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EMail", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EMail", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Fax", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Fax", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FirstName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LastName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Phone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = "DELETE FROM tblContacts WHERE (ContactID = ?) AND (CompID = ?) AND (EMail = ?) AN" +
"D (Fax = ?) AND (FirstName = ?) AND (LastName = ?) AND (Phone = ?)";
this.oleDbDeleteCommand1.Connection = this.emConnection;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ContactID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ContactID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_CompID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_EMail", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EMail", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Fax", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Fax", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_FirstName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FirstName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_LastName", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LastName", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Phone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
//
// Contacts
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(712, 549);
this.Controls.Add(this.emailEdt);
this.Controls.Add(this.label5);
this.Controls.Add(this.faxEdt);
this.Controls.Add(this.label4);
this.Controls.Add(this.phoneEdt);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.lastNameEdt);
this.Controls.Add(this.firstNameEdt);
this.Controls.Add(this.contactList);
this.Controls.Add(this.label1);
this.Controls.Add(this.companyCombo);
this.Name = "Contacts";
this.Text = "Contacts";
((System.ComponentModel.ISupportInitialize)(this.emDataSet)).EndInit();
this.ResumeLayout(false);
}
