Save Multiple ListBox selected Items in Database with commas using C# in ASP.Net

Asifpate...

SOLVED CLOSED ACTIVE ANSWERED
User: Asifpatel
Posted: on Jan 25, 2017 01:58 AM
Forum: ASP.Net Web Forms
Answer: 2
Views: 13180
Sample Code: Download

http://www.aspsnippets.com/Articles/ASP.Net-ListBox-Save-Multiple-Selected-Items-in-the-Database.aspx

The example in the link is perfect. I just want the values to be entered in database seperated by commas, in one record.

e.g. 1 Vinz, Mark, Rod

I tried but no luck. Can you do the codes?

Thanks, Asif

Download FREE API for Word, Excel and PDF in ASP.Net

Indresh

0 1

Reply
ANSWER
User: Indresh
Replied: on Jan 25, 2017 02:56 AM
Report

Hi Asifpatel,

I have created sample code by refering the below article which full-fill your requirement.

HTML

<form id="form1" runat="server">
<div>
    Employee Names:
    <br />
    <asp:ListBox ID="ListBox1" runat="server" Height="149px" SelectionMode="Multiple"
        Width="113px">
        <asp:ListItem>Vinz</asp:ListItem>
        <asp:ListItem>Jhen</asp:ListItem>
        <asp:ListItem>Chris</asp:ListItem>
        <asp:ListItem>Shynne</asp:ListItem>
        <asp:ListItem>Chu</asp:ListItem>
        <asp:ListItem>Mark</asp:ListItem>
        <asp:ListItem>Lilian</asp:ListItem>
        <asp:ListItem>Rod</asp:ListItem>
        <asp:ListItem>Glendzy</asp:ListItem>
    </asp:ListBox>
</div>
<br />
<asp:Button ID="Button1" runat="server" Text="Save" OnClick="Button1_Click" />
</form>

private string GetConnectionString()
{
    return System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
}

protected void Button1_Click(object sender, EventArgs e)
{
    string strEmployeeName = string.Empty;
    foreach (ListItem item in ListBox1.Items)
    {
        if (item.Selected)
        {
            strEmployeeName += item.Text + ",";
        }
    }
    InsertRecords(strEmployeeName.Remove(strEmployeeName.Length - 1));
}

private void InsertRecords(string employeeName)
{
    SqlConnection conn = new SqlConnection(GetConnectionString());
    SqlCommand cmd = new SqlCommand("INSERT INTO EmployeesTest Values(@EmployeeName)", conn);
    cmd.CommandType = CommandType.Text;
    cmd.Parameters.AddWithValue("@EmployeeName", employeeName);
    conn.Open();
    cmd.ExecuteNonQuery();
    conn.Close();
    Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Records Successfuly Saved!');", true);
}

Screenshot

Asifpate...

0 2

Reply
User: Asifpatel
Replied: on Jan 25, 2017 06:16 AM
Report

Thank you Indresh, that was quick and it worked. I tired adding some more fields. I have difficulties with the C# when I tried to compile them all under one button to enter into database.

Can you assist with the default.aspx.cs

Here is my struggle:

Web Config:

<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
 <connectionStrings>
 <add name="DBConnection" connectionString="Data Source=(localDB)\MSSQLLOCALDB;Initial Catalog=LogData;Integrated Security=True"/>
 </connectionStrings>
 <system.web>
 <compilation debug="true" targetFramework="4.0"/>
 </system.web>
</configuration>

Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="default.aspx.cs" Inherits="default " %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        Employee Names:
        <br />
        <asp:CheckBoxList ID="ListBox1" runat="server" Height="149px" SelectionMode="Multiple"
            Width="113px">
            <asp:ListItem>Vinz</asp:ListItem>
            <asp:ListItem>Jhen</asp:ListItem>
            <asp:ListItem>Chris</asp:ListItem>
            <asp:ListItem>Shynne</asp:ListItem>
            <asp:ListItem>Chu</asp:ListItem>
            <asp:ListItem>Mark</asp:ListItem>
            <asp:ListItem>Lilian</asp:ListItem>
            <asp:ListItem>Rod</asp:ListItem>
            <asp:ListItem>Glendzy</asp:ListItem>
        </asp:CheckBoxList>
        <br />
        <br />
        Boss Names:
        <br />
        <asp:CheckBoxList ID="ListBox2" runat="server" Height="149px" SelectionMode="Multiple"
            Width="113px">
            <asp:ListItem>Smith</asp:ListItem>
            <asp:ListItem>Wilson</asp:ListItem>
            <asp:ListItem>Bernaud</asp:ListItem>
        </asp:CheckBoxList>
    </div>
    <br />
    Employee number:
    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <br />
    <br />
    Date joined (month/year)
    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
    <br />
    <br />
    <br />
    <strong>Employee Personal Data
        <br />
        <br />
    </strong>Street Address
    <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
    <br />
    <br />
    city (choose from dropdown)
    <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
    <br />
    <br />
    province = Ontario (default)<br />
    <br />
    postal code
    <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
    <br />
    <br />
    phone number
    <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox><br />
    <br />
    <asp:Button ID="Button1" runat="server" Text="Save" OnClick="Button1_Click" />
    <br />
    </form>
