I'm trying to store multiple selected checkboxes from a single checkboxlist, but i don't know where to start..
Imagine i have three tables: tbl_events, tbl_organisors and tbl_settings and i want to store the organisors of an event.
Each event can have multiple organisors, so each organisor should be added as a single row into tbl_settings.
I know how to bind tbl_organisors to a checkboxlist, but how do i store the results (meaning: add the rows to tbl_settings) ?
tbl_events: Event_ID (PK) and Event_Name
tbl_organisors: User_ID and user_name.
tbl_settings: Settings_ID (PK), Event_ID and User_ID
<asp:CheckBoxList ID="CheckBoxList1" runat="server" DataSourceID="SDS_Organisors"
DataTextField="User_Name" DataValueField="User_ID" RepeatColumns="2">
<asp:SqlDataSource ID="SDS_Organisors" runat="server"
ConnectionString="<%$ ConnectionStrings:LocalConnectionString %>"
View Complete Post