private void button3_Click(object sender, EventArgs e)
{
string query = ("Update schedule_work_doctor set swd_start_time = '' ,swd_end_time = '',swd_note = '" + txtremark.Text + "' ,swd_date_work = '' where room_id = '" + txtroom.Text + "' AND swd_timezone = '" + txttimezone.Text + "' AND swd_date_work = '" + txtday.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_hollyday doc1 = new clinic_hollyday();
doc1.Show();
clinic_hollyday clnlog = new clinic_hollyday();
clnlog.Close();
Visible = false;
MessageBox.Show("เปลี่ยนแปลงตารางเรียบร้อย");
}
private void button3_Click(object sender, EventArgs e)
{
clinic_hollyday doc1 = new clinic_hollyday();
doc1.Show();
}