checkboxes in asp.net using c#

Question

Hy all..I want to ask you how is it possible when a checkbox is checked data from a table is shown based on that checked checkbox.So I have 2 tables: Countries and Cities. I displayed all the countries within a checkboxlist so each country has a checkbox.Now I want when I check a checkbox the cities regarding the country checked to appear.This is my code for displaying the countries:

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["erp"].ConnectionString);
    con.Open();
    string intero = "Select * from judete";
    SqlCommand cmd = new SqlCommand(intero, con);

    SqlDataReader rdr;

    rdr = cmd.ExecuteReader();

    while (rdr.Read())
    {


        CheckBoxList check = new CheckBoxList();
        check.Visible = true;

        check.Items.Add(new ListItem(rdr[1].ToString()));
        Panel1.Controls.Add(check);

        foreach (ListItem item in check.Items)
        {

            item.Text = rdr.GetString(1);
        }

    }

My question is: how can i retrieve the cities based on what checkbox is checked? Thanks in advance and sorry for repeating but I didn't figure it out yet.

Alex · Accepted Answer · 2012-03-20 09:27:50Z

2

what you should do is:

make your checkboxlist autopostback property set to true
on the event SelectedIndexChanged of checkboxlist write your code to retrieve the cities of the checkeditem and display them whereveer you want.

answered Mar 20, 2012 at 9:27

Alex

6,18913 gold badges46 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ajay · Accepted Answer · 2012-03-20 09:39:03Z

0

Use this code to get selected country

protected void CBCountries_SelectedIndexChanged(object sender, EventArgs e)
{
    string result = Request.Form["__EVENTTARGET"];
    string[] checkedBox = result.Split('$');
    int index = int.Parse(checkedBox[checkedBox.Length - 1]);

    if (CBCountries.Items[index].Selected)
    {
        String Country = CBCountries.Items[index].Value;
        //query your cities table based on selected Country
        BindCities(Country);     
    }
    else
    {
    }
}

answered Mar 20, 2012 at 9:39

Ajay

1541 silver badge11 bronze badges

Collectives™ on Stack Overflow

checkboxes in asp.net using c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related