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

how can save multiple checkbox in database?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)