insert data from checked List Box to sql server database

Question

how to insert data from checked List Box to sql server database in c# ?

Krishna Rajput Singh · Answer

Thank you for writing below link helpful for you..:) https://social.msdn.microsoft.com/Forums/windows/en-US/da3523f6-4b48-45ba-8131-635596268bb7/how-to-insert-checked-list-box-values-and-retrieve-value-from-database?forum=winforms http://www.c-sharpcorner.com/blogs/insert-muliple-checkedlistbox-values-to-database-in-windows1

Nitin Sontakke · Answer

Friends please do not confuse between UI element and database table. Application UI and database both do not care about from where data is coming and where the data is going. Plumbing is our job. This is called abstraction. If there is a checked list box may be more than 1 is checked. It is your decision how you want to store it. There may be more information associated with it. You will need to store that as well. You should also consider how you are going to get the info from db while showing the list box again. If confused give associated data information which will help designing tables.