how can save multiple checkbox in database?
how can save multiple checkbox in database?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Jan 22, 2014, 4:48 AM
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");
}
}
}