How to retrieve datagridview checkbox values

Question

0.00/5 (No votes)

See more:

Hi,

In my project am I using datagridviewcheckbox , I can save this datagridviewcheckbox value in database, Here I want to retrieve the checkbox value in the same datagridviewcheckbox . How Can I do this. For windows application.

Thank You

Posted 23-Oct-15 21:26pm

Mekalamani

Add a Solution

Comments

phil.o 24-Oct-15 3:33am

Unclear. Please describe more precisely your issue. There is not a single value in a DataGridView; it contains items. So please describe more precisely what you want to do that give you troubles.

George Jonsson 24-Oct-15 3:48am

Are you using DataTable or DataSet and BindingSource as the layer between your grid and the database?

Mekalamani 24-Oct-15 5:37am

Thank You
I am using datatable

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)

VR Karthikeyan · Answer 1 · 2015-10-23T21:48:00

Solution 1

Hi Mekalamani, see the below example,

C#

DataTable objTable = new DataTable();
objTable.Columns.Add("Selection", typeof(bool));
objTable.AcceptChanges();

DataRow NewRow1 = objTable.NewRow();
NewRow1["Selection"] = false;
objTable.Rows.Add(NewRow1);

DataRow NewRow2 = objTable.NewRow();
NewRow2["Selection"] = true;
objTable.Rows.Add(NewRow2);

objTable.AcceptChanges();

dataGridView1.DataSource = objTable;

Here, when assigning objTable to dataGridView1.DataSource, the DataGridView automatically display the boolean values as checkbox column. Like this, you can make your datatype to bool for your data, which is to be displayed as DataGridViewCheckBoxColumn.

Posted 23-Oct-15 21:48pm

VR Karthikeyan

Comments

Mekalamani 24-Oct-15 5:40am

Thank You,

I just want to retrieve the datagridview checkboxcolumn value in the same position.

VR Karthikeyan 24-Oct-15 5:47am

Same position means what? Just show your code.

Mekalamani 26-Oct-15 1:46am

I saved the checkbox in checked condition means, when I retrieve the data from backend, the checkbox should be in checked state. Suppose if I saved the checkbox in unchecked condition, while retrieving the data it should be in unchecked condition.

VR Karthikeyan 26-Oct-15 5:20am

Change your column datatype as bit in the database, it will automatically displayed as checkbox column and automatically saves the checkbox column value as bit in the database, just change column's datatype to bit for the column to which you want to display as checkbox column. This will works.

Mekalamani 26-Oct-15 7:44am

Thanka for your answer. I got the answer.

VR Karthikeyan 26-Oct-15 7:45am

Is it working?

Mekalamani 26-Oct-15 7:57am

Yeah, its working
Thank you so much