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"