Radiobuttonlist in datalist edititemtemplate

kylernep · December 13th, 2004, 01:08 PM

I'm having trouble trying to pre-select a yes/no value in a radiobuttonlist in the edititemtemplate
section based on a true/false database value.

I can't seem to be able to reference the radiobuttonlist control using find control.

<script language="vb" runat="server">
    Dim strConnection As String ="Provider=Microsoft.Jet.OLEDB.4.0;data source=d:\webapps\integration\database\integration _test_request.mdb"
    Dim objConnection As New OleDbConnection(strConnection)

..
..

Sub BindTaskDetailGrid()

    Dim strSQL2 as String = "SELECT Applications.Integration_Tested, Test_Request.GRADS_Class_Changed, Test_OS.TestOSID "
        strSQL2 += "FROM (Applications INNER JOIN Test_Request ON Applications.AppID = Test_Request.AppID) INNER JOIN Test_OS "
         strSQL2 += "ON Test_Request.RequestID = Test_OS.RequestID WHERE Test_OS.TestOSID=99;"

' Create the commandand set it's properties

    'Set the datagrid's datasource to the datareader and databind
    Dim TaskDataSet as New DataSet()
    Dim TaskDataAdapter as OleDbDataAdapter = New OleDbDataAdapter(strSQL2, objConnection)
    TaskDataAdapter.Fill(TaskDataSet,"theTable")

    TaskDetail.DataSource = TaskDataSet

..
..

End Sub

</script>

<html>

..
..

<asp:datalist id="TaskDetail" runat="server"
OnEditCommand="TaskDetail_Edit"
OnItemDataBound="TaskDetail_ItemDataBound"
..
..

<EditItemTemplate>
    <asp:radiobuttonlist id="IntegrationTested" runat="server" >
        <asp:listitem id ="TestedYes" runat="server" value="True" text="Yes" />
        <asp:listitem id ="TestedNo" runat="server" value="False" text="No" />
    </asp:radiobuttonlist>
</EditItemTemplate>

jbenson001 · December 13th, 2004, 04:28 PM

I created a quick table in my DB with 2 columns first col is a descrition char(10) the second is a bit, basically 0 = False, 1 = True. My datagrid contains 2 columns. The first shows the description, and the second is a template column with 2 RadioButtons, rb1(True) and rb2(False). I then filled a dataset and bound it to my datagrid. Here is the code behind for the ItemDataBound Event:

   Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
        ' Response.Write(e.Item.ItemIndex)
        If e.Item.ItemIndex <> -1 Then
            Response.Write(DsTest1.Tables(0).Rows(e.Item.ItemI ndex).Item(1))
        End If

        If e.Item.ItemIndex <> -1 And e.Item.Cells(1).HasControls Then
            If DsTest1.Tables(0).Rows(e.Item.ItemIndex).Item(1) = True Then ''this column is actually a bit in the DB .. but use True or False for comparison here
                CType(e.Item.Cells(1).FindControl("rb1"), RadioButton).Checked = True
            Else
                CType(e.Item.Cells(1).FindControl("rb2"), RadioButton).Checked = True
            End If
        End If
    End Sub

kylernep · December 13th, 2004, 04:47 PM

Quote:

quote:Originally posted by jbenson001
I created a quick table in my DB with 2 columns first col is a descrition char(10) the second is a bit, basically 0 = False, 1 = True. My datagrid contains 2 columns. The first shows the description, and the second is a template column with 2 RadioButtons, rb1(True) and rb2(False). I then filled a dataset and bound it to my datagrid. Here is the code behind for the ItemDataBound Event:

Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
        ' Response.Write(e.Item.ItemIndex)
        If e.Item.ItemIndex <> -1 Then
            Response.Write(DsTest1.Tables(0).Rows(e.Item.ItemI ndex).Item(1))
        End If

        If e.Item.ItemIndex <> -1 And e.Item.Cells(1).HasControls Then
            If DsTest1.Tables(0).Rows(e.Item.ItemIndex).Item(1) = True Then ''this column is actually a bit in the DB .. but use True or False for comparison here
                CType(e.Item.Cells(1).FindControl("rb1"), RadioButton).Checked = True
            Else
                CType(e.Item.Cells(1).FindControl("rb2"), RadioButton).Checked = True
            End If
        End If
    End Sub

How would you code this for a datalist?

jbenson001 · December 13th, 2004, 04:56 PM

I don't use datalists actually, but the syntax should be the same as far as I can see. Give it a try.

jbenson001 · December 13th, 2004, 05:08 PM

Code for DataList

   Private Sub DataList1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles DataList1.ItemDataBound

        If e.Item.ItemIndex <> -1 And e.Item.HasControls Then
            If DsTest1.Tables(0).Rows(e.Item.ItemIndex).Item(1) = True Then ''this column is actually a bit in the DB .. but use True or False for comparison here
                CType(e.Item.FindControl("rb1"), RadioButton).Checked = True
            Else
                CType(e.Item.FindControl("rb2"), RadioButton).Checked = True
            End If
        End If
    End Sub

kylernep · December 13th, 2004, 06:40 PM

I get the following error:
Object reference not set to an instance of an object

kylernep · December 14th, 2004, 12:47 PM

This did the trick:

Sub TaskDetail_ItemDataBound(sender as Object, e as DataListItemEventArgs)

If TaskDetail.EditItemIndex <> -1 And e.Item.ItemIndex <> -1 And e.Item.HasControls Then
If TaskDataSet.Tables(0).Rows(e.Item.ItemIndex).Item( 1) = True Then
     CType(e.Item.FindControl("IntegrationTested_Radi olist"), RadioButtonList).SelectedIndex = 1
            Else
                CType(e.Item.FindControl("IntegrationTested_Radiol ist"), RadioButtonList).SelectedIndex = 0
            End If
        End If

End Sub

Thanks for the help.