addressbook.cs

this is a good book for the visual c#

          // 
          // oleDbConnection1
          // 
          this.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\Users\\TA\\Desktop\\flash\\C#\\C# How" +
              " To Program - & Examples - Deitel\\Examples\\ch19\\Fig19_29\\AddressBook\\AddressBook" +
              ".mdb\"";
          // 
          // oleDbInsertCommand2
          // 
          this.oleDbInsertCommand2.CommandText = "INSERT INTO addresses(address, city, country, emailaddress, faxnumber, firstname," +
              " homephone, lastname, postalcode, stateorprovince) VALUES (?, ?, ?, ?, ?, ?, ?, " +
              "?, ?, ?)";
          this.oleDbInsertCommand2.Connection = this.oleDbConnection1;
          this.oleDbInsertCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.VarWChar, 50, "address"),
            new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.VarWChar, 50, "city"),
            new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.VarWChar, 50, "country"),
            new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.VarWChar, 50, "emailaddress"),
            new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.VarWChar, 50, "faxnumber"),
            new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.VarWChar, 50, "firstname"),
            new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.VarWChar, 50, "homephone"),
            new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.VarWChar, 50, "lastname"),
            new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.VarWChar, 50, "postalcode"),
            new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.VarWChar, 50, "stateorprovince")});
          // 
          // oleDbSelectCommand2
          // 
          this.oleDbSelectCommand2.CommandText = "SELECT address, city, country, emailaddress, faxnumber, firstname, homephone, id," +
              " lastname, postalcode, stateorprovince FROM addresses";
          this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
          // 
          // oleDbUpdateCommand2
          // 
          this.oleDbUpdateCommand2.CommandText = resources.GetString("oleDbUpdateCommand2.CommandText");
          this.oleDbUpdateCommand2.Connection = this.oleDbConnection1;
          this.oleDbUpdateCommand2.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.VarWChar, 50, "address"),
            new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.VarWChar, 50, "city"),
            new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.VarWChar, 50, "country"),
            new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.VarWChar, 50, "emailaddress"),
            new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.VarWChar, 50, "faxnumber"),
            new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.VarWChar, 50, "firstname"),
            new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.VarWChar, 50, "homephone"),
            new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.VarWChar, 50, "lastname"),
            new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.VarWChar, 50, "postalcode"),
            new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.VarWChar, 50, "stateorprovince"),
            new System.Data.OleDb.OleDbParameter("Original_id", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_address", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_address1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_city", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "city", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_city1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "city", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_country", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "country", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_country1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "country", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_emailaddress", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "emailaddress", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_emailaddress1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "emailaddress", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_faxnumber", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "faxnumber", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_faxnumber1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "faxnumber", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_firstname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "firstname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_firstname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "firstname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_homephone", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "homephone", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_homephone1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "homephone", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_lastname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "lastname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_lastname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "lastname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_postalcode", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "postalcode", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_postalcode1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "postalcode", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_stateorprovince", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "stateorprovince", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_stateorprovince1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "stateorprovince", System.Data.DataRowVersion.Original, null)});
          // 
          // oleDbDeleteCommand1
          // 
          this.oleDbDeleteCommand1.CommandText = resources.GetString("oleDbDeleteCommand1.CommandText");
          this.oleDbDeleteCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "city", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "country", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "emailaddress", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "faxnumber", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "firstname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "homephone", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "lastname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "postalcode", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "stateorprovince", System.Data.DataRowVersion.Original, null)});
          // 
          // oleDbInsertCommand1
          // 
          this.oleDbInsertCommand1.CommandText = resources.GetString("oleDbInsertCommand1.CommandText");
          this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.Char, 50, "address"),
            new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.Char, 50, "city"),
            new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.Char, 50, "country"),
            new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.Char, 50, "emailaddress"),
            new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.Char, 50, "faxnumber"),
            new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.Char, 50, "firstname"),
            new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.Char, 50, "homephone"),
            new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Current, null),
            new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.Char, 50, "lastname"),
            new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.Char, 50, "postalcode"),
            new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.Char, 50, "stateorprovince"),
            new System.Data.OleDb.OleDbParameter("Select_id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Current, null)});
          // 
          // oleDbSelectCommand1
          // 
          this.oleDbSelectCommand1.CommandText = "SELECT address, city, country, emailaddress, faxnumber, firstname, homephone, id," +
              " lastname, postalcode, stateorprovince FROM addresses";
          // 
          // oleDbUpdateCommand1
          // 
          this.oleDbUpdateCommand1.CommandText = resources.GetString("oleDbUpdateCommand1.CommandText");
          this.oleDbUpdateCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] {
            new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.Char, 50, "address"),
            new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.Char, 50, "city"),
            new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.Char, 50, "country"),
            new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.Char, 50, "emailaddress"),
            new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.Char, 50, "faxnumber"),
            new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.Char, 50, "firstname"),
            new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.Char, 50, "homephone"),
            new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Current, null),
            new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.Char, 50, "lastname"),
            new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.Char, 50, "postalcode"),
            new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.Char, 50, "stateorprovince"),
            new System.Data.OleDb.OleDbParameter("Original_id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_address", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_city", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "city", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_country", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "country", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_emailaddress", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "emailaddress", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_faxnumber", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "faxnumber", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_firstname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "firstname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_homephone", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "homephone", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_lastname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "lastname", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_postalcode", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "postalcode", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Original_stateorprovince", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "stateorprovince", System.Data.DataRowVersion.Original, null),
            new System.Data.OleDb.OleDbParameter("Select_id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "id", System.Data.DataRowVersion.Current, null)});
          // 
          // AddressBook
          // 
          this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
          this.ClientSize = new System.Drawing.Size(384, 533);
          this.Controls.Add(this.statusTextBox);
          this.Controls.Add(this.faxLabel);
          this.Controls.Add(this.homeLabel);
          this.Controls.Add(this.emailLabel);
          this.Controls.Add(this.countryLabel);
          this.Controls.Add(this.postalLabel);
          this.Controls.Add(this.stateLabel);
          this.Controls.Add(this.cityLabel);
          this.Controls.Add(this.addressLabel);
          this.Controls.Add(this.lastLabel);
          this.Controls.Add(this.firstLabel);
          this.Controls.Add(this.idLabel);
          this.Controls.Add(this.faxTextBox);
          this.Controls.Add(this.homeTextBox);
          this.Controls.Add(this.emailTextBox);
          this.Controls.Add(this.countryTextBox);
          this.Controls.Add(this.postalTextBox);
          this.Controls.Add(this.stateTextBox);
          this.Controls.Add(this.cityTextBox);
          this.Controls.Add(this.addressTextBox);
          this.Controls.Add(this.lastTextBox);
          this.Controls.Add(this.firstTextBox);
          this.Controls.Add(this.idTextBox);
          this.Controls.Add(this.helpButton);
          this.Controls.Add(this.clearButton);
          this.Controls.Add(this.updateButton);
          this.Controls.Add(this.addButton);
          this.Controls.Add(this.findButton);
          this.Name = "AddressBook";
          this.Text = "AddressBook";
          ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
          this.ResumeLayout(false);
          this.PerformLayout();

      } // end of InitializeComponent
		#endregion

      /// <summary>
      /// The main entry point for the application.
      /// </summary>
      [STAThread]
      static void Main() 
      {
         Application.Run(new AddressBook());
      }

      private void findButton_Click(object sender, System.EventArgs e)
      {
         try
         {
            if ( lastTextBox.Text != "" )
            {  
               // clear the DataSet from the last operation
               dataSet1.Clear();

               // create SQL query to find the contact with the
               // specified last name
               oleDbDataAdapter1.SelectCommand.CommandText = 
                  "SELECT * FROM addresses WHERE lastname = '" +
                  lastTextBox.Text + "'";

               // fill dataSet1 with the rows resulting from the
               // query
               oleDbDataAdapter1.Fill( dataSet1 );

               // display information
               Display( dataSet1 );
               statusTextBox.Text += "\r\nQuery successful\r\n";
            }
         
            else
               lastTextBox.Text = 
                  "Enter last name here then press Find";