By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

Insert into Access with C#

P: n/a
I have no clue on how to insert a record into access. here is the whole
thing

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace Project_Two

{

/// <summary>

/// Summary description for Form1.

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Label FIRSTNAMELabel;

private System.Windows.Forms.Label LastNameLabel;

private System.Windows.Forms.Label ADDRESSLABEL;

private System.Windows.Forms.Label CITYLABEL;

private System.Windows.Forms.Label STATELABEL;

private System.Windows.Forms.Label ZIPLABEL;

private System.Windows.Forms.Label EMAILLABEL;

private System.Windows.Forms.Label HMPHONELABEL;

private System.Windows.Forms.Label CELLPHONELabel;

private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;

private System.Data.OleDb.OleDbConnection oleDbConnection1;

private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;

private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

private Project_Two.DataSet1 dataSet11;

private System.Windows.Forms.Button FORWARDButton;

private System.Windows.Forms.Button BackButton;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Button ADDButton;

private System.Windows.Forms.Button DeleteButton;

private System.Windows.Forms.Button EditButton;

private System.Windows.Forms.Button SaveButton;

private System.Windows.Forms.Button LastButton;

private System.Windows.Forms.Button FirstButton;

private System.Windows.Forms.Button SearchButton;

private System.Windows.Forms.TextBox AddressText;

private System.Windows.Forms.TextBox CityText;

private System.Windows.Forms.TextBox StateText;

private System.Windows.Forms.TextBox ZipcodeText;

private System.Windows.Forms.TextBox EmailText;

private System.Windows.Forms.TextBox HomeNumberText;

private System.Windows.Forms.TextBox CellphoneText;

private System.Windows.Forms.TextBox FirstNameTxt;

private System.Windows.Forms.TextBox LastNameText;

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.Container components = null;

public Form1()

{

//

// Required for Windows Form Designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.FIRSTNAMELabel = new System.Windows.Forms.Label();

this.LastNameLabel = new System.Windows.Forms.Label();

this.ADDRESSLABEL = new System.Windows.Forms.Label();

this.AddressText = new System.Windows.Forms.TextBox();

this.dataSet11 = new Project_Two.DataSet1();

this.CITYLABEL = new System.Windows.Forms.Label();

this.CityText = new System.Windows.Forms.TextBox();

this.STATELABEL = new System.Windows.Forms.Label();

this.StateText = new System.Windows.Forms.TextBox();

this.ZIPLABEL = new System.Windows.Forms.Label();

this.ZipcodeText = new System.Windows.Forms.TextBox();

this.EMAILLABEL = new System.Windows.Forms.Label();

this.EmailText = new System.Windows.Forms.TextBox();

this.HMPHONELABEL = new System.Windows.Forms.Label();

this.HomeNumberText = new System.Windows.Forms.TextBox();

this.CELLPHONELabel = new System.Windows.Forms.Label();

this.CellphoneText = new System.Windows.Forms.TextBox();

this.FORWARDButton = new System.Windows.Forms.Button();

this.ADDButton = new System.Windows.Forms.Button();

this.BackButton = new System.Windows.Forms.Button();

this.EditButton = new System.Windows.Forms.Button();

this.DeleteButton = new System.Windows.Forms.Button();

this.FirstNameTxt = new System.Windows.Forms.TextBox();

this.LastNameText = new System.Windows.Forms.TextBox();

this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();

this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbConnection1 = 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.label1 = new System.Windows.Forms.Label();

this.FirstButton = new System.Windows.Forms.Button();

this.LastButton = new System.Windows.Forms.Button();

this.SaveButton = new System.Windows.Forms.Button();

this.SearchButton = new System.Windows.Forms.Button();

((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).BeginInit();

this.SuspendLayout();

//

// FIRSTNAMELabel

//

this.FIRSTNAMELabel.Location = new System.Drawing.Point(40, 88);

this.FIRSTNAMELabel.Name = "FIRSTNAMELabel";

this.FIRSTNAMELabel.Size = new System.Drawing.Size(96, 24);

this.FIRSTNAMELabel.TabIndex = 1;

this.FIRSTNAMELabel.Text = "FIRST NAME";

//

// LastNameLabel

//

this.LastNameLabel.Location = new System.Drawing.Point(40, 128);

this.LastNameLabel.Name = "LastNameLabel";

this.LastNameLabel.Size = new System.Drawing.Size(80, 24);

this.LastNameLabel.TabIndex = 2;

this.LastNameLabel.Text = "LAST NAME";

//

// ADDRESSLABEL

//

this.ADDRESSLABEL.Location = new System.Drawing.Point(40, 160);

this.ADDRESSLABEL.Name = "ADDRESSLABEL";

this.ADDRESSLABEL.Size = new System.Drawing.Size(72, 24);

this.ADDRESSLABEL.TabIndex = 4;

this.ADDRESSLABEL.Text = "ADDRESS";

//

// AddressText

//

this.AddressText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.Address"));

this.AddressText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.AddressText.Location = new System.Drawing.Point(184, 160);

this.AddressText.Name = "AddressText";

this.AddressText.Size = new System.Drawing.Size(160, 26);

this.AddressText.TabIndex = 5;

this.AddressText.Text = "";

//

// dataSet11

//

this.dataSet11.DataSetName = "DataSet1";

this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");

//

// CITYLABEL

//

this.CITYLABEL.Location = new System.Drawing.Point(40, 192);

this.CITYLABEL.Name = "CITYLABEL";

this.CITYLABEL.Size = new System.Drawing.Size(64, 24);

this.CITYLABEL.TabIndex = 6;

this.CITYLABEL.Text = "CITY";

//

// CityText

//

this.CityText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.City"));

this.CityText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.CityText.Location = new System.Drawing.Point(184, 192);

this.CityText.Name = "CityText";

this.CityText.Size = new System.Drawing.Size(160, 26);

this.CityText.TabIndex = 7;

this.CityText.Text = "";

//

// STATELABEL

//

this.STATELABEL.Location = new System.Drawing.Point(40, 232);

this.STATELABEL.Name = "STATELABEL";

this.STATELABEL.Size = new System.Drawing.Size(64, 24);

this.STATELABEL.TabIndex = 8;

this.STATELABEL.Text = "STATE";

//

// StateText

//

this.StateText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.State"));

this.StateText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.StateText.Location = new System.Drawing.Point(184, 224);

this.StateText.Name = "StateText";

this.StateText.Size = new System.Drawing.Size(56, 26);

this.StateText.TabIndex = 9;

this.StateText.Text = "";

//

// ZIPLABEL

//

this.ZIPLABEL.Location = new System.Drawing.Point(32, 272);

this.ZIPLABEL.Name = "ZIPLABEL";

this.ZIPLABEL.Size = new System.Drawing.Size(64, 24);

this.ZIPLABEL.TabIndex = 10;

this.ZIPLABEL.Text = "ZIP CODE";

//

// ZipcodeText

//

this.ZipcodeText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.Zip"));

this.ZipcodeText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.ZipcodeText.Location = new System.Drawing.Point(184, 264);

this.ZipcodeText.Name = "ZipcodeText";

this.ZipcodeText.Size = new System.Drawing.Size(104, 26);

this.ZipcodeText.TabIndex = 11;

this.ZipcodeText.Text = "";

//

// EMAILLABEL

//

this.EMAILLABEL.Location = new System.Drawing.Point(32, 304);

this.EMAILLABEL.Name = "EMAILLABEL";

this.EMAILLABEL.Size = new System.Drawing.Size(72, 24);

this.EMAILLABEL.TabIndex = 12;

this.EMAILLABEL.Text = "E-MAIL ID#";

//

// EmailText

//

this.EmailText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.E-Mail ID#"));

this.EmailText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.EmailText.Location = new System.Drawing.Point(184, 304);

this.EmailText.Name = "EmailText";

this.EmailText.Size = new System.Drawing.Size(160, 26);

this.EmailText.TabIndex = 13;

this.EmailText.Text = "";

//

// HMPHONELABEL

//

this.HMPHONELABEL.Location = new System.Drawing.Point(32, 344);

this.HMPHONELABEL.Name = "HMPHONELABEL";

this.HMPHONELABEL.Size = new System.Drawing.Size(56, 24);

this.HMPHONELABEL.TabIndex = 14;

this.HMPHONELABEL.Text = "HOME#";

//

// HomeNumberText

//

this.HomeNumberText.DataBindings.Add(new
System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Home Phone
#"));

this.HomeNumberText.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.HomeNumberText.Location = new System.Drawing.Point(184, 336);

this.HomeNumberText.Name = "HomeNumberText";

this.HomeNumberText.Size = new System.Drawing.Size(160, 26);

this.HomeNumberText.TabIndex = 15;

this.HomeNumberText.Text = "";

//

// CELLPHONELabel

//

this.CELLPHONELabel.Location = new System.Drawing.Point(32, 376);

this.CELLPHONELabel.Name = "CELLPHONELabel";

this.CELLPHONELabel.Size = new System.Drawing.Size(88, 24);

this.CELLPHONELabel.TabIndex = 16;

this.CELLPHONELabel.Text = "CELLPHONE#";

//

// CellphoneText

//

this.CellphoneText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.Cell Phone #"));

this.CellphoneText.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.CellphoneText.Location = new System.Drawing.Point(184, 368);

this.CellphoneText.Name = "CellphoneText";

this.CellphoneText.Size = new System.Drawing.Size(160, 26);

this.CellphoneText.TabIndex = 17;

this.CellphoneText.Text = "";

//

// FORWARDButton

//

this.FORWARDButton.Location = new System.Drawing.Point(240, 424);

this.FORWARDButton.Name = "FORWARDButton";

this.FORWARDButton.Size = new System.Drawing.Size(72, 40);

this.FORWARDButton.TabIndex = 20;

this.FORWARDButton.Text = "&FORWARD";

this.FORWARDButton.Click += new
System.EventHandler(this.FORWARDButton_Click);

//

// ADDButton

//

this.ADDButton.Location = new System.Drawing.Point(488, 88);

this.ADDButton.Name = "ADDButton";

this.ADDButton.Size = new System.Drawing.Size(112, 48);

this.ADDButton.TabIndex = 21;

this.ADDButton.Text = "&ADD NEW RECORD";

this.ADDButton.Click += new System.EventHandler(this.ADDButton_Click);

//

// BackButton

//

this.BackButton.Location = new System.Drawing.Point(152, 424);

this.BackButton.Name = "BackButton";

this.BackButton.Size = new System.Drawing.Size(72, 40);

this.BackButton.TabIndex = 22;

this.BackButton.Text = "&GO BACK";

this.BackButton.Click += new System.EventHandler(this.BackButton_Click);

//

// EditButton

//

this.EditButton.Location = new System.Drawing.Point(480, 144);

this.EditButton.Name = "EditButton";

this.EditButton.Size = new System.Drawing.Size(120, 56);

this.EditButton.TabIndex = 23;

this.EditButton.Text = "&EDIT RECORD";

this.EditButton.Click += new System.EventHandler(this.Edit_Click);

//

// DeleteButton

//

this.DeleteButton.Location = new System.Drawing.Point(480, 208);

this.DeleteButton.Name = "DeleteButton";

this.DeleteButton.Size = new System.Drawing.Size(120, 56);

this.DeleteButton.TabIndex = 24;

this.DeleteButton.Text = "&DELETE RECORD";

//

// FirstNameTxt

//

this.FirstNameTxt.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.First name"));

this.FirstNameTxt.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.FirstNameTxt.Location = new System.Drawing.Point(184, 88);

this.FirstNameTxt.Name = "FirstNameTxt";

this.FirstNameTxt.Size = new System.Drawing.Size(160, 26);

this.FirstNameTxt.TabIndex = 0;

this.FirstNameTxt.Text = "";

//

// LastNameText

//

this.LastNameText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.Last name"));

this.LastNameText.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.LastNameText.Location = new System.Drawing.Point(184, 128);

this.LastNameText.Name = "LastNameText";

this.LastNameText.Size = new System.Drawing.Size(160, 26);

this.LastNameText.TabIndex = 3;

this.LastNameText.Text = "";

//

// oleDbDataAdapter1

//

this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;

this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;

this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;

this.oleDbDataAdapter1.TableMappings.AddRange(new
System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "Table1", new
System.Data.Common.DataColumnMapping[] {

new System.Data.Common.DataColumnMapping("Address", "Address"),

new System.Data.Common.DataColumnMapping("Cell Phone #", "Cell Phone #"),

new System.Data.Common.DataColumnMapping("City", "City"),

new System.Data.Common.DataColumnMapping("E-Mail ID#", "E-Mail ID#"),

new System.Data.Common.DataColumnMapping("First name", "First name"),

new System.Data.Common.DataColumnMapping("Home Phone #", "Home Phone #"),

new System.Data.Common.DataColumnMapping("Id#", "Id#"),

new System.Data.Common.DataColumnMapping("Last name", "Last name"),

new System.Data.Common.DataColumnMapping("State", "State"),

new System.Data.Common.DataColumnMapping("Zip", "Zip")})});

this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;

//

// oleDbDeleteCommand1

//

this.oleDbDeleteCommand1.CommandText = @"DELETE FROM Table1 WHERE ([Id#] =
?) AND (Address = ? OR ? IS NULL AND Address IS NULL) AND ([Cell Phone #] =
? OR ? IS NULL AND [Cell Phone #] IS NULL) AND (City = ? OR ? IS NULL AND
City IS NULL) AND ([E-Mail ID#] = ? OR ? IS NULL AND [E-Mail ID#] IS NULL)
AND ([First name] = ? OR ? IS NULL AND [First name] IS NULL) AND ([Home
Phone #] = ? OR ? IS NULL AND [Home Phone #] IS NULL) AND ([Last name] = ?
OR ? IS NULL AND [Last name] IS NULL) AND (State = ? OR ? IS NULL AND State
IS NULL) AND (Zip = ? OR ? IS NULL AND Zip IS NULL)";

this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Id_",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Id#", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address ",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address 1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1" ,
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip1",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

//

// oleDbConnection1

//

this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Database Password=;Data Source=""C:\ITFN2314\Project Two for
ITFN2314.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";

this.oleDbConnection1.InfoMessage += new
System.Data.OleDb.OleDbInfoMessageEventHandler(thi s.oleDbConnection1_InfoMes
sage);

//

// oleDbInsertCommand1

//

this.oleDbInsertCommand1.CommandText = "INSERT INTO Table1(Address, [Cell
Phone #], City, [E-Mail ID#], [First name], [Ho" +

"me Phone #], [Last name], State, Zip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";

this.oleDbInsertCommand1.Connection = this.oleDbConnection1;

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Address",
System.Data.OleDb.OleDbType.VarWChar, 50, "Address"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Cell_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Cell Phone #"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("E_Mail_ID_",
System.Data.OleDb.OleDbType.VarWChar, 50, "E-Mail ID#"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("First_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "First name"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Home_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Home Phone #"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Last_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "Last name"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 50, "State"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Zip",
System.Data.OleDb.OleDbType.VarWChar, 5, "Zip"));

//

// oleDbSelectCommand1

//

this.oleDbSelectCommand1.CommandText = "SELECT Address, [Cell Phone #],
City, [E-Mail ID#], [First name], [Home Phone #]," +

" [Id#], [Last name], State, Zip FROM Table1";

this.oleDbSelectCommand1.Connection = this.oleDbConnection1;

//

// oleDbUpdateCommand1

//

this.oleDbUpdateCommand1.CommandText = @"UPDATE Table1 SET Address = ?,
[Cell Phone #] = ?, City = ?, [E-Mail ID#] = ?, [First name] = ?, [Home
Phone #] = ?, [Last name] = ?, State = ?, Zip = ? WHERE ([Id#] = ?) AND
(Address = ? OR ? IS NULL AND Address IS NULL) AND ([Cell Phone #] = ? OR ?
IS NULL AND [Cell Phone #] IS NULL) AND (City = ? OR ? IS NULL AND City IS
NULL) AND ([E-Mail ID#] = ? OR ? IS NULL AND [E-Mail ID#] IS NULL) AND
([First name] = ? OR ? IS NULL AND [First name] IS NULL) AND ([Home Phone #]
= ? OR ? IS NULL AND [Home Phone #] IS NULL) AND ([Last name] = ? OR ? IS
NULL AND [Last name] IS NULL) AND (State = ? OR ? IS NULL AND State IS NULL)
AND (Zip = ? OR ? IS NULL AND Zip IS NULL)";

this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Address",
System.Data.OleDb.OleDbType.VarWChar, 50, "Address"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Cell_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Cell Phone #"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("E_Mail_ID_",
System.Data.OleDb.OleDbType.VarWChar, 50, "E-Mail ID#"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("First_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "First name"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Home_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Home Phone #"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Last_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "Last name"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 50, "State"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Zip",
System.Data.OleDb.OleDbType.VarWChar, 5, "Zip"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Id_",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Id#", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address ",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address 1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1" ,
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip1",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

//

// label1

//

this.label1.Font = new System.Drawing.Font("Monotype Corsiva", 15.75F,
((System.Drawing.FontStyle)((System.Drawing.FontSt yle.Bold |
System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.label1.Location = new System.Drawing.Point(304, 24);

this.label1.Name = "label1";

this.label1.Size = new System.Drawing.Size(168, 24);

this.label1.TabIndex = 25;

this.label1.Text = "CONTACT LIST";

//

// FirstButton

//

this.FirstButton.Location = new System.Drawing.Point(64, 424);

this.FirstButton.Name = "FirstButton";

this.FirstButton.Size = new System.Drawing.Size(75, 40);

this.FirstButton.TabIndex = 26;

this.FirstButton.Text = "&FIRST";

this.FirstButton.Click += new System.EventHandler(this.FirstButton_Click);

//

// LastButton

//

this.LastButton.Location = new System.Drawing.Point(328, 424);

this.LastButton.Name = "LastButton";

this.LastButton.Size = new System.Drawing.Size(75, 40);

this.LastButton.TabIndex = 27;

this.LastButton.Text = "&LAST";

this.LastButton.Click += new System.EventHandler(this.LastButton_Click);

//

// SaveButton

//

this.SaveButton.Location = new System.Drawing.Point(480, 88);

this.SaveButton.Name = "SaveButton";

this.SaveButton.Size = new System.Drawing.Size(120, 48);

this.SaveButton.TabIndex = 28;

this.SaveButton.Text = "&SAVE RECORD";

this.SaveButton.Visible = false;

this.SaveButton.Click += new System.EventHandler(this.SaveButton_Click);

//

// SearchButton

//

this.SearchButton.Location = new System.Drawing.Point(480, 272);

this.SearchButton.Name = "SearchButton";

this.SearchButton.Size = new System.Drawing.Size(120, 48);

this.SearchButton.TabIndex = 29;

this.SearchButton.Text = "&SEARCH";

//

// Form1

//

this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);

this.BackColor = System.Drawing.Color.LightSkyBlue;

this.ClientSize = new System.Drawing.Size(776, 526);

this.Controls.Add(this.SearchButton);

this.Controls.Add(this.SaveButton);

this.Controls.Add(this.LastButton);

this.Controls.Add(this.FirstButton);

this.Controls.Add(this.label1);

this.Controls.Add(this.DeleteButton);

this.Controls.Add(this.EditButton);

this.Controls.Add(this.BackButton);

this.Controls.Add(this.ADDButton);

this.Controls.Add(this.FORWARDButton);

this.Controls.Add(this.CellphoneText);

this.Controls.Add(this.HomeNumberText);

this.Controls.Add(this.EmailText);

this.Controls.Add(this.ZipcodeText);

this.Controls.Add(this.StateText);

this.Controls.Add(this.CityText);

this.Controls.Add(this.AddressText);

this.Controls.Add(this.FirstNameTxt);

this.Controls.Add(this.LastNameText);

this.Controls.Add(this.CELLPHONELabel);

this.Controls.Add(this.HMPHONELABEL);

this.Controls.Add(this.EMAILLABEL);

this.Controls.Add(this.ZIPLABEL);

this.Controls.Add(this.STATELABEL);

this.Controls.Add(this.CITYLABEL);

this.Controls.Add(this.ADDRESSLABEL);

this.Controls.Add(this.LastNameLabel);

this.Controls.Add(this.FIRSTNAMELabel);

this.ForeColor = System.Drawing.Color.MediumBlue;

this.Name = "Form1";

this.Text = "Project Two";

this.Load += new System.EventHandler(this.Form1_Load);

((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).EndInit();

this.ResumeLayout(false);

}

#endregion

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main()

{

Application.Run(new Form1());

}

private void Form1_Load(object sender, System.EventArgs e)

{

oleDbConnection1.Open();

oleDbDataAdapter1.Fill(dataSet11);

oleDbConnection1.Close();

}

private void FORWARDButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position += 1;

}

private void BackButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position -=1;


}

private void oleDbConnection1_InfoMessage(object sender,
System.Data.OleDb.OleDbInfoMessageEventArgs e)

{
}

private void ADDButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].AddNew();

ADDButton.Visible = false;

SaveButton.Visible = true;

}
private void SaveButton_Click(object sender, System.EventArgs e)

{

ADDButton.Visible = true;

SaveButton.Visible = false;

System.Data.OleDb.OleDbCommand cmd;

cmd = new System.Data.OleDb.OleDbCommand ("Insert INTO Table1 (ID#, First
name, Last name, Address, City,State,Zip Code,e-mail ID#,Home Phone#,
Cellphone#) Values ('', FirstNameTxt, LastNameText, AddressText, CityText,
ZipcodeText, EmailText,HomeNumberText,CellphoneText) ");

oleDbConnection1.Open();

oleDbDataAdapter1.Update(dataSet11);

oleDbConnection1.Close();

}

private void Edit_Click(object sender, System.EventArgs e)

{
}

private void LastButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position =
this.BindingContext[dataSet11, "Table1"].Count-1;

}

private void FirstButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position = 0;

}


}


}
Nov 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yep, there's defnitiely a lot of problems... For now, I'd use the
Configuration Wizard to generate the update/Select/insert logic for you -
the update command is very broken and it's easier to just drag an Adapter
and see the code it generates. You may also want to specify a table in the
dataset that you are filling and update the same table. You'll also need to
verify that you have Changes (DataSet.HasChanges) otherwise calling update
is going to be worthless anyway.

From a cursory view your bindings look ok but It's a little hard to read so
I'm not positive there's nothign wrong there. But get the update code done
with the wizard and we'll take it from there.

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/...ity/newsgroups
"Abareblue" <pr****@bellsouth.net> wrote in message
news:ue*******************@bignews2.bellsouth.net. ..
I have no clue on how to insert a record into access. here is the whole
thing

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace Project_Two

{

/// <summary>

/// Summary description for Form1.

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Label FIRSTNAMELabel;

private System.Windows.Forms.Label LastNameLabel;

private System.Windows.Forms.Label ADDRESSLABEL;

private System.Windows.Forms.Label CITYLABEL;

private System.Windows.Forms.Label STATELABEL;

private System.Windows.Forms.Label ZIPLABEL;

private System.Windows.Forms.Label EMAILLABEL;

private System.Windows.Forms.Label HMPHONELABEL;

private System.Windows.Forms.Label CELLPHONELabel;

private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;

private System.Data.OleDb.OleDbConnection oleDbConnection1;

private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;

private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

private Project_Two.DataSet1 dataSet11;

private System.Windows.Forms.Button FORWARDButton;

private System.Windows.Forms.Button BackButton;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Button ADDButton;

private System.Windows.Forms.Button DeleteButton;

private System.Windows.Forms.Button EditButton;

private System.Windows.Forms.Button SaveButton;

private System.Windows.Forms.Button LastButton;

private System.Windows.Forms.Button FirstButton;

private System.Windows.Forms.Button SearchButton;

private System.Windows.Forms.TextBox AddressText;

private System.Windows.Forms.TextBox CityText;

private System.Windows.Forms.TextBox StateText;

private System.Windows.Forms.TextBox ZipcodeText;

private System.Windows.Forms.TextBox EmailText;

private System.Windows.Forms.TextBox HomeNumberText;

private System.Windows.Forms.TextBox CellphoneText;

private System.Windows.Forms.TextBox FirstNameTxt;

private System.Windows.Forms.TextBox LastNameText;

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.Container components = null;

public Form1()

{

//

// Required for Windows Form Designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.FIRSTNAMELabel = new System.Windows.Forms.Label();

this.LastNameLabel = new System.Windows.Forms.Label();

this.ADDRESSLABEL = new System.Windows.Forms.Label();

this.AddressText = new System.Windows.Forms.TextBox();

this.dataSet11 = new Project_Two.DataSet1();

this.CITYLABEL = new System.Windows.Forms.Label();

this.CityText = new System.Windows.Forms.TextBox();

this.STATELABEL = new System.Windows.Forms.Label();

this.StateText = new System.Windows.Forms.TextBox();

this.ZIPLABEL = new System.Windows.Forms.Label();

this.ZipcodeText = new System.Windows.Forms.TextBox();

this.EMAILLABEL = new System.Windows.Forms.Label();

this.EmailText = new System.Windows.Forms.TextBox();

this.HMPHONELABEL = new System.Windows.Forms.Label();

this.HomeNumberText = new System.Windows.Forms.TextBox();

this.CELLPHONELabel = new System.Windows.Forms.Label();

this.CellphoneText = new System.Windows.Forms.TextBox();

this.FORWARDButton = new System.Windows.Forms.Button();

this.ADDButton = new System.Windows.Forms.Button();

this.BackButton = new System.Windows.Forms.Button();

this.EditButton = new System.Windows.Forms.Button();

this.DeleteButton = new System.Windows.Forms.Button();

this.FirstNameTxt = new System.Windows.Forms.TextBox();

this.LastNameText = new System.Windows.Forms.TextBox();

this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();

this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();

this.oleDbConnection1 = 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.label1 = new System.Windows.Forms.Label();

this.FirstButton = new System.Windows.Forms.Button();

this.LastButton = new System.Windows.Forms.Button();

this.SaveButton = new System.Windows.Forms.Button();

this.SearchButton = new System.Windows.Forms.Button();

((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).BeginInit();

this.SuspendLayout();

//

// FIRSTNAMELabel

//

this.FIRSTNAMELabel.Location = new System.Drawing.Point(40, 88);

this.FIRSTNAMELabel.Name = "FIRSTNAMELabel";

this.FIRSTNAMELabel.Size = new System.Drawing.Size(96, 24);

this.FIRSTNAMELabel.TabIndex = 1;

this.FIRSTNAMELabel.Text = "FIRST NAME";

//

// LastNameLabel

//

this.LastNameLabel.Location = new System.Drawing.Point(40, 128);

this.LastNameLabel.Name = "LastNameLabel";

this.LastNameLabel.Size = new System.Drawing.Size(80, 24);

this.LastNameLabel.TabIndex = 2;

this.LastNameLabel.Text = "LAST NAME";

//

// ADDRESSLABEL

//

this.ADDRESSLABEL.Location = new System.Drawing.Point(40, 160);

this.ADDRESSLABEL.Name = "ADDRESSLABEL";

this.ADDRESSLABEL.Size = new System.Drawing.Size(72, 24);

this.ADDRESSLABEL.TabIndex = 4;

this.ADDRESSLABEL.Text = "ADDRESS";

//

// AddressText

//

this.AddressText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.Address"));

this.AddressText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.AddressText.Location = new System.Drawing.Point(184, 160);

this.AddressText.Name = "AddressText";

this.AddressText.Size = new System.Drawing.Size(160, 26);

this.AddressText.TabIndex = 5;

this.AddressText.Text = "";

//

// dataSet11

//

this.dataSet11.DataSetName = "DataSet1";

this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");

//

// CITYLABEL

//

this.CITYLABEL.Location = new System.Drawing.Point(40, 192);

this.CITYLABEL.Name = "CITYLABEL";

this.CITYLABEL.Size = new System.Drawing.Size(64, 24);

this.CITYLABEL.TabIndex = 6;

this.CITYLABEL.Text = "CITY";

//

// CityText

//

this.CityText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.City"));

this.CityText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.CityText.Location = new System.Drawing.Point(184, 192);

this.CityText.Name = "CityText";

this.CityText.Size = new System.Drawing.Size(160, 26);

this.CityText.TabIndex = 7;

this.CityText.Text = "";

//

// STATELABEL

//

this.STATELABEL.Location = new System.Drawing.Point(40, 232);

this.STATELABEL.Name = "STATELABEL";

this.STATELABEL.Size = new System.Drawing.Size(64, 24);

this.STATELABEL.TabIndex = 8;

this.STATELABEL.Text = "STATE";

//

// StateText

//

this.StateText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.State"));

this.StateText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.StateText.Location = new System.Drawing.Point(184, 224);

this.StateText.Name = "StateText";

this.StateText.Size = new System.Drawing.Size(56, 26);

this.StateText.TabIndex = 9;

this.StateText.Text = "";

//

// ZIPLABEL

//

this.ZIPLABEL.Location = new System.Drawing.Point(32, 272);

this.ZIPLABEL.Name = "ZIPLABEL";

this.ZIPLABEL.Size = new System.Drawing.Size(64, 24);

this.ZIPLABEL.TabIndex = 10;

this.ZIPLABEL.Text = "ZIP CODE";

//

// ZipcodeText

//

this.ZipcodeText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.Zip"));

this.ZipcodeText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.ZipcodeText.Location = new System.Drawing.Point(184, 264);

this.ZipcodeText.Name = "ZipcodeText";

this.ZipcodeText.Size = new System.Drawing.Size(104, 26);

this.ZipcodeText.TabIndex = 11;

this.ZipcodeText.Text = "";

//

// EMAILLABEL

//

this.EMAILLABEL.Location = new System.Drawing.Point(32, 304);

this.EMAILLABEL.Name = "EMAILLABEL";

this.EMAILLABEL.Size = new System.Drawing.Size(72, 24);

this.EMAILLABEL.TabIndex = 12;

this.EMAILLABEL.Text = "E-MAIL ID#";

//

// EmailText

//

this.EmailText.DataBindings.Add(new System.Windows.Forms.Binding("Text",
this.dataSet11, "Table1.E-Mail ID#"));

this.EmailText.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.EmailText.Location = new System.Drawing.Point(184, 304);

this.EmailText.Name = "EmailText";

this.EmailText.Size = new System.Drawing.Size(160, 26);

this.EmailText.TabIndex = 13;

this.EmailText.Text = "";

//

// HMPHONELABEL

//

this.HMPHONELABEL.Location = new System.Drawing.Point(32, 344);

this.HMPHONELABEL.Name = "HMPHONELABEL";

this.HMPHONELABEL.Size = new System.Drawing.Size(56, 24);

this.HMPHONELABEL.TabIndex = 14;

this.HMPHONELABEL.Text = "HOME#";

//

// HomeNumberText

//

this.HomeNumberText.DataBindings.Add(new
System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Home Phone
#"));

this.HomeNumberText.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.HomeNumberText.Location = new System.Drawing.Point(184, 336);

this.HomeNumberText.Name = "HomeNumberText";

this.HomeNumberText.Size = new System.Drawing.Size(160, 26);

this.HomeNumberText.TabIndex = 15;

this.HomeNumberText.Text = "";

//

// CELLPHONELabel

//

this.CELLPHONELabel.Location = new System.Drawing.Point(32, 376);

this.CELLPHONELabel.Name = "CELLPHONELabel";

this.CELLPHONELabel.Size = new System.Drawing.Size(88, 24);

this.CELLPHONELabel.TabIndex = 16;

this.CELLPHONELabel.Text = "CELLPHONE#";

//

// CellphoneText

//

this.CellphoneText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Cell Phone #"));

this.CellphoneText.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.CellphoneText.Location = new System.Drawing.Point(184, 368);

this.CellphoneText.Name = "CellphoneText";

this.CellphoneText.Size = new System.Drawing.Size(160, 26);

this.CellphoneText.TabIndex = 17;

this.CellphoneText.Text = "";

//

// FORWARDButton

//

this.FORWARDButton.Location = new System.Drawing.Point(240, 424);

this.FORWARDButton.Name = "FORWARDButton";

this.FORWARDButton.Size = new System.Drawing.Size(72, 40);

this.FORWARDButton.TabIndex = 20;

this.FORWARDButton.Text = "&FORWARD";

this.FORWARDButton.Click += new
System.EventHandler(this.FORWARDButton_Click);

//

// ADDButton

//

this.ADDButton.Location = new System.Drawing.Point(488, 88);

this.ADDButton.Name = "ADDButton";

this.ADDButton.Size = new System.Drawing.Size(112, 48);

this.ADDButton.TabIndex = 21;

this.ADDButton.Text = "&ADD NEW RECORD";

this.ADDButton.Click += new System.EventHandler(this.ADDButton_Click);

//

// BackButton

//

this.BackButton.Location = new System.Drawing.Point(152, 424);

this.BackButton.Name = "BackButton";

this.BackButton.Size = new System.Drawing.Size(72, 40);

this.BackButton.TabIndex = 22;

this.BackButton.Text = "&GO BACK";

this.BackButton.Click += new System.EventHandler(this.BackButton_Click);

//

// EditButton

//

this.EditButton.Location = new System.Drawing.Point(480, 144);

this.EditButton.Name = "EditButton";

this.EditButton.Size = new System.Drawing.Size(120, 56);

this.EditButton.TabIndex = 23;

this.EditButton.Text = "&EDIT RECORD";

this.EditButton.Click += new System.EventHandler(this.Edit_Click);

//

// DeleteButton

//

this.DeleteButton.Location = new System.Drawing.Point(480, 208);

this.DeleteButton.Name = "DeleteButton";

this.DeleteButton.Size = new System.Drawing.Size(120, 56);

this.DeleteButton.TabIndex = 24;

this.DeleteButton.Text = "&DELETE RECORD";

//

// FirstNameTxt

//

this.FirstNameTxt.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.First name"));

this.FirstNameTxt.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.FirstNameTxt.Location = new System.Drawing.Point(184, 88);

this.FirstNameTxt.Name = "FirstNameTxt";

this.FirstNameTxt.Size = new System.Drawing.Size(160, 26);

this.FirstNameTxt.TabIndex = 0;

this.FirstNameTxt.Text = "";

//

// LastNameText

//

this.LastNameText.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "Table1.Last name"));

this.LastNameText.Font = new System.Drawing.Font("Microsoft Sans Serif",
12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.LastNameText.Location = new System.Drawing.Point(184, 128);

this.LastNameText.Name = "LastNameText";

this.LastNameText.Size = new System.Drawing.Size(160, 26);

this.LastNameText.TabIndex = 3;

this.LastNameText.Text = "";

//

// oleDbDataAdapter1

//

this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;

this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;

this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;

this.oleDbDataAdapter1.TableMappings.AddRange(new
System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "Table1", new
System.Data.Common.DataColumnMapping[] {

new System.Data.Common.DataColumnMapping("Address", "Address"),

new System.Data.Common.DataColumnMapping("Cell Phone #", "Cell Phone #"),

new System.Data.Common.DataColumnMapping("City", "City"),

new System.Data.Common.DataColumnMapping("E-Mail ID#", "E-Mail ID#"),

new System.Data.Common.DataColumnMapping("First name", "First name"),

new System.Data.Common.DataColumnMapping("Home Phone #", "Home Phone #"),

new System.Data.Common.DataColumnMapping("Id#", "Id#"),

new System.Data.Common.DataColumnMapping("Last name", "Last name"),

new System.Data.Common.DataColumnMapping("State", "State"),

new System.Data.Common.DataColumnMapping("Zip", "Zip")})});

this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;

//

// oleDbDeleteCommand1

//

this.oleDbDeleteCommand1.CommandText = @"DELETE FROM Table1 WHERE ([Id#] =
?) AND (Address = ? OR ? IS NULL AND Address IS NULL) AND ([Cell Phone #] = ? OR ? IS NULL AND [Cell Phone #] IS NULL) AND (City = ? OR ? IS NULL AND
City IS NULL) AND ([E-Mail ID#] = ? OR ? IS NULL AND [E-Mail ID#] IS NULL)
AND ([First name] = ? OR ? IS NULL AND [First name] IS NULL) AND ([Home
Phone #] = ? OR ? IS NULL AND [Home Phone #] IS NULL) AND ([Last name] = ?
OR ? IS NULL AND [Last name] IS NULL) AND (State = ? OR ? IS NULL AND State IS NULL) AND (Zip = ? OR ? IS NULL AND Zip IS NULL)";

this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Id_",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Id#", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address ",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address 1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1" ,
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

this.oleDbDeleteCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip1",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

//

// oleDbConnection1

//

this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Database Password=;Data Source=""C:\ITFN2314\Project Two for
ITFN2314.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";

this.oleDbConnection1.InfoMessage += new
System.Data.OleDb.OleDbInfoMessageEventHandler(thi s.oleDbConnection1_InfoMes sage);

//

// oleDbInsertCommand1

//

this.oleDbInsertCommand1.CommandText = "INSERT INTO Table1(Address, [Cell
Phone #], City, [E-Mail ID#], [First name], [Ho" +

"me Phone #], [Last name], State, Zip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Address",
System.Data.OleDb.OleDbType.VarWChar, 50, "Address"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Cell_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Cell Phone #"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("E_Mail_ID_",
System.Data.OleDb.OleDbType.VarWChar, 50, "E-Mail ID#"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("First_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "First name"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Home_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Home Phone #"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Last_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "Last name"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 50, "State"));

this.oleDbInsertCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Zip",
System.Data.OleDb.OleDbType.VarWChar, 5, "Zip"));

//

// oleDbSelectCommand1

//

this.oleDbSelectCommand1.CommandText = "SELECT Address, [Cell Phone #],
City, [E-Mail ID#], [First name], [Home Phone #]," +

" [Id#], [Last name], State, Zip FROM Table1";

this.oleDbSelectCommand1.Connection = this.oleDbConnection1;

//

// oleDbUpdateCommand1

//

this.oleDbUpdateCommand1.CommandText = @"UPDATE Table1 SET Address = ?,
[Cell Phone #] = ?, City = ?, [E-Mail ID#] = ?, [First name] = ?, [Home
Phone #] = ?, [Last name] = ?, State = ?, Zip = ? WHERE ([Id#] = ?) AND
(Address = ? OR ? IS NULL AND Address IS NULL) AND ([Cell Phone #] = ? OR ? IS NULL AND [Cell Phone #] IS NULL) AND (City = ? OR ? IS NULL AND City IS
NULL) AND ([E-Mail ID#] = ? OR ? IS NULL AND [E-Mail ID#] IS NULL) AND
([First name] = ? OR ? IS NULL AND [First name] IS NULL) AND ([Home Phone #] = ? OR ? IS NULL AND [Home Phone #] IS NULL) AND ([Last name] = ? OR ? IS
NULL AND [Last name] IS NULL) AND (State = ? OR ? IS NULL AND State IS NULL) AND (Zip = ? OR ? IS NULL AND Zip IS NULL)";

this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Address",
System.Data.OleDb.OleDbType.VarWChar, 50, "Address"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Cell_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Cell Phone #"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("City",
System.Data.OleDb.OleDbType.VarWChar, 50, "City"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("E_Mail_ID_",
System.Data.OleDb.OleDbType.VarWChar, 50, "E-Mail ID#"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("First_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "First name"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Home_Phone__",
System.Data.OleDb.OleDbType.VarWChar, 12, "Home Phone #"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Last_name",
System.Data.OleDb.OleDbType.VarWChar, 50, "Last name"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("State",
System.Data.OleDb.OleDbType.VarWChar, 50, "State"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Zip",
System.Data.OleDb.OleDbType.VarWChar, 5, "Zip"));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Id_",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Id#", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address ",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Address 1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Cell_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Cell Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_City1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_E_Mail_ ID_1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "E-Mail ID#", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_First_n ame1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "First name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Home_Ph one__1",
System.Data.OleDb.OleDbType.VarWChar, 12,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Home Phone #", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Last_na me1",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Last name", System.Data.DataRowVersion.Original,
null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State",
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_State1" ,
System.Data.OleDb.OleDbType.VarWChar, 50,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "State", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

this.oleDbUpdateCommand1.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_Zip1",
System.Data.OleDb.OleDbType.VarWChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Zip", System.Data.DataRowVersion.Original, null));

//

// label1

//

this.label1.Font = new System.Drawing.Font("Monotype Corsiva", 15.75F,
((System.Drawing.FontStyle)((System.Drawing.FontSt yle.Bold |
System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point,
((System.Byte)(0)));

this.label1.Location = new System.Drawing.Point(304, 24);

this.label1.Name = "label1";

this.label1.Size = new System.Drawing.Size(168, 24);

this.label1.TabIndex = 25;

this.label1.Text = "CONTACT LIST";

//

// FirstButton

//

this.FirstButton.Location = new System.Drawing.Point(64, 424);

this.FirstButton.Name = "FirstButton";

this.FirstButton.Size = new System.Drawing.Size(75, 40);

this.FirstButton.TabIndex = 26;

this.FirstButton.Text = "&FIRST";

this.FirstButton.Click += new System.EventHandler(this.FirstButton_Click);

//

// LastButton

//

this.LastButton.Location = new System.Drawing.Point(328, 424);

this.LastButton.Name = "LastButton";

this.LastButton.Size = new System.Drawing.Size(75, 40);

this.LastButton.TabIndex = 27;

this.LastButton.Text = "&LAST";

this.LastButton.Click += new System.EventHandler(this.LastButton_Click);

//

// SaveButton

//

this.SaveButton.Location = new System.Drawing.Point(480, 88);

this.SaveButton.Name = "SaveButton";

this.SaveButton.Size = new System.Drawing.Size(120, 48);

this.SaveButton.TabIndex = 28;

this.SaveButton.Text = "&SAVE RECORD";

this.SaveButton.Visible = false;

this.SaveButton.Click += new System.EventHandler(this.SaveButton_Click);

//

// SearchButton

//

this.SearchButton.Location = new System.Drawing.Point(480, 272);

this.SearchButton.Name = "SearchButton";

this.SearchButton.Size = new System.Drawing.Size(120, 48);

this.SearchButton.TabIndex = 29;

this.SearchButton.Text = "&SEARCH";

//

// Form1

//

this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);

this.BackColor = System.Drawing.Color.LightSkyBlue;

this.ClientSize = new System.Drawing.Size(776, 526);

this.Controls.Add(this.SearchButton);

this.Controls.Add(this.SaveButton);

this.Controls.Add(this.LastButton);

this.Controls.Add(this.FirstButton);

this.Controls.Add(this.label1);

this.Controls.Add(this.DeleteButton);

this.Controls.Add(this.EditButton);

this.Controls.Add(this.BackButton);

this.Controls.Add(this.ADDButton);

this.Controls.Add(this.FORWARDButton);

this.Controls.Add(this.CellphoneText);

this.Controls.Add(this.HomeNumberText);

this.Controls.Add(this.EmailText);

this.Controls.Add(this.ZipcodeText);

this.Controls.Add(this.StateText);

this.Controls.Add(this.CityText);

this.Controls.Add(this.AddressText);

this.Controls.Add(this.FirstNameTxt);

this.Controls.Add(this.LastNameText);

this.Controls.Add(this.CELLPHONELabel);

this.Controls.Add(this.HMPHONELABEL);

this.Controls.Add(this.EMAILLABEL);

this.Controls.Add(this.ZIPLABEL);

this.Controls.Add(this.STATELABEL);

this.Controls.Add(this.CITYLABEL);

this.Controls.Add(this.ADDRESSLABEL);

this.Controls.Add(this.LastNameLabel);

this.Controls.Add(this.FIRSTNAMELabel);

this.ForeColor = System.Drawing.Color.MediumBlue;

this.Name = "Form1";

this.Text = "Project Two";

this.Load += new System.EventHandler(this.Form1_Load);

((System.ComponentModel.ISupportInitialize)(this.d ataSet11)).EndInit();

this.ResumeLayout(false);

}

#endregion

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main()

{

Application.Run(new Form1());

}

private void Form1_Load(object sender, System.EventArgs e)

{

oleDbConnection1.Open();

oleDbDataAdapter1.Fill(dataSet11);

oleDbConnection1.Close();

}

private void FORWARDButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position += 1;

}

private void BackButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position -=1;


}

private void oleDbConnection1_InfoMessage(object sender,
System.Data.OleDb.OleDbInfoMessageEventArgs e)

{
}

private void ADDButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].AddNew();

ADDButton.Visible = false;

SaveButton.Visible = true;

}
private void SaveButton_Click(object sender, System.EventArgs e)

{

ADDButton.Visible = true;

SaveButton.Visible = false;

System.Data.OleDb.OleDbCommand cmd;

cmd = new System.Data.OleDb.OleDbCommand ("Insert INTO Table1 (ID#, First
name, Last name, Address, City,State,Zip Code,e-mail ID#,Home Phone#,
Cellphone#) Values ('', FirstNameTxt, LastNameText, AddressText, CityText,
ZipcodeText, EmailText,HomeNumberText,CellphoneText) ");

oleDbConnection1.Open();

oleDbDataAdapter1.Update(dataSet11);

oleDbConnection1.Close();

}

private void Edit_Click(object sender, System.EventArgs e)

{
}

private void LastButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position =
this.BindingContext[dataSet11, "Table1"].Count-1;

}

private void FirstButton_Click(object sender, System.EventArgs e)

{

this.BindingContext[dataSet11, "Table1"].Position = 0;

}


}


}

Nov 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.