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

}

}

}