addressbook.cs

this is a good book for the visual c#

         this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "homephone", System.Data.DataRowVersion.Original, null));
         this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "lastname", System.Data.DataRowVersion.Original, null));
         this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "postalcode", System.Data.DataRowVersion.Original, null));
         this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "stateorprovince", System.Data.DataRowVersion.Original, null));
         // 
         // oleDbInsertCommand1
         // 
         this.oleDbInsertCommand1.CommandText = @"INSERT INTO addresses(address, city, country, emailaddress, faxnumber, firstname, homephone, id, lastname, postalcode, stateorprovince) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); SELECT address, city, country, emailaddress, faxnumber, firstname, homephone, id, lastname, postalcode, stateorprovince FROM addresses WHERE (id = ?)";
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.Char, 50, "address"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.Char, 50, "city"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.Char, 50, "country"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.Char, 50, "emailaddress"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.Char, 50, "faxnumber"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.Char, 50, "firstname"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.Char, 50, "homephone"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Current, null));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.Char, 50, "lastname"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.Char, 50, "postalcode"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.Char, 50, "stateorprovince"));
         this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Select_id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.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 = @"UPDATE addresses SET address = ?, city = ?, country = ?, emailaddress = ?, faxnumber = ?, firstname = ?, homephone = ?, id = ?, lastname = ?, postalcode = ?, stateorprovince = ? WHERE (id = ?) AND (address = ?) AND (city = ?) AND (country = ?) AND (emailaddress = ?) AND (faxnumber = ?) AND (firstname = ?) AND (homephone = ?) AND (lastname = ?) AND (postalcode = ?) AND (stateorprovince = ?); SELECT address, city, country, emailaddress, faxnumber, firstname, homephone, id, lastname, postalcode, stateorprovince FROM addresses WHERE (id = ?)";
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.Char, 50, "address"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.Char, 50, "city"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("country", System.Data.OleDb.OleDbType.Char, 50, "country"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("emailaddress", System.Data.OleDb.OleDbType.Char, 50, "emailaddress"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("faxnumber", System.Data.OleDb.OleDbType.Char, 50, "faxnumber"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("firstname", System.Data.OleDb.OleDbType.Char, 50, "firstname"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("homephone", System.Data.OleDb.OleDbType.Char, 50, "homephone"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Current, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("lastname", System.Data.OleDb.OleDbType.Char, 50, "lastname"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("postalcode", System.Data.OleDb.OleDbType.Char, 50, "postalcode"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("stateorprovince", System.Data.OleDb.OleDbType.Char, 50, "stateorprovince"));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_address", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "address", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_city", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "city", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_country", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "country", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_emailaddress", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "emailaddress", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_faxnumber", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "faxnumber", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_firstname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "firstname", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_homephone", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "homephone", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_lastname", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "lastname", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_postalcode", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "postalcode", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_stateorprovince", System.Data.OleDb.OleDbType.Char, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "stateorprovince", System.Data.DataRowVersion.Original, null));
         this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Select_id", System.Data.OleDb.OleDbType.Numeric, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.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.AddRange(new System.Windows.Forms.Control[] {
                                                                      this.statusTextBox,
                                                                      this.faxLabel,
                                                                      this.homeLabel,
                                                                      this.emailLabel,
                                                                      this.countryLabel,
                                                                      this.postalLabel,
                                                                      this.stateLabel,
                                                                      this.cityLabel,
                                                                      this.addressLabel,
                                                                      this.lastLabel,
                                                                      this.firstLabel,
                                                                      this.idLabel,
                                                                      this.faxTextBox,
                                                                      this.homeTextBox,
                                                                      this.emailTextBox,
                                                                      this.countryTextBox,
                                                                      this.postalTextBox,
                                                                      this.stateTextBox,
                                                                      this.cityTextBox,
                                                                      this.addressTextBox,
                                                                      this.lastTextBox,
                                                                      this.firstTextBox,
                                                                      this.idTextBox,
                                                                      this.helpButton,
                                                                      this.clearButton,
                                                                      this.updateButton,
                                                                      this.addButton,
                                                                      this.findButton});
         this.Name = "AddressBook";
         this.Text = "AddressBook";
         ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
         this.ResumeLayout(false);

      } // 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";
         }
      
         catch ( System.Data.OleDb.OleDbException oleException )
         {
            Console.WriteLine( oleException.StackTrace );
            statusTextBox.Text += oleException.ToString();
         }
      
         catch ( InvalidOperationException invalidException )
         {
            MessageBox.Show( invalidException.Message );
         }
      
      }  // end of findButton_Click

      private void addButton_Click(object sender, System.EventArgs e)
      {
         try
         {
            if ( lastTextBox.Text != "" && firstTextBox.Text != "" )
            {
               // create the SQL query to insert a row
               oleDbDataAdapter1.InsertCommand.CommandText = 
                  "INSERT INTO addresses (" +
                  "firstname, lastname, address, city, " +
                  "stateorprovince, postalcode, country, " +
                  "emailaddress, homephone, faxnumber" + 
                  ") VALUES ('" +
                  firstTextBox.Text + "', '" +
                  lastTextBox.Text + "', '" +
                  addressTextBox.Text + "', '" +
                  cityTextBox.Text + "', '" +
                  stateTextBox.Text + "', '" +
                  postalTextBox.Text + "', '" +
                  countryTextBox.Text + "', '" +
                  emailTextBox.Text + "', '" +
                  homeTextBox.Text + "', '" +
                  faxTextBox.Text + "')";