Insert muliple checkedListBox values to database in windows

In this blog we will know how to insert multiple checkedListBox values to database in windows.

In this blog we will know how to insert multiple checkedListBox values to database in windows.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace InsertmultipleValueCheckBoxList

{

    public partial class Form1 : Form

    {

        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];

        OleDbCommand com;

 

        public Form1()

        {

            InitializeComponent();

        }

 

        private void Form1_Load(object sender, EventArgs e)

        {

            checkedListBox1.Items.Add("Raj");

            checkedListBox1.Items.Add("Ravi");

            checkedListBox1.Items.Add("Rahul ");

        }

 

        private void btn_insert_Click(object sender, EventArgs e)

        {

            OleDbConnection con = new OleDbConnection(ConnectionString);

            foreach (var checkedItem in this.checkedListBox1.CheckedItems)

            {

                com = new OleDbCommand("Insert into test values('" + checkedItem + "')", con);

                con.Open();

                com.ExecuteNonQuery();

                con.Close();

            }

            MessageBox.Show("Inserted Successfully");

        }

    }

}