Dropdown list within a datagrid

[gn]

Hi have a dropdown list within a datagrid, based on what is selected in
the list I want to populate another dropdownlist, the code to populate
the dropdownlists is not the problem, my problem is getting the code
behind to recognise that something has been selected.

I have tried using the selectedindexch anged event and that never fires.

I also added onselectchange= "dataCOM_Select edIndexChanged" attribute to
the dropdownlist and on the code behind page:

Public Sub dataCOM_Selecte dIndexChanged(B yVal sender As Object, ByVal e
As System.EventArg s)
'populate second dropdownlist code
End Sub

This didn't fire either.

Any ideas or suggestions would be appreciated.

[Kostadin Kostov]

this is working code:
in .aspx file:

<asp:DropDownLi st Runat="server" ID="ddlSubcateg ories" DataTextField=" Name"
DataValueField= "ID" AutoPostBack="T rue"
OnSelectedIndex Changed="ddlSub categories_Sele ctedIndexChange d">
</asp:DropDownLis t>

protected void ddlCategories_S electedIndexCha nged(object sender,
EventArgs e)
{
//the code goes here
}

Maybe you forgot the AutoPostBack property set to True, which is False by
default ?

Hope this helps!
"[e-mail] u.edu" wrote:

Hi have a dropdown list within a datagrid, based on what is selected in
the list I want to populate another dropdownlist, the code to populate
the dropdownlists is not the problem, my problem is getting the code
behind to recognise that something has been selected.

I have tried using the selectedindexch anged event and that never fires.

I also added onselectchange= "dataCOM_Select edIndexChanged" attribute to
the dropdownlist and on the code behind page:

Public Sub dataCOM_Selecte dIndexChanged(B yVal sender As Object, ByVal e
As System.EventArg s)
'populate second dropdownlist code
End Sub

This didn't fire either.

Any ideas or suggestions would be appreciated.

[Kostadin Kostov]

Sorry, the code snippet in the code behind is:

protected void ddlSubcategorie s_SelectedIndex Changed(object sender,
EventArgs e)
{
// the code goes here
}

"[e-mail] u.edu" wrote:

Hi have a dropdown list within a datagrid, based on what is selected in
the list I want to populate another dropdownlist, the code to populate
the dropdownlists is not the problem, my problem is getting the code
behind to recognise that something has been selected.

I have tried using the selectedindexch anged event and that never fires.

I also added onselectchange= "dataCOM_Select edIndexChanged" attribute to
the dropdownlist and on the code behind page:

Public Sub dataCOM_Selecte dIndexChanged(B yVal sender As Object, ByVal e
As System.EventArg s)
'populate second dropdownlist code
End Sub

This didn't fire either.

Any ideas or suggestions would be appreciated.

[Eliyahu Goldin]

Did you set AutoPostBack = true ?

Eliyahu

<[e-mail] u.edu> wrote in message
news:11******** *************@c 13g2000cwb.goog legroups.com...

Hi have a dropdown list within a datagrid, based on what is selected in
the list I want to populate another dropdownlist, the code to populate
the dropdownlists is not the problem, my problem is getting the code
behind to recognise that something has been selected.

I have tried using the selectedindexch anged event and that never fires.

I also added onselectchange= "dataCOM_Select edIndexChanged" attribute to
the dropdownlist and on the code behind page:

Public Sub dataCOM_Selecte dIndexChanged(B yVal sender As Object, ByVal e
As System.EventArg s)
'populate second dropdownlist code
End Sub

This didn't fire either.

Any ideas or suggestions would be appreciated.

[gn]

OK, It turns out the problem was OnSelectedIndex Changed, I had
OnSelectedIndex instead, so now it fires just fine.

My next problem is that I thought it would be easy to populate the next
DDL, however that doesn't seem to be the case, not only do I not
succeed in populating the ddl, I also loose everything from the first??

Here is the relevant code, let me know if you need to know more:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
rtlTitle.Text = "Committees "
If Page.IsPostBack Then
Else
BindData("add")
End If
End Sub

