[RESOLVED] [2005] Gridview Question

[Besoup]

Hey folks!
I got a gridview that is displaying some data from a dataset. One of the fields in the datatable fields holds a 1 digit alpha code(ex a,b,c etc..). Each letter represents something different. Is there a way I could show the description instead of the letter? There is only a total of 10 letters being used, so I don't know if I could just put in a select statement somewhere to display what I want?

[Besoup]

got it... didn't think it would be that simple.

With gvItemList
                For i = 0 To .Rows.Count - 1
                    If .Rows(i).Cells(7).Text = "G" Then
                        .Rows(i).Cells(7).Text = "Retail"
                    End If
                Next
            End With