TO STORE CHECKBOX VALUES IF TRUE(INSIDE A DATAGRIDVIEW) INTO A MYSQL DATABASE

[EDN Admin]

I WANT TO SAVE THE CHECKBOX VALUES IN A PARTICLUAR COLUMN CALLED CHECKBOX IN THE MYSQL DATA BASE WHENEVER THE USER CHECKS THE CHECKBOX AND CLICKS THE SAVE BUTTON.
(IM USING DATAGRIDVIEW WHICH HAS THESE CHECKBOXES)
ALSO I WANT TO KNOW HOW CAN I RESTRICT THE USER FROM NOT SELECTING MORE THAN 2 CHECKBOXES
<br/>

THIS IS THE CODE THAT IVE USED
using System;<br/>
using System.Collections.Generic;<br/>
using System.ComponentModel;<br/>
using System.Data;<br/>
using System.Drawing;<br/>
using System.Linq;<br/>
using System.Text;<br/>
using System.Windows.Forms;<br/>
using MySql.Data.MySqlClient;<br/>
<br/>
<br/>
namespace Training_Form<br/>
{<br/>
    public partial class Form1 : Form<br/>
    {<br/>
        public Form1()<br/>
        {<br/>
            InitializeComponent();<br/>
        }<br/>
<br/>
        private void button1_Click(object sender, EventArgs e)<br/>
        {<br/>
            if (sender == button1)<br/>
            {<br/>
                groupBox2.Enabled = true;<br/>
            }<br/>
<br/>
            string constring = &quot;datasource=localhost;port=3306;username=root;password=root&quot;;<br/>
            MySqlConnection ConDataBase = new MySqlConnection(constring);<br/>
            MySqlCommand cmdDataBase = new MySqlCommand(&quot;select EMPNO,NAME,DESGN,UNIT from krthik.master where EMPNO = &quot; &#43; this.textBox1.Text &#43; &quot;and ELENCASHB = &quot; &#43; this.textBox2.Text &#43; &quot;
;&quot;, ConDataBase);<br/>
            try<br/>
            {<br/>
                MySqlDataAdapter sda = new MySqlDataAdapter();<br/>
                sda.SelectCommand = cmdDataBase;<br/>
                DataTable dbDataset = new DataTable();<br/>
                sda.Fill(dbDataset);<br/>
                BindingSource bSource = new BindingSource();<br/>
                bSource.DataSource = dbDataset;<br/>
                dataGridView1.DataSource = bSource;<br/>
                sda.Update(dbDataset);<br/>
            }<br/>
            catch (Exception ex)<br/>
            {<br/>
                MessageBox.Show(ex.Message);<br/>
            }<br/>
        }<br/>
<br/>
        private void Form1_Load(object sender, EventArgs e)<br/>
        {<br/>
            // TODO: This line of code loads data into the krthikDataSet.training table. You can move, or remove it, as needed.<br/>
            this.trainingTableAdapter.Fill(this.krthikDataSet.training);<br/>
<br/>
        }<br/>
    }<br/>
}





PLEASE HELP ME!<br/>
IVE SEARCHED ROUND THE NET BUT DIDNT GET ANY CONVINCING RESULTS!
(IM NEW TO VISUAL BASIC)

View the full article