0

I am trying to populate another combobox based on the text selected in the first combo box...however , the event protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e) is not firing ?
here is my code snippet :

protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlDataReader dr1 = null;
        SqlCommand command = new SqlCommand("select category.category from category,city_master,wines_available where wines_available.city_id=city_master.city_id and wines_available.category_id=category.category_id and city_master.city_name= '" + ddlcity.SelectedItem+ "'", conn);
        conn.Open();
        dr1 = command.ExecuteReader(CommandBehavior.CloseConnection);
        ddlcategory.DataSource = dr1;
        ddlcategory.DataTextField = "Category";
        ddlcategory.DataValueField = "Category";
        ddlcategory.DataBind();
        dr1.Close();
    }

However , when i change the text in the first combobox second combo box(ddlcategory) does not get populated..plz help me out.


cya
Rohan

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by kameswari
0

Okie...it worked!!!
cya
Rohan

please set "autopostback" property of comboboxes to true....

0

hi.. i have written a sample code with static text.. .try it and check ur db once....

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (DropDownList1.SelectedItem.Value == "one")
        {
            DropDownList2.Items.Clear();
            DropDownList2.Items.Add("hello1");
            DropDownList2.Items.Add("hii1");

        }

        if (DropDownList1.SelectedItem.Value == "two")
        {
            DropDownList2.Items.Clear();
            DropDownList2.Items.Add("hello2");
            DropDownList2.Items.Add("hii2");

        }
        if (DropDownList1.SelectedItem.Value == "three")
        {
            DropDownList2.Items.Clear();
            DropDownList2.Items.Add("hello3");
            DropDownList2.Items.Add("hii3");

        }
        if (DropDownList1.SelectedItem.Value == "four")
        {
            DropDownList2.Items.Clear();
            DropDownList2.Items.Add("hello4");
            DropDownList2.Items.Add("hii4");

        }
    }

source code is

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Newfile.aspx.cs" Inherits="Newfile" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
            <asp:ListItem>one</asp:ListItem>
            <asp:ListItem>two</asp:ListItem>
            <asp:ListItem>three</asp:ListItem>
            <asp:ListItem>four</asp:ListItem>
        </asp:DropDownList>
        <asp:DropDownList ID="DropDownList2" runat="server">
        </asp:DropDownList></div>
    </form>
</body>
</html>
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.