selected value does not change in asp:Dropdownlist
<p>I have a simple dropdownlist(ffg)...</p>

<pre><code>&lt;asp:DropDownList   ID="DropDownList2" runat="server"  AutoPostBack="true" BackColor="LightSteelBlue" Font-Size="X-Small"
    OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged1"  Style="z-index: 102; left: 37px; position: absolute; top: 85px" Width="331px"
    &lt;/asp:DropDownList&gt;
</code></pre>

<p>which I bind data to usind the onpageload event...</p>

<pre><code>DropDownList2.DataSource = td.DataSet
DropDownList2.DataSource = td
DropDownList2.DataTextField = td.Columns("Name").ColumnName.ToString
DropDownList2.DataValueField = td.Columns("VendorCode").ColumnName.ToString
DropDownList2.DataBind()
</code></pre>

<p>and an  <code>onleselectedindexchaged</code> event where I try to retreive the new value like this...</p>

<pre><code>Protected Sub DropDownList2_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList2.TextChanged
        Dim url As String = "sp_menu.aspx?sp=" &amp; DropDownList2.SelectedValue
        Session.Remove("sp")
        Session("sp") = DropDownList2.SelectedValue
        Session("spnm") = DropDownList2.SelectedItem.Text &amp; " (" &amp; DropDownList2.Text &amp; ")"
        Response.Redirect(url)
    End Sub
</code></pre>

<p>But it always brings the first value no matter which one is clicked on the dropdownlist.
Please help!</p>
