datagrid tablestyle

[EyeTalion]

in my datagrid I have a field that returns a number I would like to format the number:

1 = reconciled
2 = unreconciled

how do I format that field?

heres my tablestyle layout for that field...

Dim grdColStyle10 As New DataGridTextBoxColumn()
        With grdColStyle10
            .HeaderText = "Status"
            .MappingName = "status_ind"
           .Width = 50
            .Alignment = HorizontalAlignment.Center
            .ReadOnly = True
        End With

[Lunatic3]

There is a Format property of DataGridTextBoxColumn()
Cant you use that?

[EyeTalion]

do you have an example?

[Lunatic3]

Dim grdColStyle10 As New DataGridTextBoxColumn()
        With grdColStyle10
            .HeaderText = "Status"
            .MappingName = "status_ind"
           .Width = 50
            .Alignment = HorizontalAlignment.Center
            .ReadOnly = True
            [b].Format="format string here"[/b]
        End With

Ofcourse i cant understand what you mean by 1 = reconciled and 2 = unreconciled.

[EyeTalion]

the field I'm getting from the database is a status indicater...it is going to have ones and twos in there....


1 means the record is RECONCILED
2 means the record is UNRECONCILED


when I grab the data from the database and put it in my datagrid it comes over as ones and twos...the users have no idea what that means, so I want to format the field with RECONCILED and UNRECONCILED....so, if I use format = ""....where do I run a check to see if it's a 1 or 2?

[Lunatic3]

Oh I see. That seems another story. Is the data on this special field going to be edited by the user or not? if yes what should she enter? 1 /2 or RECONCILED / UNRECONCILED?

[EyeTalion]

no they only are going to be able to view the data grid...inquiry only!..

[Lunatic3]

In that case i think its better to format it when you retrive the data from the database.
your select statement will look something like this:
Select IIF(myfield=1,"RECONCILED","UNRECONCILED?") As newfiled From mytable Where .....

[EyeTalion]

cool, thanks luna