Insert muliple 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");

        }

    }

}