CkeckBoxList value insert to database.

Babatunde lateef

i am working on a project that will allow me submit multiple selected value from checklistBox control to sql 2008 database.

i want users to fill the textBox,pick values from the dropdown and check boxes.... after hitting the button... it shoud submit into the database.

Thanks in advance

see below the html structure:

PolicyNumber
Business	onselectedindexchanged="DropDownList1_SelectedIndexChanged"> Select Item Private Commercial
Type
Product
	DataSourceID="SqlDataSource1" DataTextField="Product" DataValueField="Product" RepeatColumns="2" RepeatDirection="Horizontal" Width="450px"> ConnectionString="<%$ ConnectionStrings:MotorConnectionString %>" SelectCommand="SELECT * FROM [Product]">
	Font-Size="Large" Height="45px" Width="150px" />

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vinodh Narayanan11y ago
Hi this code will help you to store checkboxlistitem into a database

default.aspx

Father
Mother
Residence

default.aspx.cs

string modids = "";
for (int i = 0; i < chkno.Items.Count; i++)
{
if (chkno.Items[i].Selected)
{
if (modids.Length == 0)
{
modids = chkno.Items[i].Value;
}
else
modids = modids + "," + chkno.Items[i].Value;
}
}
cmd.Parameters.AddWithValue("@Emergency_Contact", modids);
Output: