I have a datagrid with a dropdownbox in it(asp vb net)
I have no problem populating the grid or the dropdown.
My problem is how do i get the value from the selected item of the drop down box?

The HTML tag:
<asp:DropDownList OnSelectedIndexChanged="update_sites" AutoPostBack="true" id=affiliate_list runat="server" />

The Code:
Public sub update_sites(sender As Object, e As EventArgs)
Dim sql As String = "SELECT site_name, site_id from sites where affiliate_id=" & affiliate_list.SelectedValue
..
..
..
end Sub

hazlema, that won't work.

Sbartis,

You'll need to access the DDL from the context of the datagrid item. Off of the item you can find the control, cast it to a DDL then access it's value.

CType(datagriditem.FindControl("myDropDownListID") , DropDownList).SelectValue