I've got a datagridview bound to Sql2k database. When the image columns
return null, I get the goofy looking [X] in the column instead of a blank.
Anyone know how to make that just appear as empty instead of the default
[X]? I would also like that to appear as empty when I insert a new row
instead of the [X] if that is possible.

Hi,

"Earl" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've got a datagridview bound to Sql2k database. When the image columns
> return null, I get the goofy looking [X] in the column instead of a blank.
> Anyone know how to make that just appear as empty instead of the default
> [X]?

You can set "someColumn.DefaultCellStyle.NullValue = null;".

> I would also like that to appear as empty when I insert a new row instead
> of the [X] if that is possible.

If you want this too, then *instead* you can handle the cell paint event:

private void dataGridView1_CellPainting(object sender,
DataGridViewCellPaintingEventArgs e)
{
// suppose 2nd column is a image column
if ((e.ColumnIndex == 1) && (e.FormattedValue == e.CellStyle.NullValue))
{
DataGridViewPaintParts pp = e.PaintParts &
~DataGridViewPaintParts.ContentForeground;
e.Paint(e.ClipBounds, pp);
e.Handled = true;
}
}

HTH,
Greeting


>
>

Thanks Bart, that helped.

"Bart Mermuys" <(E-Mail Removed)> wrote in message
news:18%7h.193089$(E-Mail Removed)...
> Hi,
>
> "Earl" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I've got a datagridview bound to Sql2k database. When the image columns
>> return null, I get the goofy looking [X] in the column instead of a
>> blank. Anyone know how to make that just appear as empty instead of the
>> default [X]?
>
> You can set "someColumn.DefaultCellStyle.NullValue = null;".
>
>> I would also like that to appear as empty when I insert a new row instead
>> of the [X] if that is possible.
>
> If you want this too, then *instead* you can handle the cell paint event:
>
> private void dataGridView1_CellPainting(object sender,
> DataGridViewCellPaintingEventArgs e)
> {
> // suppose 2nd column is a image column
> if ((e.ColumnIndex == 1) && (e.FormattedValue == e.CellStyle.NullValue))
> {
> DataGridViewPaintParts pp = e.PaintParts &
> ~DataGridViewPaintParts.ContentForeground;
> e.Paint(e.ClipBounds, pp);
> e.Handled = true;
> }
> }
>
> HTH,
> Greeting
>
>
>>
>>
>
>