How to save multiple checkbox values in database in c#

Question

how to save the datagridview checkbox value save it into the database using csharp.

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 Checked_record__datagridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; OleDbCommand com; public Form1() { InitializeComponent(); } private void btn_insert_Click(object sender, EventArgs e) { int i = 0; List ChkedRow = new List (); for (i = 0; i { if (Convert.ToBoolean(dataGridView1.Rows[i].Cells["chkcol"].Value) == true) { ChkedRow.Add(i); } } if (ChkedRow.Count == 0) { MessageBox.Show("Select one checkbox"); return; } foreach (int j in ChkedRow) { str = @"INSERT INTO test1(Did,Dname) VALUES ('" + dataGridView1.Rows[j].Cells["Did"].Value + "', '" + dataGridView1.Rows[j].Cells["Dname"].Value + "');"; try { using (OleDbConnection con = new OleDbConnection(ConnectionString)) { using (com = new OleDbCommand(str, con)) { con.Open(); com.ExecuteNonQuery(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } MessageBox.Show("Records successfully inserted"); } private void Form1_Load(object sender, EventArgs e) { dataGridView1.AllowUserToAddRows = false; dataGridView1.Columns.Clear(); DataGridViewCheckBoxColumn col1 = new DataGridViewCheckBoxColumn(); col1.Name = "chkcol"; col1.HeaderText = "CheckBox"; dataGridView1.Columns.Add(col1); OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from test "; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); DataSet ds = new DataSet(); oledbda.Fill(ds, "test"); dataGridView1.DataMember = "test"; dataGridView1.DataSource = ds; } } }

Arjun Walmiki · Answer

Hi all if i want bind new checkbox list from database as per multiple checkbox values condition how can is possible is some one pls explain.

Iftikar Hussain · Answer

you can do like this foreach(DataGridItem dgi in myGrid.Items) { CheckBox myCheckBox = (CheckBox)dgi.Cells[0].Controls[1]; if(myCheckBox.Checked == true) { //your code to save } } Regards, Iftikar

Iftikar Hussain · Answer

Please share your code for defining chekbox in datagridview. Regards, Iftikar

ZAIN ULARIFEEN · Answer

lock it my question in the details

Iftikar Hussain · Answer

Hi, How you are defining the multiple checkboxes in your application? Is it CheckBoxList or multiple checkbox element? Regards, Iftikar

Sanjeeb Lenka · Answer

hi, try like this: String str = ""; for (int i = 0; i { if (CheckBoxList1.Items[i].Selected) { if (str == "") { str = CheckBoxList1.Items[i].Text; } else { str += "," + CheckBoxList1.Items[i].Text; } } } it will create a string str with comma separated checkbox values. then insert the string str to your database column.

How to save multiple checkbox values in database in c#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)