Member Avatar for Tank50

Hi

I have dropdown list in my asp.net page.I wrote a below coing coidng in the SelectedIndexChanged,

protected void cmb_Se_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection  con=new SqlConnection("Data Source=20.1.2.58;Initial Catalog=Customer;User ID=test123");
string str = "select ExecutiveName from  Executive  where TeCode='"+cmb_Te.Text+"'";
con.Open();
SqlCommand command=new SqlCommand(str,con);
SqlDataAdapter adpter=new SqlDataAdapter(command);
DataSet data=new DataSet();
adpter.Fill(data);
int i= data.Tables[0].Rows.Count;
for (int x = 0; i < i; i++)
{


cmb_Se.Items.Add(data.Tables[0].Rows[x].ToString());


}
}

I mention what is code i wrote in my page,But once i select the text from cmb_Te combo box,the below combo box in not change.Pls give me a answer.

Thank you

Edited by happygeek because: fixed formatting
  • 3 Contributors
  • 3 Replies
  • 133 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by culeu
Member Avatar for greeny_1984

hi,
u are writing the code in selectchanged event of second combobox as i understand from u r query,so write the code in select changed event of first combobox

Member Avatar for Tank50

HI

Thanks grenny_1984 for ur reply yes i am was wrong .I have to put that in first combo box,then I select post_back(this is wrong property name ,I could not remember name of the property).But now it works

Thanks
Tank 50

Member Avatar for culeu

Add more infor for Form submit.
AutoPostBack="True"

<asp:DropDownList ID="ddl_Select" runat="server" Width="103px" OnSelectedIndexChanged="ddl_Select_SelectedIndexChanged" OnTextChanged="ddl_Select_TextChanged" [B]AutoPostBack="True"[/B]>
                    </asp:DropDownList>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.