private void saveButton_Click(object sender, EventArgs e)
{
String pid = patientIdTextBox.Text;
String firstname = firstNameTextBox.Text;
String lastName = lastNameTextBox.Text;
String gender = genderComboBox.Text;
String age = ageTextBox.Text;
String civilStatus = civilStatusComboBox.Text;
String mobile = mobileTextBox.Text;
String address = addressTextBox.Text;
String connectionString = @"server = MITHUN-PC; database = hospital; integrated security = true ";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string query =
String.Format("insert into patient values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",pid,firstname,lastName,gender,age,civilStatus,mobile,address);
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
//inserted successfully then
inpatientMedicalInfoUI inpatientMedicalInfoObject = new inpatientMedicalInfoUI();
inpatientMedicalInfoObject.MdiParent = this.MdiParent;
this.Close();
inpatientMedicalInfoObject.Show();
}
private void inpatientMedicalInfoButton_Click(object sender, EventArgs e)
{
inpatientMedicalInfoUI inpatientMedicalInfoObject = new inpatientMedicalInfoUI();
inpatientMedicalInfoObject.MdiParent = this.MdiParent;
this.Close();
inpatientMedicalInfoObject.Show();
}
