Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void cblList1_SelectedIndexChanged(object sender, EventArgs e)
- {
- foreach (ListItem list1 in cblList1.Items)
- {
- if (list1 .Selected == true)
- {
- LoadCheckBoxListList2(list1);
- }
- }
- }
- private void LoadCheckBoxListList2(ListItem itemList1)
- {
- SqlCommand cmd = new SqlCommand("SELECT DISTINCT tbl_information.route AS ROUTE FROM tbl_information INNER JOIN tbl_regional ON tbl_information.region = tbl_regional.id_regional WHERE tbl_information.supervisor = " + "'" + itemList1 + "'", conn);
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- DataSet ds = new DataSet();
- da.Fill(ds);
- cblRutas.DataSource = ds;
- cblRutas.DataValueField = "ROUTE";
- cblRutas.DataBind();
- }
- for (int i = 0; i < checkedListBox1.Items.Count; i++)
- {
- if (checkedListBox1.GetItemChecked(i))
- {
- string str = (string)checkedListBox1.Items[i];
- //Do your function call here
- }
- }
- protected void cblList1_SelectedIndexChanged(object sender, EventArgs e)
- {
- List<string> ids = new List<string>();
- foreach (ListItem list1 in cblList1.Items)
- {
- if (list1 .Selected == true)
- {
- ids.Add(list1.ToString());
- }
- }
- LoadCheckBoxListList2(ids);
- }
- private void LoadCheckBoxListList2(List<string> ids)
- {
- string idsString = string.Join(", ", ids);// WARNING: carefull, SQL-injection is possible here, better to filter the input
- SqlCommand cmd = new SqlCommand("SELECT DISTINCT tbl_information.route AS ROUTE FROM tbl_information INNER JOIN tbl_regional ON tbl_information.region = tbl_regional.id_regional WHERE tbl_information.supervisor IN (" + idsString + ")", conn);
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- DataSet ds = new DataSet();
- da.Fill(ds);
- cblRutas.DataSource = ds;
- cblRutas.DataValueField = "ROUTE";
- cblRutas.DataBind();
- }
- protected void cblList1_SelectedIndexChanged(object sender, EventArgs e)
- {
- List<string> list1 = new List<string>();
- foreach (ListItem itemList1 in cblList1.Items)
- {
- if (itemList1 .Selected == true)
- {
- list1.Add(itemList1.Text)
- }
- }
- LoadCheckBoxListList2(list1);
- }
- private void LoadCheckBoxListList2(List<string> list1)
- {
- DataTable dt = new DataTable("R");
- dt.Columns.Add("Route", typeof(string));
- foreach (string li in list1)
- {
- string query = @"SELECT DISTINCT tbl_information.route AS ROUTE FROM tbl_information INNER JOIN tbl_regional ON tbl_information.region = tbl_regional.id_regional WHERE tbl_information.supervisor = '" + li + "'";
- SqlCommand cmd = new SqlCommand(query, conn);
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- DataSet ds = new DataSet();
- da.Fill(ds);
- bool b = false;
- foreach (DataRow item in ds.Tables[0].Rows)
- {
- if (!b)
- {
- dt.Rows.Add(item[0] + " (" + li + ")");
- b = true;
- continue;
- }
- dt.Rows.Add(item.ItemArray);
- }
- }
- cblRutas.DataSource = dt;
- cblRutas.DataValueField = "ROUTE";
- cblRutas.DataBind();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement