private void Add() { if (string.IsNullOrWhiteSpace(txtcode.Text)) { MessageBox.Show("Please Enter Code !!", "Demo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtcode.Focus(); } else if (string.IsNullOrWhiteSpace(txtname.Text)) { MessageBox.Show("Please Enter Name !!", "Demo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtname.Focus(); } else if (string.IsNullOrWhiteSpace(txtmobileno.Text)) { MessageBox.Show("Please Enter Mobile No !!", "Demo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtmobileno.Focus(); } else if (string.IsNullOrWhiteSpace(txtcity.Text)) { MessageBox.Show("Please Enter City !!", "Demo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtcity.Focus(); } else { if (btnadd.Text == "&Add") { string Query = "sp_tbcustomer_ups " + 0 + ",'" + txtcode.Text + "','" + txtname.Text + "','" + txtmobileno.Text + "','" + txtemailid.Text + "','" + txtaddress.Text + "','" + txtcity.Text + "','" + txtpincode.Text + "','Admin',1"; int i = customer.Add(Query); if (i > 0) { MessageBox.Show("Data Successfull Saved !!", "Demo", MessageBoxButtons.OK, MessageBoxIcon.Information); } Clearme(); } else { string Query = "sp_tbcustomer_ups " + CustomerId + ",'" + txtcode.Text + "','" + txtname.Text + "','" + txtmobileno.Text + "','" + txtemailid.Text + "','" + txtaddress.Text + "','" + txtcity.Text + "','" + txtpincode.Text + "','Admin',2"; int i = customer.Add(Query); if (i > 0) { MessageBox.Show("Data Successfull Saved !!", "Demo", MessageBoxButtons.OK, MessageBoxIcon.Information); } Clearme(); } } }