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.

Post a Comment

Yes! Finally someone writes about exercise
for cellulite.

Review my website ... cellulit krak򵫤ieta na cellulit jad³ospis

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget