Extract multiple values from one DB field and populate a checkbox list 1

[prover]

Ok here goes...

I have a checkboxlist which stores its data in one field. how do i return that data back to the checkboxlist fro display.

there are five options
m - manager
c - clerk
a - assistant
n - monitor

and the values saved in the db: "mca" (if you checked manager, clerk and assistant). I was given this application and db structure and there isn't too much i can do about it. I know it must be easy I just can't my head around it.

TIA
Its always the easy things that escape me in life!


Never argue with an idiot. He'll just drag you to his level and beat you with experience!

 

[ca8msm]

You can probably use the CheckBoxList's Items.FindByValue method to find the relevant items and set their Checked property to True.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jbenson001]

If you string has some delimiter, such as a comma, "m,c,a" then you can use the split method and bind to the results.