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

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

Description:

I have created table name QUALIFICATION. ID is primary key.

ID	int
CANDIDATE_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.

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

        <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>

        <br />

        <br />

        <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(CANDIDATE_QUALIFICATION) values('" + str + "')", con);

        cmd.ExecuteNonQuery();

        Clear();

    }

    public void Clear()

    {

        chkeducation.SelectedIndex = -1;

    }

In VB

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(CANDIDATE_QUALIFICATION) values('" & str & "')", con)

        cmd.ExecuteNonQuery()

        Clear()

        con.Close()

    End Sub

    Public Sub Clear()

        chkeducation.SelectedIndex = -1

    End Sub

Now debug the project and check the result.

Is it helpful?

If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.