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.
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.