checkboxlist

I am using VB.net and a webform

I want to populate a CheckBoxList with data using a query, is there an example or a website i can refer to ?



Moiz
LVL 4
Moizsaif123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

iboutchkineCommented:
Set AutoPostBack=True to refresh on every click (cblContinent)

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here

        If Not Page.IsPostBack Then

' Create a HashTable with continent names.
            Dim continents As New Hashtable(5)
            continents.Add("America", 1)
            continents.Add("Europa", 2)
            continents.Add("Asia", 3)
            continents.Add("Africa", 4)
            continents.Add("Australia", 5)

            ' Bind it to the cblContinents CheckBoxList control.
            cblContinents.DataSource = continents
            cblContinents.DataTextField = "Key"
            cblContinents.DataValueField = "Value"

            ' Perform binding for all the controls in the page.
            Me.DataBind()
End If

End Sub

 ' an element of the CheckBoxList control has been selected

    Private Sub cblContinents_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cblContinents.SelectedIndexChanged
        Dim li As ListItem, msg As String
        ' check the Selected property of each item
        For Each li In cblContinents.Items
            If li.Selected Then
                msg &= String.Format("Item = {0}, Value = {1}<br>", li.Text, li.Value)
            End If
        Next
        lblCheckBoxListInfo.Text = msg
    End Sub
0
mani_saiCommented:
Hello Moizsaif123,

Here is the sample code:

<%@ Page Language="VB" AutoEventWireup="True" %>

<html>

<head>

   <script runat="server">

      Sub Check_Clicked(sender as Object, e As EventArgs)

         Message.Text = "Selected Item(s):<br><br>"

         ' Iterate through the Items collection of the CheckBoxList
         ' control and display the selected items.
         Dim i As Integer

         For i=0 To checkboxlist1.Items.Count - 1

            If checkboxlist1.Items(i).Selected Then

               Message.Text &= checkboxlist1.Items(i).Text & "<br>"

            End If

         Next

      End Sub

   </script>
 
</head>

<body>
   
   <form runat="server">
 
      <h3> CheckBoxList Example </h3>

      Select items from the CheckBoxList.

      <br><br>

      <asp:CheckBoxList id="checkboxlist1"
           AutoPostBack="True"
           CellPadding="5"
           CellSpacing="5"
           RepeatColumns="2"
           RepeatDirection="Vertical"
           RepeatLayout="Flow"
           TextAlign="Right"
           OnSelectedIndexChanged="Check_Clicked"
           runat="server">
 
         <asp:ListItem>Item 1</asp:ListItem>
         <asp:ListItem>Item 2</asp:ListItem>
         <asp:ListItem>Item 3</asp:ListItem>
         <asp:ListItem>Item 4</asp:ListItem>
         <asp:ListItem>Item 5</asp:ListItem>
         <asp:ListItem>Item 6</asp:ListItem>
 
      </asp:CheckBoxList>
 
      <br><br>

      <asp:label id="Message" runat="server"/>
             
   </form>
         
</body>

</html>

Hope it helps

Thanks
0
jpontaniCommented:
If you're using the SqlClient objects, then you can do the following:

Dim sqlConn as New SqlConnection
Dim sqlCommand as New SqlCommand
Dim sqlReader as SqlDataReader
sqlConn.ConnectionString = "..."
sqlConn.Open()
sqlCommand.Connection = sqlConn
sqlCommand.CommandText = "SELECT * FROM Table"
sqlReader = sqlCommand.ExecuteReader
myCheckBoxList.DataSource = sqlReader
myCheckBoxList.DataTextField = "...field name for text..."
myCheckBoxList.DataValueField = "...field name for values..."
myCheckBoxList.DataBind()

- Joe
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Moizsaif123Author Commented:
Ssql = "Select * from testpurpose"
        With cmd
            .CommandText = Ssql
            .Connection = myConnection
        End With
        myConnection.Open()
        dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
        While dr.Read
            CheckBoxList1.Items.Add(dr("ID"))
        End While
        myConnection.Close()

above im running a query which creates a list of checkboxes....


on server side how do i know which check box is selected or checked....



Moiz

0
jpontaniCommented:
Dim chkBox as CheckBox
For Each chkBox In CheckBoxList1
    If(chkBox.Checked)
        Response.Write("Checkbox ID " & chkBox.ID & " is checked.")
    End If
Next

That will write the ID's of the boxes that are checked.

- Joe
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.