c# - WinForms dev express bind true/false column with a checkbox

Question

I'm working on a Windows Forms project and I have some data in a XtraGrid.GridControl with these columns:

ID, Description, To Process

I'm loading these data from database, and the column To Process contains a boolean field.

I would like to have instead of the current 1 and 0 values a checkbox, that will be checked if the value is 1 and unchecked if the value is 0.

How can I achieve this with Dev Express 16?

---

This is what I did so far:

• imported a DevExpress.XtraGrid.GridControl in my form Design;
• added three columns ID, Description and To Process;

• populated the GridControl DataSource from code behind with this method:

  private void LoadTableData()
  {
    // initialization
    gcTable.DataSource = null;
  
    string query = " SELECT id, description, to_process FROM test_table ";
    DataTable dt = Utils.ExecuteQuery(query);
  
    if (dt != null && dt.Rows.Count > 0)
    {
      gcTable.DataSource = dt;
    }
  }
  

As now, I have my table populated but with 1 and 0 values in the column To Process.

标签： c#winformsdevexpress

Answer 1

Assign a RepositoryItemCheckEdit to your To Process column's ColumnEdit property and set its ValueChecked and ValueUnchecked properties if necessary. More information here.