How to insert multiple Checkboxlist value into database in asp.net - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

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.

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+

1 comments:

Yes! Finally someone writes about exercise
for cellulite.

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


EmoticonEmoticon