troubleshooting Question

How to populate CheckBoxList values from a database

Avatar of stevegingell
stevegingell asked on
ASP.NET
25 Comments1 Solution2686 ViewsLast Modified:
Hello,

I am having trouble populating my checkboxlist with values (checked or otherwise). I can pull the text fine though. I have 3 tables. A Clients tbl, an Equipment tbl, and a Client_Equipment tbl, which is a many-many. This is the code i am using to pull the text, but how do i check the values which are in DB?

        objCmd = New SqlCommand("SELECT * FROM Client_Equipment", objConn)
        objRdr = objCmd5.ExecuteReader()
        chklstEquipment.DataSource = objRdr
        chklstEquipment.DataValueField = "Client_EquipmentID"
        chklstEquipment.DataTextField = "Client_EquipmentCode"
        chklstEquipment.DataBind()
        objRdr.Close()
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 25 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros