View difference between Paste ID: u3hGnvVi and P6J1WATS

 using System;
 using System.Collections.Generic;
 using System.ComponentModel;
 using System.Data;
 using System.Drawing;
 using System.Linq;
 using System.Text;
 using System.Windows.Forms;
 using System.Data.SqlClient;
 
 namespace ProjDatabase
 {
     public partial class Form2 : Form
     {
         public Form2()
         {
             InitializeComponent();
         }
         ////BELOW WILL BE INVOKED IF THE BUTTON "Cancel" is Clicked
         //private void btnCancel_Click(object sender, EventArgs e)
         //{
 
         //}
 
 
         //BELOW WILL BE INVOKED IF THE BUTTON "Saving NOT Using DataSet" is Clicked
 //        private void btnSubmit_Click(object sender, EventArgs e)
 //        {
 //            try
 //            {
 //                //GET THE DATA IN THE FORM and store them in variables
 //                string FigureName, Height, Scale, Price, ProductNumber, Manufacturer, iType, ReleaseDate;
 //                FigureName = txtNameofFigurine.Text.ToString();
 //                Height = txtHeight.Text.ToString();
 //                Scale = txtScale.Text.ToString();
 //                Price = txtPrice.Text.ToString();
 //                ProductNumber = txtProductNumber.Text.ToString();
 //                Manufacturer =txtManufacturer.Text.ToString();
 //                iType = txtiType.Text.ToString();
 //                ReleaseDate = txtReleaseDate.Text.ToString();
 
 //                //ACCESS THE DATA SOURCE
 //                string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\marvin\Desktop\FigureSaleDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
 //                SqlConnection connStudent = new SqlConnection(connString);
 //                connStudent.Open();
 
 //                string sqlInsertStatement = @"Insert into Name (FigureName,  Height, Scale, Price, Product Number)
 //                                          Values ('" + FigureName + "','" +Height + "', '" + Scale + "', '"
 //                                                         + Price + "', '" + ProductNumber +  "' )";
 
 //                SqlCommand cmdTxt = new SqlCommand(sqlInsertStatement, connStudent);
 
 //                cmdTxt.ExecuteNonQuery();
 //                MessageBox.Show("Saving is done!");
 
 //                //CLOSE THE DATA SOURCE
 //                connStudent.Close();
 //                connStudent.Dispose();
 //                this.Close();    //CLOSE THE FORM
 //            }
 //            catch (Exception exc)
 //            {
 //                MessageBox.Show(exc.Message);
 //            }
 
 
         private void btnCancel_Click_1(object sender, EventArgs e)
         {
             this.Close();
         }
 
         private void btnSubmit_Click_1(object sender, EventArgs e)
         {
             try
             {
                 //GET THE DATA IN THE FORM and store them in variables
                 string FigureName, Height, Scale, Price, ProductNumber, Manufacturer, iType, ReleaseDate;
                 FigureName = txtNameofFigurine.Text.ToString();
                 Height = txtHeight.Text.ToString();
                 Scale = txtScale.Text.ToString();
                 Price = txtPrice.Text.ToString();
                 ProductNumber = txtProductNumber.Text.ToString();
                 Manufacturer = txtManufacturer.Text.ToString();
                 iType = txtiType.Text.ToString();
                 ReleaseDate = txtReleaseDate.Text.ToString();
 
                 //ACCESS THE DATA SOURCE
                 string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\marvin\Desktop\FigureSaleDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
                 SqlConnection connStudent = new SqlConnection(connString);
                 connStudent.Open();
 
                 string sqlInsertStatement = @"Insert into Name (FigureName,  Height, Scale, Price, ProductNumber)
                                           Values ('" + FigureName + "','" + Height + "', '" + Scale + "', '"
                                                          + Price + "', '" + ProductNumber + "' )";
 
                 string sqlInsertStatement1 = @"Insert into Manufacturer (Manufacturer,  iType, ReleaseDate, ProductNumber)
                                           Values ('" + Manufacturer + "','" +iType + "', '" + ReleaseDate + "', '"
                                                         +  ProductNumber + "' )";
 
                 SqlCommand cmdTxt = new SqlCommand(sqlInsertStatement + sqlInsertStatement1, connStudent);
 
                 //cmdTxt.ExecuteNonQuery();
                 MessageBox.Show("Saving is done!");
 
                 //CLOSE THE DATA SOURCE
                 connStudent.Close();
                 connStudent.Dispose();
                 this.Close();    //CLOSE THE FORM
             }
             catch (Exception exc)
             {
                 MessageBox.Show(exc.Message);
             }
         }
     }
 }