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."; } }