Simple Windows Application "PhoneBook Application"

Simple Windows Application "PhoneBook Application"

PART-1

Step :-1

Create  a Window Application

like this Image :-1

 Step :-2

Design for the FORM-1

 Step :-3

Write Code For The CREATE button

 private void btnCreate_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection _cON = new SqlConnection("Data Source=.;Initial Catalog=VickyRajBlogs;Integrated Security=True");
                _cON.Open();
                SqlCommand _cMD = new SqlCommand("Insert into PhoneBook values('" + txtFirstName.Text + "','" + txtLastName.Text + "'," + txtContact.Text + ")", _cON);
                int res = _cMD.ExecuteNonQuery();
                _cON.Close();

            }
            catch (Exception ex)
            {

                MessageBox.Show("ERROS" + ex.ToString());
            }
            finally
            {
                txtFirstName.Text = string.Empty;
                txtLastName.Text = string.Empty;
                txtContact.Text = string.Empty;
                
            }

        }

Write Code For The "PHONEBOOK" button

 private void btnPhoneBook_Click(object sender, EventArgs e)
        {
            PhoneBook _objPhoneBook = new PhoneBook();
            _objPhoneBook.Show();

        }

Write Code For The "CANCEL" button

private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();

        }

PART-2

Step :-1

Add a Window Application Form in This Application

like this Image :-3

  Step :-2

Write Code For The ADD New Contact button

 private void btnAddNewCOntact_Click(object sender, EventArgs e)
        {
            Form1 _ObjForm1 = new Form1();
            _ObjForm1.Show();

        }

Write Code For The  Contact button

 private void btnContacts_Click(object sender, EventArgs e)
        {
            try
            {
                showAll();


            }
            catch (Exception ex)
            {
                
                MessageBox.Show("ERROS" + ex.ToString());
            }
        }

        private void showAll()
        {

            SqlConnection _cON = new SqlConnection("Data Source=.;Initial Catalog=VickyRajBlogs;Integrated Security=True");
            _cON.Open();
            SqlCommand _cMD = new SqlCommand("Select * from PhoneBook", _cON);
            SqlDataAdapter _sDA = new SqlDataAdapter(_cMD);
            DataTable _dT = new DataTable();
            _sDA.Fill(_dT);
            gRIDPhoneBook.DataSource = _dT;
            _cON.Close();
        }

// showAll() method create for the Load Event

        private void PhoneBook_Load(object sender, EventArgs e)
        {
            showAll();

        }

Write Code For The  CANCELbutton

  private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();

        }

PART-3

DataBase Connection

Write Code For The  Create Table

Create Table PhoneBook

(

SrNo int IDENTITY(1,1) Primary Key ,

FirstName nvarchar(50),

LastName nvarchar(50) ,

ContactNo nvarchar(50) 

)

Write Code For The  Select Command

Select * from PhoneBook

Write Code For The  Insert Values into Table

Insert into PhoneBook values('VICKY','RAJ',9654388184)

PART-4

See The Results:-----

Form-1

Form-2

I hope you Enjoyed With this Application...

& THANK YOU to visit this Page...!!