Hiding a value in a datagridview cell

Question

I want to be able to hide the second entry of a string in a datagridview cell.

e.g. Data in the cell will look like this:

Apples  1 

Apples  2

Bananas 2

Pears   12

but I want it to look like this (with the numbers hidden, rather than removed):

Apples  

Apples 

Bananas 

Pears

Maybe you can set the visibility of the specific DataGridViewColumn to false? — Daniel Frühauf, Apr 26 '17 at 13:24
@KobyDouek By hidden I mean 'not visible'. Perhaps by changing the colour of the text after the space to white (the background colour). — Claire, Apr 26 '17 at 13:24
@Claire you can't change **part** of a string to different color.. that would be aweful. What are you trying to achieve exactly? Why not remove the numbers from the string? — Koby Douek, Apr 26 '17 at 13:26
@KobyDouek The text after the space is useful to me, but not the user. — Claire, Apr 26 '17 at 13:28

aperezfals · Accepted Answer · 2017-04-26T15:07:18.510

You can work with the format of the column, and chage the text, like this:

private void dataGridView1_CellFormatting(object sender, 
        System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
    {
        if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("YourColumnName"))
        {
            string val = e.Value.ToString();
            e.Value = val.SubString(0, val.IndexOf(" "));
        }
    }

You must suscribe to the CellFormatting event of the datagrid. For more info about CellFormatting look here.

If you want to play with the color of the second word use this

void datagridview_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
        {
            if (e.ColumnIndex  == 1 && e.Value != null)
            {
                string content = e.Value.ToString();
                string[] line = content.Split(' ');
                StringFormat sf = new StringFormat();
                sf.Alignment = StringAlignment.Center;
                sf.LineAlignment = StringAlignment.Center;

                e.Paint(e.CellBounds, DataGridViewPaintParts.All & ~DataGridViewPaintParts.ContentForeground);

                SizeF[] size = new SizeF[line.Length];
                for (int i = 0; i < line.Length; ++i)
                {
                    size[i] = e.Graphics.MeasureString(line[i], e.CellStyle.Font);
                }

                RectangleF rec = new RectangleF(e.CellBounds.Location, new Size(0, 0));
                using (SolidBrush bblack = new SolidBrush(Color.Black), white = new SolidBrush(Color.White))
                {
                    for (int i = 0; i < line.Length; ++i)
                    {
                        rec = new RectangleF(new PointF(rec.Location.X + rec.Width, rec.Location.Y), new SizeF(size[i].Width, e.CellBounds.Height));
                        if (i % 2 == 0)
                        {
                            e.Graphics.DrawString(line[i], e.CellStyle.Font, bblack,  rec, sf);
                        }
                        else
                        {
                            e.Graphics.DrawString(line[i], e.CellStyle.Font, white, rec, sf);
                        }
                    }

                }

                e.Handled = true;
            }

        }

Suscribe the datagrid to the CellPainting event.

Instead of removing the second value of the cell, how would I display the colour as white, but keep the first value of the cell black? — Claire, Apr 26 '17 at 14:52
I edited the answer to your needs, I tested it myself. It works! — aperezfals, Apr 26 '17 at 15:07
If this worked for you, please, mark the answer as correct and vote for it. Thanks! — aperezfals, Apr 26 '17 at 15:16

score 0 · Answer 2 · answered Apr 26 '17 at 13:18

0

You can use Split function of string. Split function will split your string with given character parameter. For example cell.value.split(' ')[0]. https://www.dotnetperls.com/split

answered Apr 26 '17 at 13:18

Adil Ansari

346
2
13

Koby Douek · Answer 3 · 2017-04-26T14:21:03.493

0

If you want to make the number invisible on white background, without removing it from the string, you can use this trick:

string[] arr = cell.Text.Split(' ');
cell.Text = HttpUtility.HtmlDecode(string.Format("{0} <font color='{1}'>{2}</font>", arr[0], arr[1], e.sub.backcolor));

edited Apr 26 '17 at 14:21

answered Apr 26 '17 at 13:32

Koby Douek

16,156
19
74
103

Thank you, but it is not a web application so I cannot use 'HttpUtility'. Could I do something similar but assign the second part to 'e.sub.backcolor'? – Claire Apr 26 '17 at 14:18
What is `e.sub.backcolor` ? – Koby Douek Apr 26 '17 at 14:19
The background colour of the datagridview cell – Claire Apr 26 '17 at 14:20
See my updated answer. It might not work since I cannot see your code, but that is the direction. – Koby Douek Apr 26 '17 at 14:21

score 0 · Answer 4 · edited May 23 '17 at 12:34

0

It looks like the numbers are at a fixed position inside the cells. If so, you could use padding to shrink the display area of the cell, like I described in my answer on sometimes I want to hide buttons in a DataGridViewButtonColumn

edited May 23 '17 at 12:34

Community

1
1

answered Apr 26 '17 at 20:39

Tobias Knauss

3,361
1
21
45

score 0 · Answer 5 · answered Oct 08 '21 at 16:27

.NET won't let you set the .Visible property of an individual cell; only the entire column. I have tricked out individual cells to seem invisible by setting the background color to that of the DataGridView. Eg, where my DataGridView is named dgvAccounts:

cells[2].Style.BackColor = dgvAccounts.BackgroundColor;

Hiding a value in a datagridview cell

5 Answers5