public void UpdateGridView() { SqlConnection conn = new SqlConnection(@"data source = .\sqlexpress; integrated security = true; database = Patient_dentist;"); SqlDataAdapter da = null; DataSet ds = null; //collection of tables (Used instead of a datareader) DataTable dt = null; // data tables inside the data set string sqlsel = "SELECT * from Reservation"; try { //conn.Open(); SqlDataAdapter opens the connection itself da = new SqlDataAdapter(); // the new makes a new object da.SelectCommand = new SqlCommand(sqlsel, conn); ds = new DataSet(); da.Fill(ds, "MyReservations"); // fills the dataset dt = ds.Tables["MyReservations"]; // we take the information from the dataset and inputs in the table GridViewReservations.DataSource = dt; GridViewReservations.DataBind(); DropDownListPatient.DataSource = dt; DropDownListPatient.DataTextField = "ID_patient"; DropDownListPatient.DataValueField = "ID_patient"; DropDownListPatient.DataBind(); DropDownListPatient.Items.Insert(0, "Select a patient"); DropDownDate.DataSource = dt; DropDownDate.DataTextField = "Date"; DropDownDate.DataValueField = "Date"; DropDownDate.DataBind(); DropDownDate.Items.Insert(0, "Select a date"); } catch (Exception ex) { LabelMessage.Text = ex.Message; } finally { conn.Close(); //The SqlDataAdaptor closes connection by itself; but if something goes wrong, the DataAdaptor can not close the connection } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { System.Data.DataTable datedrop = new System.Data.DataTable(); datedrop.Columns.Add(new System.Data.DataColumn("Dates")); datedrop.Rows.Add(System.DateTime.Today.ToShortDateString()); for (int i = -7; i < 7; i++) { datedrop.Rows.Add(System.DateTime.Today.AddDays(i).ToShortDateString()); } DropDownDate.DataSource = datedrop; DropDownDate.DataTextField = datedrop.Columns["Dates"].ToString(); DropDownDate.DataBind(); string connetionString = null; MySqlConnection con; connetionString = "server=localhost;database=mydb;Uid=root;Pwd=;"; con = new MySqlConnection(connetionString); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { System.Data.DataTable datedrop = new System.Data.DataTable(); datedrop.Columns.Add(new System.Data.DataColumn("Dates")); datedrop.Rows.Add(System.DateTime.Today.ToShortDateString()); for (int i = -7; i < 7; i++) { datedrop.Rows.Add(System.DateTime.Today.AddDays(i).ToShortDateString()); } DropDownDate.DataSource = datedrop; DropDownDate.DataTextField = datedrop.Columns["Dates"].ToString(); DropDownDate.DataBind(); string connetionString = null; MySqlConnection con; connetionString = "server=localhost;database=coffeedb;Uid=root;Pwd=;"; con = new MySqlConnection(connetionString); con.Open(); MySqlCommand sda = new MySqlCommand("SELECT sandwich FROM products", con); MySqlDataReader dr; dr = sda.ExecuteReader(); dropdownSandwich.Items.Clear(); while (dr.Read()) { dropdownSandwich.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString())); } dropdownSandwich.DataBind(); con.Close(); con.Open(); sda = new MySqlCommand("SELECT burger FROM products", con); dr = sda.ExecuteReader(); dropdownBurger.Items.Clear(); while (dr.Read()) { dropdownBurger.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString())); } dropdownBurger.DataBind(); con.Close(); con.Open(); sda = new MySqlCommand("SELECT salad FROM products", con); dr = sda.ExecuteReader(); dropdownSalad.Items.Clear(); while (dr.Read()) { dropdownSalad.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString())); } dropdownSalad.DataBind(); con.Close(); con.Open(); sda = new MySqlCommand("SELECT drink FROM products", con); dr = sda.ExecuteReader(); dropdownCoffee.Items.Clear(); while (dr.Read()) { dropdownCoffee.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString())); } dropdownCoffee.DataBind(); con.Close(); con.Open(); sda = new MySqlCommand("SELECT dessert FROM products", con); dr = sda.ExecuteReader(); dropdownDessert.Items.Clear(); while (dr.Read()) { dropdownDessert.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString())); } dropdownDessert.DataBind(); con.Close(); } }