Use DataGridView CheckBox Column for a string data column

Question

I have this table in database:

applicant  |  module  |  date  |  approvation  | 
  xxxx         xxxx      xxxx        xxxxxxx
  yyyy         yyyy      yyyy        yyyyyyy
  tttt         tttt      tttt        ttttttt

I have this db table. After query I assign DataTable to my DataGridView.DataSource:

QueryAssist qa = new QueryAssist();
DataTable dt = new DataTable();
dt = qa.runQuery('myquery');

dgvApprovazione.DataSource = dt;
dgvApprovazione.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);

// modify, transform 2nd column in cellLink
foreach (DataGridViewRow row in dgvApprovazione.Rows)
{
    row.Cells[1] = new DataGridViewLinkCell();
}

Now I want to transform column approvation that is a string approved or not approved and show a check box instead.

if value of this cell is approved check box is checked and not modified (onlyread).

something similar:

foreach (DataGridViewRow row in dgvApprovazione.Rows)
{
    if (row.Cells[3].Value.ToString().Equals("APPROVED"))
    {
        row.Cells[3] = new DataGridViewCheckBoxCell();
    }
}

I have a problem to implement ... help me.

It's possible ? How?

recapping:

I want to change a column that value contain is a text/string (approved or not approved ) in checkbox (checked or unchecked)

Sorry for bad english ..

Good alternatives?

Changing the type of Approvation field to boolean in your database table will do the job. — ehh, Mar 31 '16 at 04:43

Reza Aghaei · Accepted Answer · 2018-11-01T05:17:18.783

To store yes/no or on/off or true/false values in database, it's better to use bit data type in sql server, but using a DataGridViewCheckBoxColumn you can show and edit also a string column by setting TrueValue and FalseValue properties.

In the below example I supposed you have a nullable column in database which needs to store values as APPROVED or NOTAPPROVED as nvarchar(50) and you need to edit those values using DataGridViewCheckBoxColumn.

To do so, you should add your column this way using designer or code:

var column1 = new DataGridViewCheckBoxColumn();   
column1.Name = "column1";                         //Name of column
column1.HeaderText= "Is Approved";                //Title of column
column1.DataPropertyName = "approvation";         //Name of field in database
column1.TrueValue = "APPROVED";                   //True value
column1.FalseValue = "NOTAPPROVED";               //False Value
this.dataGridView1.Columns.Add(column1);

This way you show approved or not approved as check boxes, also you are able to edit those values using check box.

If you don't need to edit them and only want to show them, you can set read only property of the column true.

in the beginning, my idea was sliding(foreach) the whole column "approved" or" not approved" (string) ... then create a new column (checkbox column) to be added to the datagridview and if value is "approved" ... checkbox checked, else unchecked checkbox. and only now show the datagridview. I have solved with declare a yes/no fields in db :) .. But u solution is good.. — rul3z, Apr 04 '16 at 17:55
It's better to use bit field as said in answer. But for cases which a user needs to edit (show) a string column using check box, the solution may be useful :) — Reza Aghaei, Apr 04 '16 at 17:57

Use DataGridView CheckBox Column for a string data column

1 Answers1