How to insert multiple Checkboxlist value into database in asp.net

 In this post I will explain how we can insert the multiple selected value of Checkbox list into your database.

And retrieve the values from database to bind to check box list,

In previous article, I have explained the Difference between WCF and Web API and WCF REST and Web Service and when to use Web API over others services. In this article, you will learn when to use Web API with MVC.

Description:

I have created table name StudentQualifications , ID as  primary key in table refer below table structure .

ID	int
C_QUALIFICATION	varchar(50)

Now go to Visual Studio and take new website. After that add a webform to application. Drag and drop
Checkboxlist control from Toolbox. and take values like this

<asp:CheckBoxList ID="chkeducation" runat="server">

      <asp:ListItem>PGDCA</asp:ListItem>      
      <asp:ListItem>M.SC.</asp:ListItem>

        <asp:ListItem>MBA</asp:ListItem>

        <asp:ListItem>B.TECH</asp:ListItem>

        <asp:ListItem>MCA</asp:ListItem>

        <asp:ListItem>B.SC.</asp:ListItem>

        <asp:ListItem>POST GRADUATION</asp:ListItem>

        </asp:CheckBoxList>

        

        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Insert" />

Now go to .aspx.cs page. Add namespace.

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ToString());

protected void Page_Load(object sender, EventArgs e)

    {

        if (con.State == ConnectionState.Closed)

        {

            con.Open();

        }

    }

protected void Button1_Click(object sender, EventArgs e)

    {

        String str = "";

        for (int i = 0; i <= chkeducation.Items.Count - 1; i++)

        {

            if (chkeducation.Items[i].Selected)

            {

                if (str == "")

                {

                    str = chkeducation.Items[i].Text;

                }

                else

                {

                    str += "," + chkeducation.Items[i].Text;

                }

            }

        }

        con.Open();

        SqlCommand cmd = new SqlCommand("Insert into QUALIFICATION(C_QUALIFICATION) values('" + str + "')", con);

        cmd.ExecuteNonQuery();

        Clear();

    }

    public void Clear()

    {

        chkeducation.SelectedIndex = -1;

    }

In VB.net refer bellow code 

Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("connection").ToString())

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

       If con.State = ConnectionState.Closed Then

            con.Open()

        End If

    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim str As [String] = ""

        For i As Integer = 0 To chkeducation.Items.Count - 1

            If chkeducation.Items(i).Selected Then

                If str = "" Then

                    str = chkeducation.Items(i).Text

                Else

                    str += "," + chkeducation.Items(i).Text

                End If

            End If

        Next

        Dim cmd As New SqlCommand("Insert into QUALIFICATION(C_QUALIFICATION) values('" & str & "')", con)

        cmd.ExecuteNonQuery()

        Clear()

        con.Close()

    End Sub

    Public Sub Clear()

        chkeducation.SelectedIndex = -1

    End Sub

Run the application you will get results ----happy coding

Retrieving values and assigning to check box list refer

http://www.4guysfromrolla.com/articles/050703-1.aspx

Note : Declare the connection string in web.config file