private void Insertbtn_Click(object sender, EventArgs e) { if (nameTxt.Text == "") { nameTxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); nameTxt.Focus(); return; } if (dtmtxt.Text == "") { dtmtxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); dtmtxt.Focus(); return; } if (ConNumtxt.Text == "") { ConNumtxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); ConNumtxt.Focus(); return; } if (Addresstxt.Text == "") { Addresstxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); Addresstxt.Focus(); return; } if (Agetxt.Text == "") { Agetxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); Agetxt.Focus(); return; } if (HosChartxt.Text == "") { HosChartxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); HosChartxt.Focus(); return; } if (ProfChartxt.Text == "") { ProfChartxt.BackColor = Color.LightPink; MessageBox.Show("Name is required", "validation error", MessageBoxButtons.OK, MessageBoxIcon.Information); ProfChartxt.Focus(); return; } try { if (con.State == ConnectionState.Closed) { con.Open(); } if (Insertbtn.Text == "Insert") { SqlCommand sqlCmd = new SqlCommand("OutPBill", con); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@mode", "Add"); sqlCmd.Parameters.AddWithValue("@PatientId", 0); sqlCmd.Parameters.AddWithValue("@Name", nameTxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Date", dtmtxt.Value.Date); sqlCmd.Parameters.AddWithValue("@Contact_Number", ConNumtxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Address", Addresstxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Age", Agetxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Hospital_Charge", HosChartxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@profs_Charge", ProfChartxt.Text.Trim()); sqlCmd.ExecuteNonQuery(); MessageBox.Show("Data inserted successfully"); } Reset(); FillDataGridView(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Message"); } finally { con.Close(); } try { if (con.State == ConnectionState.Closed) { con.Open(); } if (Insertbtn.Text == "Insert") { SqlCommand sqlCmd = new SqlCommand("OutPDProc", con); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@mode", "Add"); sqlCmd.Parameters.AddWithValue("@PatientId", 0); sqlCmd.Parameters.AddWithValue("@Name", nameTxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Contact_Number", ConNumtxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Address", Addresstxt.Text.Trim()); sqlCmd.Parameters.AddWithValue("@Age", Agetxt.Text.Trim()); } Reset1(); FillDataGridView1(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error Message"); } finally { con.Close(); } }