Skip to main content

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

Comments

Post a Comment

Popular posts from this blog

How to hide url parameters in asp.net

There are different ways to Hide the URL in asp.net , you can choose any one from bellow options . Previously I was Explained about the  Difference between Convert.tostring and .tostring() method Example  ,   Reasons to use Twitter Bootstrap , How to Register AJAX toolkit in web.config file in asp.net a) Using Post Method b) Using Of Session . c) URL Encoding & decoding process . d) Using Server.Transfer() instead of Response.Redirect() method (1)Use a form and POST the information. This might require additional code in source pages, but should not require logic changes in the target pages (merely change Request.QueryString to Request.Form). While POST is not impossible to muck with, it's certainly less appealing than playing with QueryString parameters. (2)Use session variables to carry information from page to page. This is likely a more substantial effort compared to (1), because you will need to take session variable checking into account...
Post a Comment
Read more

How to send mail asynchronously in asp.net with MailMessage

With Microsoft.NET Framework 2.0 everything is asynchronous and we can send mail also asynchronously. This features is very useful when you send lots of bulk mails like offers , Discounts , Greetings . You don’t have to wait for response from mail server and you can do other task . By using     SmtpClient . SendAsync Method (MailMessage, Object)    you need to do  System.Net.Mail has also added asynchronous support for sending email. To send asynchronously, you need need to Wire up a SendCompleted event Create the SendCompleted event Call SmtpClient.SendAsync smtpClient.send() will initiate the sending on the main/ui  thread and would block.  smtpClient.SendAsync() will pick a thread from the .NET Thread Pool and execute the method on that thread. So your main UI will not hang or block . Let's create a simple example to send mail. For sending mail asynchronously you need to create a event handler that will notify that mail success...
Post a Comment
Read more

12 Sentences that Change Your Attitude at Work

If you work with the right attitude and right way, you’ll have your productivity up another level, and eventually, success will be just a step away. These are the 12 encouraging sentences that could change your attitude at work. #1 Don’t work harder, work deeper. #2 When you are young, work to learn, not to earn. #3 If you work really hard and are kind, amazing things will happen. #4 Productivity is never an accident. It is always the result of commitment to excellence, intelligent planning, and focused effort. #5 Most people work just hard enough not to get fired and get paid just enough money not to quit. #6 Boost your productivity by taking action immediately after setting a target even without perfect plans. Adjust your course along the way. #7 To be successful, the first thing to do is to fall in love with your work. #8 Identify your peak hour of productivity. Schedule your most important task for this period. Work on unimportant tasks during non-peak hours. #9 Be a mo...
Post a Comment
Read more