how can save multiple checkbox in database?

Question

Satyapriya Nayak · Answer

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