Customize a column of DataGridViewCheckBoxCell to display string?

Question

4.00/5 (1 vote)

See more:

Could you please help me out with this problem, I have a column in my SQL table as type of bit (for example, a column of gender) so when loading the table, the DataGridView shows me a column of checkboxes without any text, the male gender is checked (the bit value is 1) and female gender is unchecked (the bit value is 0). I don't like it that way which looks ugly to me, I want to customize or do something to format the content of each cell in that column of DataGridViewCheckBoxCell so that a string of "Male" replaces the checked checkbox and a string of "Female" replaces the unchecked checkbox.

The problem will be sorted out easily if I change my original column to another column type like varchar to store the strings of "Male" and "Female" directly, but I like to use bit instead, maybe it's a way to save storage, isn't it?

Thank you for your help!

Posted 26-Dec-12 4:09am

supernorb

Add a Solution

2 solutions

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)

Mike Hankey · Accepted Answer · 2012-12-26T05:24:00

Solution 1

One way this could be done is to create a custom DataGridView column as described here[^].

Posted 26-Dec-12 5:24am

Mike Hankey

supernorb · Accepted Answer · 2012-12-26T06:32:00

Thank you Mike Hankey for the good link, inheriting DataGridViewCell and DataGridViewColumn is OK but it is not simple enough and I chose another solution which only adds some lines of code to the CellPainting handler of the datagridView, here is the code I tried, it works perfectly:

C#

private void HS_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
        {
            if (HS.Columns[e.ColumnIndex].CellTemplate.GetType() == typeof(DataGridViewCheckBoxCell)&&e.RowIndex > -1)
            {
                e.Handled = true;                
                string s = (bool)e.Value ? "Male" : "Female";
                e.PaintBackground(e.CellBounds, HS.CurrentCellAddress.Y == e.RowIndex);
                StringFormat sf = new StringFormat();
                sf.LineAlignment = StringAlignment.Center;
                e.Graphics.DrawString(s, HS.Font, new SolidBrush(HS.ForeColor), e.CellBounds,sf);                
            }
        }

Thanks!