Public Sub dataCOM_Selecte dIndexChanged(B yVal sender As Object, ByVal e
As System.EventArg s)
Dim objdr As OracleDataReade r
Dim objcnn As OracleConnectio n
Dim objcom As OracleCommand
Dim DDLAddCommName As DropDownList
objcnn = New
OracleConnectio n(Application(" gConnString").T oString)
objcnn.Open()
objcom = New OracleCommand(" SELECT COMMITTEE_NAME FROM
COMMITTEE " & _
"WHERE COMMITTEE_YEAR = '" & CommYear & "' ORDER BY
COMMITTEE_NAME" , objcnn)
objdr = objcom.ExecuteR eader
DDLAddCommName = CType(sender, DropDownList)
With DDLAddCommName
..DataSource = objdr
..DataTextField = "COMMITTEE_NAME "
..DataValueFiel d = "COMMITTEE_NAME "
..DataBind()
End With
objcnn.Close()
End Sub

Thasnks again

[Eliyahu Goldin]

Is ViewState enabled for the page?

Eliyahu

<[e-mail] u.edu> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com...

OK, It turns out the problem was OnSelectedIndex Changed, I had
OnSelectedIndex instead, so now it fires just fine.

My next problem is that I thought it would be easy to populate the next
DDL, however that doesn't seem to be the case, not only do I not
succeed in populating the ddl, I also loose everything from the first??

Here is the relevant code, let me know if you need to know more:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
rtlTitle.Text = "Committees "
If Page.IsPostBack Then
Else
BindData("add")
End If
End Sub

Public Sub dataCOM_Selecte dIndexChanged(B yVal sender As Object, ByVal e
As System.EventArg s)
Dim objdr As OracleDataReade r
Dim objcnn As OracleConnectio n
Dim objcom As OracleCommand
Dim DDLAddCommName As DropDownList
objcnn = New
OracleConnectio n(Application(" gConnString").T oString)
objcnn.Open()
objcom = New OracleCommand(" SELECT COMMITTEE_NAME FROM
COMMITTEE " & _
"WHERE COMMITTEE_YEAR = '" & CommYear & "' ORDER BY
COMMITTEE_NAME" , objcnn)
objdr = objcom.ExecuteR eader
DDLAddCommName = CType(sender, DropDownList)
With DDLAddCommName
.DataSource = objdr
.DataTextField = "COMMITTEE_NAME "
.DataValueField = "COMMITTEE_NAME "
.DataBind()
End With
objcnn.Close()
End Sub

Thasnks again

[gn]

ViewState is enabled for the page, the datagrid and both dropdownlists,
still makes no difference

[gn]

Here is the datagrid on the aspx page:
<DIV align="center"> <asp:datagrid id="DataCOM" runat="server"
ShowFooter="Tru e" BorderColor="#0 03399" AutoGenerateCol umns="False"
Width="90%" EditItemStyle-BackColor="#FFF FCC" EnableViewState ="True">
<EditItemStyl e BackColor="#FFF FCC"></EditItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="Whit e"
BackColor="#003 399"></HeaderStyle>
<Columns>
<asp:TemplateCo lumn HeaderText="Del ete">
<ItemTemplate >
<asp:LinkButt on CommandName="De lete" Text="Delete" ID="btnDel"
Runat="server" />
<INPUT id="hdnMemberID " type="hidden" value='<%#
Container.DataI tem("MEMBER_ID" ) %>' runat=server>
</ItemTemplate>
<FooterTemplate >
<asp:LinkButt on CommandName="In sert" Text="Add" ID="btnAdd"
Runat="server" />
</FooterTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Yea r">
<ItemTemplate >
<%# Container.DataI tem("COMMITTEE_ YEAR") %>
</ItemTemplate>
<FooterTemplate >
<asp:DropDownLi st id="DDLAddCommY ear" runat="server"
OnSelectedIndex Changed="dataCO M_SelectedIndex Changed"
AutoPostBack="T rue" EnableViewState ="True"></asp:DropDownLis t>
</FooterTemplate>
<EditItemTempla te>
<asp:TextBox ID="txtCommYear " Columns="4" Text='<%#
Container.DataI tem("COMMITTEE_ YEAR") %> ' Runat="server" />
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Com mittee Name">
<ItemTemplate >
<%# Container.DataI tem("COMMITTEE_ NAME") %>
</ItemTemplate>
<FooterTemplate >
<asp:DropDownLi st id="DDLAddCommN ame" runat="server"
AutoPostBack="T rue" EnableViewState ="True"></asp:DropDownLis t>
</FooterTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Nam e">
<ItemTemplate >
<%# Container.DataI tem("FIRST_NAME ") %>
<%# Container.DataI tem("LAST_NAME" ) %>
</ItemTemplate>
<FooterTemplate >
<asp:DropDownLi st id="DDLAddName "
runat="server"> </asp:DropDownLis t>
</FooterTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn Visible="False" >
<ItemTemplate >
<asp:TextBox ID="txtMemberID " Text='<%#
Container.DataI tem("MEMBER_ID" ) %>' Runat="server" />
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:datagrid></DIV>
Let me know if anything else would be useful
Thanks again