how to use datagridview checkbox column to check the desired records to insert into sql server database

Question

0.00/5 (No votes)

See more:

Hello,

i'm newbie and still learning.
i'm going to use datagridview checkbox column to check the desired records to insert
into sql server database, the process i want is after checking some of the checkBoxes and then do the insert query on a button click. The values i want to save (insert) into database is from selected row in datagridview.
how to do the code? (with example please).

please kindly help me, I appreciate every answer.

thank you.

Posted 17-Sep-13 17:57pm

Luvivica

Updated 17-Sep-13 18:10pm

v2

Add a Solution

1 solution

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)

Midnight Ahri · Accepted Answer · 2013-09-17T18:13:00

Solution 1

You can simply loop the datagridview row using for, and inside the looping, use if to check if the checkbox is true, if it is then execute your insert query.

Improve :

C#

for (int i = 0; i <= this.dataGridView1.Rows.Count - 1; i++)
{
    if ((bool)this.dataGridView1.Rows[i].Cells["ColName"].Value == true)
    {
        //your query execution here
    }
}

not sure but, worth trying.

Posted 17-Sep-13 18:13pm

Midnight Ahri

Updated 17-Sep-13 18:37pm

v2

Comments

Luvivica 18-Sep-13 0:19am

thanks for the answer Midnight, but i'm still not get what you telling me. can you show some code for example?

Midnight Ahri 18-Sep-13 0:37am

I changed the solution, "ColName" is the name of your checkbox column.
Tell me if it works.

Luvivica 18-Sep-13 1:18am

not working..
the error display "object reference not set to an instance of an object"

Midnight Ahri 18-Sep-13 1:21am

You had to make sure the cell had value.

Luvivica 18-Sep-13 1:44am

i fill the datagridview on form load event, so yes it is have the value from database table i load.

i will illustrate my form,
my form have 3 columns, choose, benefit and detail.
when checkbox(choose) checked i want to save the checked row to new database table. at this step i can't do what i want.

Midnight Ahri 18-Sep-13 2:02am

FYI, Object reference not set to an instance of an object means something is null.
And I'm refering to "(bool)this.dataGridView1.Rows[i].Cells["ColName"].Value"
If you're still sure everything is not null, then you had to find out where the error occur and what's null there.

If you're saying my code is not working, then you had to find another solution.
My suggestion, put a breakpoint and search for the code that return that error.

Luvivica 18-Sep-13 2:22am

midnight, i think i got the problem, the database table where i will use to save the selected row, have a column with tinyint datatype to save checked checkbox.
so if user checked 2 or more row this column have to save numeric number start from 0. how to set the value?

Midnight Ahri 18-Sep-13 2:29am

So am I wrong about the null value?

I'm not sure what you're doing there, but if you use my code above, you can simply add a int variable and +1 it everytime the loop enter the if.

for (int i = 0; i <= this.dataGridView1.Rows.Count - 1; i++)
{
if ((bool)this.dataGridView1.Rows[i].Cells["ColName"].Value == true)
{
//your query execution here
x += 1;
}
}

Addition :
Save the x variable.