VSFlexGrid only picture in column and not text.

[cliv]

I maintain an old application who use vsFlexGrid. Grid is bound to a database and one field display 0 and 1 values. I try to replace this value with picture, so in AfterDataRefresh event i have this code:

    With grid
        .Redraw = flexRDNone
        For f = 1 To .Rows - 1
            If .ValueMatrix(f, 2) = 0 Then 
                .Cell(flexcpPicture, f, 2, f, 2) = imgHandleNOK
            Else
                .Cell(flexcpPicture, f, 2, f, 2) = imgHandleOK
            End If
            .Cell(flexcpPictureAlignment, f, 2, f, 2) = flexAlignCenterCenter
        Next f
        .Redraw = flexRDDirect
    End With

... but grid display image and textvalue from database.


I can't use

.ColImageList(2) = imgList.hImageList 'handle to an ImageList

because image are stored in a ImageManager control from Codejock Activex and the control doesn't deliver the handle. I obtain one by one image using this code:

    Dim imgHandleOK As StdPicture, imgHandleNOK As StdPicture
    Set imgHandleOK = ImageManager.Icons.GetImage(1, 16).CreatePicture(xtpImageNormal)
    Set imgHandleNOK = ImageManager.Icons.GetImage(2, 16).CreatePicture(xtpImageNormal)

...so can i display only image in column?

[Arnoutdv]

And what if you set .TextMatrix to ""

With grid
        .Redraw = flexRDNone
        For f = 1 To .Rows - 1
            If .ValueMatrix(f, 2) = 0 Then 
                .Cell(flexcpPicture, f, 2, f, 2) = imgHandleNOK
            Else
                .Cell(flexcpPicture, f, 2, f, 2) = imgHandleOK
            End If
            .Cell(flexcpPictureAlignment, f, 2, f, 2) = flexAlignCenterCenter
            .TextMatrix(f, 2) = ""
        Next f
        .Redraw = flexRDDirect
    End With

[cliv]

And what if you set .TextMatrix to ""

Doesn't work ... maybe because grid is bound.

[Arnoutdv]

Is there a specific reason for having the grid bound to a dataset?
In other words can it be disconnected?

[Mojtaba]

I maintain an old application who use vsFlexGrid. Grid is bound to a database and one field display 0 and 1 values. I try to replace this value with picture, so in AfterDataRefresh event i have this code:

...so can i display only image in column?

-----------------------------------------------
Hi
The best case is to hide the field from which you get the information and assign the image to a new field.

[cliv]

Is there a specific reason for having the grid bound to a dataset?
In other words can it be disconnected?

as i say it's and old application written more than 20 years ago with a lot of grid bound so change all involves a lot...

The best case is to hide the field from which you get the information and assign the image to a new field.

...yes it is a solution