473,735 Members | 2,093 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Insert into Access with C#

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

using System;

using System.Drawing;

using System.Collecti ons;

using System.Componen tModel;

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.Ole Db.OleDbDataAda pter oleDbDataAdapte r1;

private System.Data.Ole Db.OleDbConnect ion oleDbConnection 1;

private System.Data.Ole Db.OleDbCommand oleDbSelectComm and1;

private System.Data.Ole Db.OleDbCommand oleDbInsertComm and1;

private System.Data.Ole Db.OleDbCommand oleDbUpdateComm and1;

private System.Data.Ole Db.OleDbCommand oleDbDeleteComm and1;

private Project_Two.Dat aSet1 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.Componen tModel.Containe r components = null;

public Form1()

{

//

// Required for Windows Form Designer support

//

InitializeCompo nent();

//

// TODO: Add any constructor code after InitializeCompo nent call

//

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Disp ose();

}

}

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 InitializeCompo nent()

{

this.FIRSTNAMEL abel = new System.Windows. Forms.Label();

this.LastNameLa bel = new System.Windows. Forms.Label();

this.ADDRESSLAB EL = new System.Windows. Forms.Label();

this.AddressTex t = new System.Windows. Forms.TextBox() ;

this.dataSet11 = new Project_Two.Dat aSet1();

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.ZipcodeTex t = new System.Windows. Forms.TextBox() ;

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

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

this.HMPHONELAB EL = new System.Windows. Forms.Label();

this.HomeNumber Text = new System.Windows. Forms.TextBox() ;

this.CELLPHONEL abel = new System.Windows. Forms.Label();

this.CellphoneT ext = new System.Windows. Forms.TextBox() ;

this.FORWARDBut ton = 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.DeleteButt on = new System.Windows. Forms.Button();

this.FirstNameT xt = new System.Windows. Forms.TextBox() ;

this.LastNameTe xt = new System.Windows. Forms.TextBox() ;

this.oleDbDataA dapter1 = new System.Data.Ole Db.OleDbDataAda pter();

this.oleDbDelet eCommand1 = new System.Data.Ole Db.OleDbCommand ();

this.oleDbConne ction1 = new System.Data.Ole Db.OleDbConnect ion();

this.oleDbInser tCommand1 = new System.Data.Ole Db.OleDbCommand ();

this.oleDbSelec tCommand1 = new System.Data.Ole Db.OleDbCommand ();

this.oleDbUpdat eCommand1 = new System.Data.Ole Db.OleDbCommand ();

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

this.FirstButto n = new System.Windows. Forms.Button();

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

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

this.SearchButt on = new System.Windows. Forms.Button();

((System.Compon entModel.ISuppo rtInitialize)(t his.dataSet11)) .BeginInit();

this.SuspendLay out();

//

// FIRSTNAMELabel

//

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

this.FIRSTNAMEL abel.Name = "FIRSTNAMELabel ";

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

this.FIRSTNAMEL abel.TabIndex = 1;

this.FIRSTNAMEL abel.Text = "FIRST NAME";

//

// LastNameLabel

//

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

this.LastNameLa bel.Name = "LastNameLabel" ;

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

this.LastNameLa bel.TabIndex = 2;

this.LastNameLa bel.Text = "LAST NAME";

//

// ADDRESSLABEL

//

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

this.ADDRESSLAB EL.Name = "ADDRESSLAB EL";

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

this.ADDRESSLAB EL.TabIndex = 4;

this.ADDRESSLAB EL.Text = "ADDRESS";

//

// AddressText

//

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

this.AddressTex t.Font = new System.Drawing. Font("Microsoft Sans Serif", 12F,
System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.AddressTex t.Name = "AddressTex t";

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

this.AddressTex t.TabIndex = 5;

this.AddressTex t.Text = "";

//

// dataSet11

//

this.dataSet11. DataSetName = "DataSet1";

this.dataSet11. Locale = new System.Globaliz ation.CultureIn fo("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.D ataBindings.Add (new System.Windows. Forms.Binding(" Text",
this.dataSet11, "Table1.City")) ;

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

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

this.CityText.N ame = "CityText";

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

this.CityText.T abIndex = 7;

this.CityText.T ext = "";

//

// 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.Ad d(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.Po int,
((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.L ocation = new System.Drawing. Point(32, 272);

this.ZIPLABEL.N ame = "ZIPLABEL";

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

this.ZIPLABEL.T abIndex = 10;

this.ZIPLABEL.T ext = "ZIP CODE";

//

// ZipcodeText

//

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

this.ZipcodeTex t.Font = new System.Drawing. Font("Microsoft Sans Serif", 12F,
System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.ZipcodeTex t.Name = "ZipcodeTex t";

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

this.ZipcodeTex t.TabIndex = 11;

this.ZipcodeTex t.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.Ad d(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.Po int,
((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.HMPHONELAB EL.Location = new System.Drawing. Point(32, 344);

this.HMPHONELAB EL.Name = "HMPHONELAB EL";

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

this.HMPHONELAB EL.TabIndex = 14;

this.HMPHONELAB EL.Text = "HOME#";

//

// HomeNumberText

//

this.HomeNumber Text.DataBindin gs.Add(new
System.Windows. Forms.Binding(" Text", this.dataSet11, "Table1.Hom e Phone
#"));

this.HomeNumber Text.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.HomeNumber Text.Name = "HomeNumberText ";

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

this.HomeNumber Text.TabIndex = 15;

this.HomeNumber Text.Text = "";

//

// CELLPHONELabel

//

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

this.CELLPHONEL abel.Name = "CELLPHONELabel ";

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

this.CELLPHONEL abel.TabIndex = 16;

this.CELLPHONEL abel.Text = "CELLPHONE# ";

//

// CellphoneText

//

this.CellphoneT ext.DataBinding s.Add(new System.Windows. Forms.Binding(" Text",
this.dataSet11, "Table1.Cel l Phone #"));

this.CellphoneT ext.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.CellphoneT ext.Name = "CellphoneText" ;

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

this.CellphoneT ext.TabIndex = 17;

this.CellphoneT ext.Text = "";

//

// FORWARDButton

//

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

this.FORWARDBut ton.Name = "FORWARDButton" ;

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

this.FORWARDBut ton.TabIndex = 20;

this.FORWARDBut ton.Text = "&FORWARD";

this.FORWARDBut ton.Click += new
System.EventHan dler(this.FORWA RDButton_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.EventHan dler(this.ADDBu tton_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.EventHan dler(this.BackB utton_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.EventHan dler(this.Edit_ Click);

//

// DeleteButton

//

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

this.DeleteButt on.Name = "DeleteButt on";

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

this.DeleteButt on.TabIndex = 24;

this.DeleteButt on.Text = "&DELETE RECORD";

//

// FirstNameTxt

//

this.FirstNameT xt.DataBindings .Add(new System.Windows. Forms.Binding(" Text",
this.dataSet11, "Table1.Fir st name"));

this.FirstNameT xt.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.FirstNameT xt.Name = "FirstNameT xt";

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

this.FirstNameT xt.TabIndex = 0;

this.FirstNameT xt.Text = "";

//

// LastNameText

//

this.LastNameTe xt.DataBindings .Add(new System.Windows. Forms.Binding(" Text",
this.dataSet11, "Table1.Las t name"));

this.LastNameTe xt.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.LastNameTe xt.Name = "LastNameTe xt";

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

this.LastNameTe xt.TabIndex = 3;

this.LastNameTe xt.Text = "";

//

// oleDbDataAdapte r1

//

this.oleDbDataA dapter1.DeleteC ommand = this.oleDbDelet eCommand1;

this.oleDbDataA dapter1.InsertC ommand = this.oleDbInser tCommand1;

this.oleDbDataA dapter1.SelectC ommand = this.oleDbSelec tCommand1;

this.oleDbDataA dapter1.TableMa ppings.AddRange (new
System.Data.Com mon.DataTableMa pping[] {

new System.Data.Com mon.DataTableMa pping("Table", "Table1", new
System.Data.Com mon.DataColumnM apping[] {

new System.Data.Com mon.DataColumnM apping("Address ", "Address"),

new System.Data.Com mon.DataColumnM apping("Cell Phone #", "Cell Phone #"),

new System.Data.Com mon.DataColumnM apping("City", "City"),

new System.Data.Com mon.DataColumnM apping("E-Mail ID#", "E-Mail ID#"),

new System.Data.Com mon.DataColumnM apping("First name", "First name"),

new System.Data.Com mon.DataColumnM apping("Home Phone #", "Home Phone #"),

new System.Data.Com mon.DataColumnM apping("Id#", "Id#"),

new System.Data.Com mon.DataColumnM apping("Last name", "Last name"),

new System.Data.Com mon.DataColumnM apping("State", "State"),

new System.Data.Com mon.DataColumnM apping("Zip", "Zip")})});

this.oleDbDataA dapter1.UpdateC ommand = this.oleDbUpdat eCommand1;

//

// oleDbDeleteComm and1

//

this.oleDbDelet eCommand1.Comma ndText = @"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.oleDbDelet eCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Id _",
System.Data.Ole Db.OleDbType.In teger, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Id#", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p1",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

//

// oleDbConnection 1

//

this.oleDbConne ction1.Connecti onString = @"Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Database Password=;Data Source=""C:\ITF N2314\Project Two for
ITFN2314.mdb""; Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk
Transactions=1; Provider=""Micr osoft.Jet.OLEDB .4.0"";Jet OLEDB:System
database=;Jet OLEDB:SFP=False ;Extended Properties=;Mod e=Share Deny None;Jet
OLEDB:New Database Password=;Jet OLEDB:Create System Database=False; Jet
OLEDB:Don't Copy Locale on Compact=False;J et OLEDB:Compact Without Replica
Repair=False;Us er ID=Admin;Jet OLEDB:Encrypt Database=False" ;

this.oleDbConne ction1.InfoMess age += new
System.Data.Ole Db.OleDbInfoMes sageEventHandle r(this.oleDbCon nection1_InfoMe s
sage);

//

// oleDbInsertComm and1

//

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

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

this.oleDbInser tCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Address",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Address")) ;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Cell_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Cell Phone #"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("City",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "City"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("E_Mail_ID_" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "E-Mail ID#"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("First_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "First name"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Home_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Home Phone #"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Last_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Last name"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("State",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "State"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Zip",
System.Data.Ole Db.OleDbType.Va rWChar, 5, "Zip"));

//

// oleDbSelectComm and1

//

this.oleDbSelec tCommand1.Comma ndText = "SELECT Address, [Cell Phone #],
City, [E-Mail ID#], [First name], [Home Phone #]," +

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

this.oleDbSelec tCommand1.Conne ction = this.oleDbConne ction1;

//

// oleDbUpdateComm and1

//

this.oleDbUpdat eCommand1.Comma ndText = @"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.oleDbUpdat eCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Address",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Address")) ;

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Cell_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Cell Phone #"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("City",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "City"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("E_Mail_ID_" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "E-Mail ID#"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("First_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "First name"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Home_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Home Phone #"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Last_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Last name"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("State",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "State"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Zip",
System.Data.Ole Db.OleDbType.Va rWChar, 5, "Zip"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Id _",
System.Data.Ole Db.OleDbType.In teger, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Id#", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p1",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

//

// label1

//

this.label1.Fon t = new System.Drawing. Font("Monotype Corsiva", 15.75F,
((System.Drawin g.FontStyle)((S ystem.Drawing.F ontStyle.Bold |
System.Drawing. FontStyle.Itali c))), System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.label1.Nam e = "label1";

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

this.label1.Tab Index = 25;

this.label1.Tex t = "CONTACT LIST";

//

// FirstButton

//

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

this.FirstButto n.Name = "FirstButto n";

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

this.FirstButto n.TabIndex = 26;

this.FirstButto n.Text = "&FIRST";

this.FirstButto n.Click += new System.EventHan dler(this.First Button_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.EventHan dler(this.LastB utton_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.EventHan dler(this.SaveB utton_Click);

//

// SearchButton

//

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

this.SearchButt on.Name = "SearchButt on";

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

this.SearchButt on.TabIndex = 29;

this.SearchButt on.Text = "&SEARCH";

//

// Form1

//

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

this.BackColor = System.Drawing. Color.LightSkyB lue;

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

this.Controls.A dd(this.SearchB utton);

this.Controls.A dd(this.SaveBut ton);

this.Controls.A dd(this.LastBut ton);

this.Controls.A dd(this.FirstBu tton);

this.Controls.A dd(this.label1) ;

this.Controls.A dd(this.DeleteB utton);

this.Controls.A dd(this.EditBut ton);

this.Controls.A dd(this.BackBut ton);

this.Controls.A dd(this.ADDButt on);

this.Controls.A dd(this.FORWARD Button);

this.Controls.A dd(this.Cellpho neText);

this.Controls.A dd(this.HomeNum berText);

this.Controls.A dd(this.EmailTe xt);

this.Controls.A dd(this.Zipcode Text);

this.Controls.A dd(this.StateTe xt);

this.Controls.A dd(this.CityTex t);

this.Controls.A dd(this.Address Text);

this.Controls.A dd(this.FirstNa meTxt);

this.Controls.A dd(this.LastNam eText);

this.Controls.A dd(this.CELLPHO NELabel);

this.Controls.A dd(this.HMPHONE LABEL);

this.Controls.A dd(this.EMAILLA BEL);

this.Controls.A dd(this.ZIPLABE L);

this.Controls.A dd(this.STATELA BEL);

this.Controls.A dd(this.CITYLAB EL);

this.Controls.A dd(this.ADDRESS LABEL);

this.Controls.A dd(this.LastNam eLabel);

this.Controls.A dd(this.FIRSTNA MELabel);

this.ForeColor = System.Drawing. Color.MediumBlu e;

this.Name = "Form1";

this.Text = "Project Two";

this.Load += new System.EventHan dler(this.Form1 _Load);

((System.Compon entModel.ISuppo rtInitialize)(t his.dataSet11)) .EndInit();

this.ResumeLayo ut(false);

}

#endregion

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main()

{

Application.Run (new Form1());

}

private void Form1_Load(obje ct sender, System.EventArg s e)

{

oleDbConnection 1.Open();

oleDbDataAdapte r1.Fill(dataSet 11);

oleDbConnection 1.Close();

}

private void FORWARDButton_C lick(object sender, System.EventArg s e)

{

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

}

private void BackButton_Clic k(object sender, System.EventArg s e)

{

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


}

private void oleDbConnection 1_InfoMessage(o bject sender,
System.Data.Ole Db.OleDbInfoMes sageEventArgs e)

{
}

private void ADDButton_Click (object sender, System.EventArg s e)

{

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

ADDButton.Visib le = false;

SaveButton.Visi ble = true;

}
private void SaveButton_Clic k(object sender, System.EventArg s e)

{

ADDButton.Visib le = true;

SaveButton.Visi ble = false;

System.Data.Ole Db.OleDbCommand cmd;

cmd = new System.Data.Ole Db.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,HomeN umberText,Cellp honeText) ");

oleDbConnection 1.Open();

oleDbDataAdapte r1.Update(dataS et11);

oleDbConnection 1.Close();

}

private void Edit_Click(obje ct sender, System.EventArg s e)

{
}

private void LastButton_Clic k(object sender, System.EventArg s e)

{

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

}

private void FirstButton_Cli ck(object sender, System.EventArg s e)

{

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

}


}


}
Nov 16 '05 #1
1 2923
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.HasCha nges) 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****@bellsou th.net> wrote in message
news:ue******** ***********@big news2.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.Collecti ons;

using System.Componen tModel;

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.Ole Db.OleDbDataAda pter oleDbDataAdapte r1;

private System.Data.Ole Db.OleDbConnect ion oleDbConnection 1;

private System.Data.Ole Db.OleDbCommand oleDbSelectComm and1;

private System.Data.Ole Db.OleDbCommand oleDbInsertComm and1;

private System.Data.Ole Db.OleDbCommand oleDbUpdateComm and1;

private System.Data.Ole Db.OleDbCommand oleDbDeleteComm and1;

private Project_Two.Dat aSet1 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.Componen tModel.Containe r components = null;

public Form1()

{

//

// Required for Windows Form Designer support

//

InitializeCompo nent();

//

// TODO: Add any constructor code after InitializeCompo nent call

//

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Disp ose();

}

}

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 InitializeCompo nent()

{

this.FIRSTNAMEL abel = new System.Windows. Forms.Label();

this.LastNameLa bel = new System.Windows. Forms.Label();

this.ADDRESSLAB EL = new System.Windows. Forms.Label();

this.AddressTex t = new System.Windows. Forms.TextBox() ;

this.dataSet11 = new Project_Two.Dat aSet1();

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.ZipcodeTex t = new System.Windows. Forms.TextBox() ;

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

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

this.HMPHONELAB EL = new System.Windows. Forms.Label();

this.HomeNumber Text = new System.Windows. Forms.TextBox() ;

this.CELLPHONEL abel = new System.Windows. Forms.Label();

this.CellphoneT ext = new System.Windows. Forms.TextBox() ;

this.FORWARDBut ton = 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.DeleteButt on = new System.Windows. Forms.Button();

this.FirstNameT xt = new System.Windows. Forms.TextBox() ;

this.LastNameTe xt = new System.Windows. Forms.TextBox() ;

this.oleDbDataA dapter1 = new System.Data.Ole Db.OleDbDataAda pter();

this.oleDbDelet eCommand1 = new System.Data.Ole Db.OleDbCommand ();

this.oleDbConne ction1 = new System.Data.Ole Db.OleDbConnect ion();

this.oleDbInser tCommand1 = new System.Data.Ole Db.OleDbCommand ();

this.oleDbSelec tCommand1 = new System.Data.Ole Db.OleDbCommand ();

this.oleDbUpdat eCommand1 = new System.Data.Ole Db.OleDbCommand ();

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

this.FirstButto n = new System.Windows. Forms.Button();

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

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

this.SearchButt on = new System.Windows. Forms.Button();

((System.Compon entModel.ISuppo rtInitialize)(t his.dataSet11)) .BeginInit();

this.SuspendLay out();

//

// FIRSTNAMELabel

//

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

this.FIRSTNAMEL abel.Name = "FIRSTNAMELabel ";

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

this.FIRSTNAMEL abel.TabIndex = 1;

this.FIRSTNAMEL abel.Text = "FIRST NAME";

//

// LastNameLabel

//

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

this.LastNameLa bel.Name = "LastNameLabel" ;

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

this.LastNameLa bel.TabIndex = 2;

this.LastNameLa bel.Text = "LAST NAME";

//

// ADDRESSLABEL

//

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

this.ADDRESSLAB EL.Name = "ADDRESSLAB EL";

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

this.ADDRESSLAB EL.TabIndex = 4;

this.ADDRESSLAB EL.Text = "ADDRESS";

//

// AddressText

//

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

this.AddressTex t.Font = new System.Drawing. Font("Microsoft Sans Serif", 12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.AddressTex t.Name = "AddressTex t";

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

this.AddressTex t.TabIndex = 5;

this.AddressTex t.Text = "";

//

// dataSet11

//

this.dataSet11. DataSetName = "DataSet1";

this.dataSet11. Locale = new System.Globaliz ation.CultureIn fo("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.D ataBindings.Add (new System.Windows. Forms.Binding(" Text",
this.dataSet11, "Table1.City")) ;

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

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

this.CityText.N ame = "CityText";

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

this.CityText.T abIndex = 7;

this.CityText.T ext = "";

//

// 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.Ad d(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.Po int,
((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.L ocation = new System.Drawing. Point(32, 272);

this.ZIPLABEL.N ame = "ZIPLABEL";

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

this.ZIPLABEL.T abIndex = 10;

this.ZIPLABEL.T ext = "ZIP CODE";

//

// ZipcodeText

//

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

this.ZipcodeTex t.Font = new System.Drawing. Font("Microsoft Sans Serif", 12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.ZipcodeTex t.Name = "ZipcodeTex t";

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

this.ZipcodeTex t.TabIndex = 11;

this.ZipcodeTex t.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.Ad d(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.Po int,
((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.HMPHONELAB EL.Location = new System.Drawing. Point(32, 344);

this.HMPHONELAB EL.Name = "HMPHONELAB EL";

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

this.HMPHONELAB EL.TabIndex = 14;

this.HMPHONELAB EL.Text = "HOME#";

//

// HomeNumberText

//

this.HomeNumber Text.DataBindin gs.Add(new
System.Windows. Forms.Binding(" Text", this.dataSet11, "Table1.Hom e Phone
#"));

this.HomeNumber Text.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.HomeNumber Text.Name = "HomeNumberText ";

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

this.HomeNumber Text.TabIndex = 15;

this.HomeNumber Text.Text = "";

//

// CELLPHONELabel

//

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

this.CELLPHONEL abel.Name = "CELLPHONELabel ";

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

this.CELLPHONEL abel.TabIndex = 16;

this.CELLPHONEL abel.Text = "CELLPHONE# ";

//

// CellphoneText

//

this.CellphoneT ext.DataBinding s.Add(new System.Windows. Forms.Binding(" Text", this.dataSet11, "Table1.Cel l Phone #"));

this.CellphoneT ext.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.CellphoneT ext.Name = "CellphoneText" ;

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

this.CellphoneT ext.TabIndex = 17;

this.CellphoneT ext.Text = "";

//

// FORWARDButton

//

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

this.FORWARDBut ton.Name = "FORWARDButton" ;

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

this.FORWARDBut ton.TabIndex = 20;

this.FORWARDBut ton.Text = "&FORWARD";

this.FORWARDBut ton.Click += new
System.EventHan dler(this.FORWA RDButton_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.EventHan dler(this.ADDBu tton_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.EventHan dler(this.BackB utton_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.EventHan dler(this.Edit_ Click);

//

// DeleteButton

//

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

this.DeleteButt on.Name = "DeleteButt on";

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

this.DeleteButt on.TabIndex = 24;

this.DeleteButt on.Text = "&DELETE RECORD";

//

// FirstNameTxt

//

this.FirstNameT xt.DataBindings .Add(new System.Windows. Forms.Binding(" Text", this.dataSet11, "Table1.Fir st name"));

this.FirstNameT xt.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.FirstNameT xt.Name = "FirstNameT xt";

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

this.FirstNameT xt.TabIndex = 0;

this.FirstNameT xt.Text = "";

//

// LastNameText

//

this.LastNameTe xt.DataBindings .Add(new System.Windows. Forms.Binding(" Text", this.dataSet11, "Table1.Las t name"));

this.LastNameTe xt.Font = new System.Drawing. Font("Microsoft Sans Serif",
12F, System.Drawing. FontStyle.Bold, System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.LastNameTe xt.Name = "LastNameTe xt";

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

this.LastNameTe xt.TabIndex = 3;

this.LastNameTe xt.Text = "";

//

// oleDbDataAdapte r1

//

this.oleDbDataA dapter1.DeleteC ommand = this.oleDbDelet eCommand1;

this.oleDbDataA dapter1.InsertC ommand = this.oleDbInser tCommand1;

this.oleDbDataA dapter1.SelectC ommand = this.oleDbSelec tCommand1;

this.oleDbDataA dapter1.TableMa ppings.AddRange (new
System.Data.Com mon.DataTableMa pping[] {

new System.Data.Com mon.DataTableMa pping("Table", "Table1", new
System.Data.Com mon.DataColumnM apping[] {

new System.Data.Com mon.DataColumnM apping("Address ", "Address"),

new System.Data.Com mon.DataColumnM apping("Cell Phone #", "Cell Phone #"),

new System.Data.Com mon.DataColumnM apping("City", "City"),

new System.Data.Com mon.DataColumnM apping("E-Mail ID#", "E-Mail ID#"),

new System.Data.Com mon.DataColumnM apping("First name", "First name"),

new System.Data.Com mon.DataColumnM apping("Home Phone #", "Home Phone #"),

new System.Data.Com mon.DataColumnM apping("Id#", "Id#"),

new System.Data.Com mon.DataColumnM apping("Last name", "Last name"),

new System.Data.Com mon.DataColumnM apping("State", "State"),

new System.Data.Com mon.DataColumnM apping("Zip", "Zip")})});

this.oleDbDataA dapter1.UpdateC ommand = this.oleDbUpdat eCommand1;

//

// oleDbDeleteComm and1

//

this.oleDbDelet eCommand1.Comma ndText = @"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.oleDbDelet eCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Id _",
System.Data.Ole Db.OleDbType.In teger, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Id#", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));
this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));
this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbDelet eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p1",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

//

// oleDbConnection 1

//

this.oleDbConne ction1.Connecti onString = @"Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet
OLEDB:Database Password=;Data Source=""C:\ITF N2314\Project Two for
ITFN2314.mdb""; Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk
Transactions=1; Provider=""Micr osoft.Jet.OLEDB .4.0"";Jet OLEDB:System
database=;Jet OLEDB:SFP=False ;Extended Properties=;Mod e=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False; Jet
OLEDB:Don't Copy Locale on Compact=False;J et OLEDB:Compact Without Replica
Repair=False;Us er ID=Admin;Jet OLEDB:Encrypt Database=False" ;

this.oleDbConne ction1.InfoMess age += new
System.Data.Ole Db.OleDbInfoMes sageEventHandle r(this.oleDbCon nection1_InfoMe s sage);

//

// oleDbInsertComm and1

//

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

"me Phone #], [Last name], State, Zip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInser tCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Address",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Address")) ;

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Cell_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Cell Phone #"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("City",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "City"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("E_Mail_ID_" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "E-Mail ID#"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("First_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "First name"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Home_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Home Phone #"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Last_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Last name"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("State",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "State"));

this.oleDbInser tCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Zip",
System.Data.Ole Db.OleDbType.Va rWChar, 5, "Zip"));

//

// oleDbSelectComm and1

//

this.oleDbSelec tCommand1.Comma ndText = "SELECT Address, [Cell Phone #],
City, [E-Mail ID#], [First name], [Home Phone #]," +

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

this.oleDbSelec tCommand1.Conne ction = this.oleDbConne ction1;

//

// oleDbUpdateComm and1

//

this.oleDbUpdat eCommand1.Comma ndText = @"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.oleDbUpdat eCommand1.Conne ction = this.oleDbConne ction1;

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Address",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Address")) ;

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Cell_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Cell Phone #"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("City",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "City"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("E_Mail_ID_" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "E-Mail ID#"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("First_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "First name"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Home_Phone_ _",
System.Data.Ole Db.OleDbType.Va rWChar, 12, "Home Phone #"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Last_name" ,
System.Data.Ole Db.OleDbType.Va rWChar, 50, "Last name"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("State",
System.Data.Ole Db.OleDbType.Va rWChar, 50, "State"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Zip",
System.Data.Ole Db.OleDbType.Va rWChar, 5, "Zip"));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Id _",
System.Data.Ole Db.OleDbType.In teger, 0,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Id#", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));
this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ad dress1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Address", System.Data.Dat aRowVersion.Ori ginal, null));
this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ce ll_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Cell Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ci ty1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "City", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_E_ Mail_ID_1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "E-Mail ID#", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Fi rst_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "First name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Ho me_Phone__1",
System.Data.Ole Db.OleDbType.Va rWChar, 12,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Home Phone #", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_La st_name1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Last name", System.Data.Dat aRowVersion.Ori ginal,
null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_St ate1",
System.Data.Ole Db.OleDbType.Va rWChar, 50,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "State", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

this.oleDbUpdat eCommand1.Param eters.Add(new
System.Data.Ole Db.OleDbParamet er("Original_Zi p1",
System.Data.Ole Db.OleDbType.Va rWChar, 5,
System.Data.Par ameterDirection .Input, false, ((System.Byte)( 0)),
((System.Byte)( 0)), "Zip", System.Data.Dat aRowVersion.Ori ginal, null));

//

// label1

//

this.label1.Fon t = new System.Drawing. Font("Monotype Corsiva", 15.75F,
((System.Drawin g.FontStyle)((S ystem.Drawing.F ontStyle.Bold |
System.Drawing. FontStyle.Itali c))), System.Drawing. GraphicsUnit.Po int,
((System.Byte)( 0)));

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

this.label1.Nam e = "label1";

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

this.label1.Tab Index = 25;

this.label1.Tex t = "CONTACT LIST";

//

// FirstButton

//

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

this.FirstButto n.Name = "FirstButto n";

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

this.FirstButto n.TabIndex = 26;

this.FirstButto n.Text = "&FIRST";

this.FirstButto n.Click += new System.EventHan dler(this.First Button_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.EventHan dler(this.LastB utton_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.EventHan dler(this.SaveB utton_Click);

//

// SearchButton

//

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

this.SearchButt on.Name = "SearchButt on";

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

this.SearchButt on.TabIndex = 29;

this.SearchButt on.Text = "&SEARCH";

//

// Form1

//

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

this.BackColor = System.Drawing. Color.LightSkyB lue;

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

this.Controls.A dd(this.SearchB utton);

this.Controls.A dd(this.SaveBut ton);

this.Controls.A dd(this.LastBut ton);

this.Controls.A dd(this.FirstBu tton);

this.Controls.A dd(this.label1) ;

this.Controls.A dd(this.DeleteB utton);

this.Controls.A dd(this.EditBut ton);

this.Controls.A dd(this.BackBut ton);

this.Controls.A dd(this.ADDButt on);

this.Controls.A dd(this.FORWARD Button);

this.Controls.A dd(this.Cellpho neText);

this.Controls.A dd(this.HomeNum berText);

this.Controls.A dd(this.EmailTe xt);

this.Controls.A dd(this.Zipcode Text);

this.Controls.A dd(this.StateTe xt);

this.Controls.A dd(this.CityTex t);

this.Controls.A dd(this.Address Text);

this.Controls.A dd(this.FirstNa meTxt);

this.Controls.A dd(this.LastNam eText);

this.Controls.A dd(this.CELLPHO NELabel);

this.Controls.A dd(this.HMPHONE LABEL);

this.Controls.A dd(this.EMAILLA BEL);

this.Controls.A dd(this.ZIPLABE L);

this.Controls.A dd(this.STATELA BEL);

this.Controls.A dd(this.CITYLAB EL);

this.Controls.A dd(this.ADDRESS LABEL);

this.Controls.A dd(this.LastNam eLabel);

this.Controls.A dd(this.FIRSTNA MELabel);

this.ForeColor = System.Drawing. Color.MediumBlu e;

this.Name = "Form1";

this.Text = "Project Two";

this.Load += new System.EventHan dler(this.Form1 _Load);

((System.Compon entModel.ISuppo rtInitialize)(t his.dataSet11)) .EndInit();

this.ResumeLayo ut(false);

}

#endregion

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main()

{

Application.Run (new Form1());

}

private void Form1_Load(obje ct sender, System.EventArg s e)

{

oleDbConnection 1.Open();

oleDbDataAdapte r1.Fill(dataSet 11);

oleDbConnection 1.Close();

}

private void FORWARDButton_C lick(object sender, System.EventArg s e)

{

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

}

private void BackButton_Clic k(object sender, System.EventArg s e)

{

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


}

private void oleDbConnection 1_InfoMessage(o bject sender,
System.Data.Ole Db.OleDbInfoMes sageEventArgs e)

{
}

private void ADDButton_Click (object sender, System.EventArg s e)

{

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

ADDButton.Visib le = false;

SaveButton.Visi ble = true;

}
private void SaveButton_Clic k(object sender, System.EventArg s e)

{

ADDButton.Visib le = true;

SaveButton.Visi ble = false;

System.Data.Ole Db.OleDbCommand cmd;

cmd = new System.Data.Ole Db.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,HomeN umberText,Cellp honeText) ");

oleDbConnection 1.Open();

oleDbDataAdapte r1.Update(dataS et11);

oleDbConnection 1.Close();

}

private void Edit_Click(obje ct sender, System.EventArg s e)

{
}

private void LastButton_Clic k(object sender, System.EventArg s e)

{

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

}

private void FirstButton_Cli ck(object sender, System.EventArg s e)

{

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

}


}


}

Nov 16 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
2298
by: deancoo | last post by:
I have gotten into the habit of often using copy along with an insert iterator. There are scenarios where I process quite a lot of data this way. Can someone give me a general feel as to how much of a performance hit I'm taking using this technique versus using 'copy' to copy directly into a container with elements in place? Thanks, d
0
4492
by: ImraneA | last post by:
Hi there I had pleasure of upsizing Access v97 db to Access v2K/SQL 2K. Wish to provide some knowledge gained back to community - hopefully help others. 1.Question how do you test stored procedure from SQL Server vs MS Access point of view ?
8
9243
by: Bri | last post by:
Greetings, I'm having a very strange problem in an AC97 MDB with ODBC Linked tables to SQL Server 7. The table has an Identity field and a Timestamp field. The problem is that when a new record is entered, either from a form or from the table view of the table, when the record gets saved it immediately displays #DELETED# in all of the fields. However, if I close the form or table view and reopen the record has in fact been inserted. The...
8
6292
by: Carl | last post by:
Hi, I hope someone can share some of their professional advice and help me out with my embarissing problem concerning an Access INSERT query. I have never attempted to create a table with one-to-one relationship but on this occasion I must keep username/password details within a seperate table. Here's the basic specs and database schema: -------------------------------------------
2
3208
by: Geoffrey KRETZ | last post by:
Hello, I'm wondering if the following behaviour is the correct one for PostGreSQL (7.4 on UNIX). I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching the following request : INSERT INTO temp_tab VALUES (1,2,3)
3
2310
by: MP | last post by:
Hi Posted this several hours ago to another ng but it never showed up thought i'd try here. using vb6, ado, .mdb, jet4.0, no access given table tblJob with field JobNumber text(10) 'The example I had to go by 'INSERT INTO tblCustomers (CustomerID, , )
6
3467
by: rn5a | last post by:
During registration, users are supposed to enter the following details: First Name, Last Name, EMail, UserName, Password, Confirm Password, Address, City, State, Country, Zip & Phone Number. I am using MS-Access 2000 database table for this app. Note that the datatype of all the fields mentioned above are Text. Apart from the above columns, there's another column in the DB table named 'RegDateTime' whose datatype is Date/Time which is...
1
3181
by: Zuggy | last post by:
I'm trying to create a registration/login script using Access 2003. I'm using ADOdb to connect through ODBC. <?php // Connects to your Database include('adodb/adodb.inc.php'); # load code common to ADOdb $db = &ADONewConnection('access'); # create a connection $db->PConnect('evdb'); # connect to MS-Access, evdb DSN $db->debug = true; //This code runs if the form has been submitted
5
4460
by: DonnaL | last post by:
I'm using Access 2000, but this question likely pertains to any version of Access. Simply put, is there a programmatic way of inserting a new Query in whatever master system table stores these (maybe QueryDefs?), so I wouldn't have to use the IDE and open Access to do it? Here's more information if that helps: I can open Access itself and create a Query. I can save it and name it something meaningful. I can then execute that query just by...
2
6109
by: yeap | last post by:
Hi All, I can't insert java variable into ms access database. I'm using odbc connection to ms access. Below are my coding. try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set the connection for database path String Database_Path = "E:/Segi/Project/Coding/Car_Park_Storage.mdb";
0
8959
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8784
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9248
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6747
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4558
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4821
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3270
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2738
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2187
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.