public void InvDrAppointments()
{
Doctor.DrAppointments newDrAppointments = new Doctor.DrAppointments();
newDrAppointments.MdiParent = Application.OpenForms["DoctorDash"];
newDrAppointments.FormBorderStyle = FormBorderStyle.None;
newDrAppointments.ControlBox = false;
newDrAppointments.MaximizeBox = false;
newDrAppointments.MinimizeBox = false;
newDrAppointments.Dock = DockStyle.Fill;
newDrAppointments.Show();
}
public DataTable Get()
{
Doctor.DrAppointments frm = new Doctor.DrAppointments();
conn = new SqlConnection(connstr);
cmd = new SqlCommand("SELECT * FROM Appointment WHERE Date= '" + Globals.TempDate + "' AND Dentist='" + Globals.CurrentUser + "'", conn);
DataTable dt = new DataTable();
conn.Open();
rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
dt.Load(rdr);
conn.Close();
return(dt);
}
else
{
MessageBox.Show("No Data Appointments to Show");
dt = null;
conn.Close();
return(dt);
}
}