private void btn_Edit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_ID.Text))
{
MessageBox.Show("Please select a patient record.");
}
else
{
ManagePatientForm mpf = new ManagePatientForm();
mpf.Show();
mpf.btn_Add.Visible = false;
mpf.txt_ID.Text = this.txt_ID.Text;
using (MySqlConnection con = new MySqlConnection(connection))
{
con.Open();
using (MySqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM DbTest.Patients WHERE PatientID=" + txt_ID.Text;
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
mpf.txt_ID.Text = Convert.ToInt32(rdr["PatientID"]).ToString();
mpf.txt_FirstName.Text = rdr["FirstName"].ToString();
mpf.txt_MiddleName.Text = rdr["MiddleName"].ToString();
mpf.txt_LastName.Text = rdr["LastName"].ToString();
mpf.txt_Address.Text = rdr["PatientAddress"].ToString();
mpf.txt_Age.Text = Convert.ToInt32(rdr["Age"]).ToString();
}
}
}
}
}
private void btn_Add_Click(object sender, EventArgs e)
{
ManagePatientForm mpf = new ManagePatientForm();
mpf.Show();
mpf.btn_Update.Visible = false;
}
