Can have possibility to add a checkbox column in gridview in window application.

Question

1.00/5 (2 votes)

See more:

I have requirement to add a checkbox column in gridview and we can check and uncheck these checkbox and according to that can update in database.
Please help in out. I am stuck in this portion.
Thanks in advance.

Posted 9-Apr-14 9:50am

SumantaDash

Add a Solution

Comments

Sergey Alexandrovich Kryukov 9-Apr-14 15:59pm

What do you mean by "window application"? Which application type?
—SA

ZurdoDev 9-Apr-14 16:02pm

Where are you stuck?

saber rezaii magham 9-Apr-14 16:23pm

Do you need a sample of a datagrid and data fill algorithm?

SumantaDash 10-Apr-14 12:55pm

yes.please

3 solutions

Solution 1

Add DataGridViewCheckBoxColumn column to gridview and handle CellClick event

C#

if (dataGridRow.Cells["YourCheckboxColumn"].Value != null &&    (bool)dataGridRow.Cells["YourCheckboxColumn"].Value)
{
       // Checked
}
else if (dataGridRow.Cells["YourCheckboxColumn"].Value == null)
{
       // Unchecked
}

Call your db update method then.

Posted 9-Apr-14 10:40am

Emre Ataseven

Solution 2

You question is about DataGridView. GridView is for asp.net.
Refer:
1. How-create-check-box-column-datagridview[^]
2. insert-checked-rows-records-of-datagridview-into-database.aspx[^]
For 2, you should change the sql code to Parameterized queries to prevent SQL Injection Attacks in SQL Server[^]

Posted 9-Apr-14 15:20pm

Peter Leow

Updated 9-Apr-14 15:23pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suk@nta · Accepted Answer · 2014-04-10T07:07:00

C#

//it will executed on click of any cell in gridview
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
//it will check the specific column
            if (e.ColumnIndex == dataGridView1.Columns["status"].Index)
            {
                dataGridView1.Rows[e.RowIndex].Cells["status"].Value = !
                                     (bool)dataGridView1.Rows[e.RowIndex].Cells["status"].Value;
                SqlConnection con = new  SqlConnection(ConfigurationManager.ConnectionStrings["newConnectionString"].ConnectionString);
                
                String str = "update DemoTable set Status=" + status +" where Sln=" +    
                               dataGridView1.Rows[e.RowIndex].Cells["ID"].Value;
                con.Open();

                SqlCommand cmd = new SqlCommand(str, con);
                cmd.ExecuteNonQuery();
                
                con.Close();
               
            }
        }

//it is tested one.If it will help you ,then click on the accept solution button
let me know.