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

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

How to retrieve datagridview checkbox values

1 solution

Solution 1

Add your solution here

Preview 0

How to retrieve datagridview checkbox values

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us