</body>
</html>

Thanks

Asif

Indresh

0 3

Reply
User: Indresh
Replied: on Jan 25, 2017 06:47 AM
Report

Hi Asifpatel,

Please share your cs code.

Asifpate...

0 4

Reply
User: Asifpatel
Replied: on Jan 25, 2017 07:01 AM
Report

Hi Indresh,

I am not able to configure the C# due to lots of my trial and errors. Please review it, It doesnt carry the additional fields yet

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Collections.Specialized;
using System.Text;

public partial class Default : System.Web.UI.Page
{
    private string GetConnectionString()
    {
        //Where DBConnection is the connetion string that was set up in the web config file        
        return System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string strEmployeeName = string.Empty;
        foreach (ListItem item in ListBox1.Items)
        {
            if (item.Selected)
            {
                strEmployeeName += item.Text + ",";
            }
        }
        InsertRecords(strEmployeeName.Remove(strEmployeeName.Length - 1));
    }
    private void InsertRecords(string employeeName)
    {
        SqlConnection conn = new SqlConnection(GetConnectionString());
        SqlCommand cmd = new SqlCommand("INSERT INTO Table1 (Employees) Values(@EmployeeName)", conn);
        cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@EmployeeName", employeeName);
        conn.Open(); cmd.ExecuteNonQuery();
        conn.Close();
        Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Records Successfuly Saved!');", true);
    }
}

Indresh

0 5

Reply
ANSWER
User: Indresh
Replied: on Jan 25, 2017 07:12 AM
Report

Hi Asifpatel,

Please follow below code.

protected void Button1_Click(object sender, EventArgs e)
{
    string strEmployeeName = string.Empty;
    string bossName = string.Empty;
    foreach (ListItem item in ListBox1.Items)
    {
        strEmployeeName += item.Text + ",";
    }

    foreach (ListItem item in ListBox2.Items)
    {
        bossName += item.Text + ",";
    }

    InsertRecords(strEmployeeName.Remove(strEmployeeName.Length - 1), bossName.Remove(bossName.Length - 1));
}

private void InsertRecords(string employeeName, string bossName)
{
    SqlConnection conn = new SqlConnection(GetConnectionString());
    SqlCommand cmd = new SqlCommand("INSERT INTO EmployeesTest Values(@EmployeeName,@BossName,@EmployeeNumber,@joinedDate,@Address,@city,@postal,@phone)", conn);
    cmd.CommandType = CommandType.Text;
    cmd.Parameters.AddWithValue("@EmployeeName", employeeName);
    cmd.Parameters.AddWithValue("@BossName", bossName);
    cmd.Parameters.AddWithValue("@EmployeeNumber", TextBox1.Text.Trim());
    cmd.Parameters.AddWithValue("@joinedDate", TextBox2.Text.Trim());
    cmd.Parameters.AddWithValue("@Address", TextBox3.Text.Trim());
    cmd.Parameters.AddWithValue("@city", TextBox4.Text.Trim());
    cmd.Parameters.AddWithValue("@postal", TextBox5.Text.Trim());
    cmd.Parameters.AddWithValue("@phone", TextBox7.Text.Trim());
    conn.Open();
    cmd.ExecuteNonQuery();
    conn.Close();
    lblMessage.Text = "Records Successfuly Saved";
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save Multiple ListBox selected Items in Database with commas using C# in ASP.Net

ASP.Net ListBox: Save Multiple Selected Items in the Database

Company

Explore

Follow us

Contact Us