Datagrid Conditional

~Bean~ · July 22nd, 2005, 01:54 PM

In my datagrid I have a bound column that display a boolean (1 or 0) value. Instead of the "1" or "0" I want it to display "Yes" or "No"...

how can I do this?

I thought of using a stored procedure with an "If" statement but I really don't know the slightest thing about sp's...

-------------------------
Beware of programmers with screwdrivers...

~Bean~ · July 22nd, 2005, 02:37 PM

Dunno if there's a better way to do this, and I can't believe it but I solved this one myself using a sp...

I created the sp like so,

Code:

CREATE PROCEDURE dbo.sp_Examples

AS
    SELECT DISTINCT id, Name, Active, "ActiveText"=
    CASE WHEN Active = 0 THEN    
        "No"
    WHEN Active = 1 THEN
        "Yes"
    END
    FROM tblExamples 
    RETURN
GO

then just referenced the field ActiveText in my datagrid bound column...

sweet...

-------------------------
Beware of programmers with screwdrivers...

jbenson001 · July 25th, 2005, 11:59 PM

Assuming that your column is defined as a bit, you can use this in the datagrids ItemDataBound Event:

        If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
            If CBool(e.Item.Cells(1).Text) = 0 Then
                e.Item.Cells(1).Text = "No"
            Else
                e.Item.Cells(1).Text = "Yes"
            End If
        End If

However, I suggest your keep your solution as is in the SP.

chambrick · July 27th, 2005, 12:40 AM

Cool.

Good for you.

I think doing it on the SQL side will offer more efficient processing time.