I have checkedlistbox that is being populated at runtime by a dataset. Whenever I tried checking multiple items, only one is being stored in my database.
Here to explain more clearly.
SQL
I have two tables, book table and author table which has its own id. My book table has an author field and which i'll get in author table that is on a form of a checkedlistbox in visual studio.
Visual Studio C#
I have a form for adding book that has a checkedlistbox which is being generated at runtime by a dataset which is the author table at sql. I want to store the items that are checked and put it in book table. What is the best possible approach for this?