private void btnSearchDoctorAppointmentList_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtDoctorID.Text))
{
CrystalReportDoctorAppointmentList cr = new CrystalReportDoctorAppointmentList();
SqlConnection conn = new SqlConnection();
conn = DbConnection.getConnection();
string appointmentdate = txtAppointmentDate.Value.ToString("dd MMM yyyy");
conn.Open();
string sql = "select * from DoctorAppointmentList where appointmentdate='" + appointmentdate + "'";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(ds, "DoctorAppointmentList");
DataTable dt = ds.Tables["DoctorAppointmentList"];
cr.SetDataSource(ds.Tables["DoctorAppointmentList"]);
crystalReportViewer3.ReportSource = cr;
crystalReportViewer3.Refresh();
conn.Close();
}
else
{
CrystalReportDoctorAppointmentList cr = new CrystalReportDoctorAppointmentList();
SqlConnection conn = new SqlConnection();
conn = DbConnection.getConnection();
string did = txtDoctorID.Text;
string appointmentdate = txtAppointmentDate.Value.ToString("dd MMM yyyy");
conn.Open();
string sql = "select * from DoctorAppointmentList where doctorid='" + did + "' and appointmentdate='" + appointmentdate + "'";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(ds, "DoctorAppointmentList");
DataTable dt = ds.Tables["DoctorAppointmentList"];
cr.SetDataSource(ds.Tables["DoctorAppointmentList"]);
crystalReportViewer3.ReportSource = cr;
crystalReportViewer3.Refresh();
conn.Close();
}
}
private void frmDoctorAppointmentList_Load(object sender, EventArgs e)
{
this.btnSearchDoctorAppointmentList.Image = WindowsFormsApplication1.Properties.Resources.search_icon_16;
CrystalReportDoctorAppointmentList cr = new CrystalReportDoctorAppointmentList();
SqlConnection conn = new SqlConnection();
conn = DbConnection.getConnection();
conn.Open();
string sql = "select * from DoctorAppointmentList";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(ds, "DoctorAppointmentList");
DataTable dt = ds.Tables["DoctorAppointmentList"];
cr.SetDataSource(ds.Tables["DoctorAppointmentList"]);
crystalReportViewer3.ReportSource = cr;
crystalReportViewer3.Refresh();
conn.Close();
}