[RESOLVED] Can't view multiple selected checkbox - HTML Forums

ngaisteve1 · 10-17-2009, 01:21 PM

Hi, I got a problem of viewing multiple selected checkbox. I can only single selected checkbox but not multiple selected checkbox.

Anyone here know why?

My VB.NET code (.NET 2.0):

Code:

Dim dv As New DataView

strSQL = "SELECT Causes_guid, Causes_Name FROM Causes "
dtData = clsVM.getDataTable(strSQL)
chk_NGO_Causes.DataSource = dtData
chk_NGO_Causes.DataValueField = "Causes_guid"
chk_NGO_Causes.DataTextField = "Causes_Name"
chk_NGO_Causes.DataBind()

For i As Integer = 0 To chk_NGO_Causes.Items.Count - 1
  strSQL = "SELECT * FROM membercauses WHERE member_guid = '" & Session("MemberGUID") & "' "
  dtData2 = clsVM.getDataTable(strSQL)
  For x As Integer = 0 To dtData2.Rows.Count - 1
    If chk_NGO_Causes.Items(i).Value = dtData2.Rows(x)("causes_guid").ToString Then
      chk_NGO_Causes.SelectedValue = chk_NGO_Causes.Items(i).Value
    End If
  Next
Next

afterburn · 10-19-2009, 08:30 AM

you have to stop re-binding the data during postback.

if Not Page.IsPostBack then

End If

ngaisteve1 · 10-19-2009, 10:20 AM

Thanks for the reply.

I checked my code. I did have

If Not Page.IsPostBack then

End If

When I step thru the code, I realize that, it did loop well but what happened was the later value override the previous value. That's why at the end, I will only be able to see one selected value. How do I fix this? I'm still searching.

ngaisteve1 · 10-19-2009, 11:28 AM

Found the fix at last.

Code:

            Dim dv As New DataView

            strSQL = "SELECT Causes_guid, Causes_Name FROM Causes "
            dtData = clsVM.getDataTable(strSQL)

            dtData = clsVM.getDataTable(strSQL)

            chk_NGO_Causes.DataSource = dtData
            chk_NGO_Causes.DataValueField = "Causes_guid"
            chk_NGO_Causes.DataTextField = "Causes_Name"
            chk_NGO_Causes.DataBind()

            For i As Integer = 0 To chk_NGO_Causes.Items.Count - 1
                strSQL = "SELECT causes_guid FROM membercauses WHERE member_guid = '" & Session("MemberGUID") & "'  "
                dtData2 = clsVM.getDataTable(strSQL)

                For x As Integer = 0 To dtData2.Rows.Count - 1
                    Dim currentCheckBox As ListItem = chk_NGO_Causes.Items.FindByValue(dtData2.Rows(x)("causes_guid").ToString)
                    If Not (currentCheckBox Is Nothing) Then
                        currentCheckBox.Selected = True
                    End If
                Next
            Next