private void Edit_data_Click(object sender, EventArgs e) { editData ob = new editData(); ob.Show(); this.Hide(); }
private void Edit_Click(object sender, EventArgs e) { connection sv = new connection(); sv.thisConnection.Open(); OracleCommand thisCommand1 = sv.thisConnection.CreateCommand(); thisCommand1.CommandText = "update HOSPITAL_LOGIN set username= '******', " + "designation='" + position.Text + "' where id= '" + em_id.Text + "'"; thisCommand1.Connection = sv.thisConnection; thisCommand1.CommandType = CommandType.Text; OracleCommand thisCommand2 = sv.thisConnection.CreateCommand(); thisCommand2.CommandText = "update salary_account set name= '" + em_name.Text + "', salary='" + salaryBox.Text + "', " + "position='" + position.Text + "',accountid='" + acId.Text + "', duty_time= '" + DutyTime.Text + "' where id= '" + em_id.Text + "'"; thisCommand2.Connection = sv.thisConnection; thisCommand2.CommandType = CommandType.Text; OracleCommand thisCommand3 = sv.thisConnection.CreateCommand(); thisCommand3.CommandText = "update doctor_data set doc_name= '" + em_name.Text + "', ward_no= '" + ward_no.Text + "', department = '" + depart.Text + "', " + "designation='" + Designation.Text + "', duty_time = '" + DutyTime.Text + "', appointment_time = '" + appt.Text + "' where doc_id= '" + em_id.Text + "'"; thisCommand3.Connection = sv.thisConnection; thisCommand3.CommandType = CommandType.Text; try { thisCommand1.ExecuteNonQuery(); thisCommand2.ExecuteNonQuery(); thisCommand3.ExecuteNonQuery(); MessageBox.Show("Updated"); this.Hide(); } catch (Exception ex) { Console.WriteLine(ex.Message); } sv.thisConnection.Close(); this.Hide(); editData ob = new editData(); ob.Show(); }