public void randevuListele()
{
con.Open();
SqlDataAdapter randevular = new SqlDataAdapter("SELECT * FROM tbl_hasta_randevu WHERE kimlik='" + Session["user"] + "' AND onay='False'", con);
DataSet ds = new DataSet();
randevular.Fill(ds);
DG_randevular.DataSource = ds;
DG_randevular.DataBind();
con.Close();
}
public void randevuListele()
{
con.Open();
SqlDataAdapter randevular = new SqlDataAdapter("SELECT * FROM tbl_hasta_randevu WHERE doktor='" + DDL_Doktor.SelectedItem.Value + "'", con);
DataSet ds = new DataSet();
randevular.Fill(ds);
DG_randevular.DataSource = ds;
DG_randevular.DataBind();
con.Close();
}
public void randevuListele()
{
con.Open();
SqlDataAdapter randevular = new SqlDataAdapter("SELECT * FROM tbl_hasta_randevu WHERE doktor='" + Session["doktor_klinik"] + "' AND onay='False' ORDER BY tarih DESC", con);
DataSet ds = new DataSet();
randevular.Fill(ds);
DG_randevular.DataSource = ds;
DG_randevular.DataBind();
con.Close();
if (DG_randevular.Rows.Count < 1)
{
Label2.Text = "Randevunuz bulunmamaktadır.";
}
}