protected void IssueList_Click(object sender, EventArgs e) { string selectedValue = IssueSelectDD.SelectedValue.ToString(); if (sender == null) { throw new ArgumentNullException(nameof(sender)); } if (e == null) { throw new ArgumentNullException(nameof(e)); } conn.Open(); string sqlstring = string.IsNullOrEmpty(selectedValue) ? "SELECT DISTINCT IssueId, IssueName, IssueDate, IssueStatus FROM SubmitIssuesTable" : "SELECT DISTINCT IssueId, IssueName, IssueDate, IssueStatus FROM SubmitIssuesTable WHERE IssueName = '" + selectedValue + "'"; //SQL Query to add data to fields SqlDataAdapter sda = new SqlDataAdapter(sqlstring, conn); //Create Dataset and GridView Table DataSet ds = new DataSet(); sda.Fill(ds, "SubmitIssuesTable"); IssueSelectDD.DataSource = ds.Tables["SubmitIssuesTable"]; GridViewDrop.DataSource = ds.Tables["SubmitIssuesTable"]; IssueSelectDD.DataBind(); GridViewDrop.DataBind(); conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (sender == null) { throw new ArgumentNullException(nameof(sender)); } if (e == null) { throw new ArgumentNullException(nameof(e)); } if (!this.IsPostBack) { IssueSelectDD.Items.Clear(); using (SqlCommand cmd = new SqlCommand("SELECT DISTINCT IssueId, IssueName FROM SubmitIssuesTable WHERE IssueStatus = 'OPEN'", conn)) { cmd.CommandType = CommandType.Text; cmd.Connection = conn; conn.Open(); IssueSelectDD.DataSource = cmd.ExecuteReader(); IssueSelectDD.Items.Insert(0, "--Select An Issue--"); IssueSelectDD.DataTextField = "IssueName"; IssueSelectDD.DataValueField = "IssueName"; IssueSelectDD.DataBind(); conn.Close(); } } }