PDA

View Full Version : CheckboxList in EDIT PAGE(vb .net)


cloudy
08-29-2009, 03:10 PM
hi there, i start to learn asp.net in Vb recently. but i have some problem in doing the checkboxlist. I have sucess to insert the selected value from the checkboxlist into the database. but now i facing issues in retrieving the selected checkbox value in the EDIT page.

i have two table,table A is store the jobType, tbl B is store the multiple jobtype for each user

TBL A
--------
JobTypeID
JobTypeName


TBL B
--------
UserID
JobTypeID


i have no idea on how to retrieve it in EDIT page? what i plan is
1st : drag the checkboxlist control into a form View, then RETRIEVE all the jobtype from the TBL A
2nd : erm....i dont know how to retireve that user selected job type from table B and the checkboxlist will "CHECKED" if the value is in the DB.


plz guide or share to me on writing the backend code in VB. hope to hear from u all soon.

Thank you.

** I am using LINQ for the tables and store procedure.