How to write sql query using checkedlistbox?

Jun 7 2011 1:48 AM
Hi,

I am going to develop the form like below screen shot. I wrote the code in itemCheck event to insert the checked item text in textbox.



My problem is: if checked items are greater than 2 I want to insert "," (comma) in between the two items.

by selecting the items from checked list box I have to write SQL query.

by removing the selection from checked list box we have to remove that item text from the query in textbox.



Can any one plz help me with code.

Thanks
Murali krishna

Answers (5)