protected void Reload() { testDrop.Items.Clear(); gr.DataSource = ""; gr.DataBind(); questionsWrap.InnerHtml = ""; SQL sql = new SQL(); DataTable DT = sql.GetTests(); if (DT.Rows.Count > 0) { foreach (DataRow r in DT.Rows) { string id = r["TestID"].ToString(); string name = r["Name"].ToString(); if (!testDrop.Items.Contains(new ListItem(name, id))) { ListItem item = new ListItem(name, id); testDrop.Items.Add(item); } } } gr.DataSource = DT; gr.DataBind(); error.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { SQL sql = new SQL(); DataTable DT = sql.GetTests(); if (DT.Rows.Count > 0) { foreach (DataRow r in DT.Rows) { string id = r["TestID"].ToString(); string name = r["Name"].ToString(); if (!testDrop.Items.Contains(new ListItem(name, id))) { ListItem item = new ListItem(name, id); testDrop.Items.Add(item); } } } gr.DataSource = DT; gr.DataBind(); error.Visible = false; }