Formatting String in Datagrid

[xianxian]

Hi guys,

does anyone know how to format strings this way:-

i have 1 column(unit_num) in my Datagrid which displays eg. "01-123"
i have to display only the floor level of the unit number, the first 2
digits(the number before the '-')

how can i do this in the "Data Formatting Expression" of the Datagrid?


thanks in advance,
xianxian

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***

[Elton Wang]

Hi there,

You can process the string in datagrid_itemdatabound event.

HTH
"xianxian" <xianxian@devdex.com> wrote in message news:uA1SGvRuFHA.3236@TK2MSFTNGP14.phx.gbl...
Hi guys,

does anyone know how to format strings this way:-

i have 1 column(unit_num) in my Datagrid which displays eg. "01-123"
i have to display only the floor level of the unit number, the first 2
digits(the number before the '-')

how can i do this in the "Data Formatting Expression" of the Datagrid?


thanks in advance,
xianxian

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***

[xianxian]

hi again,

thanks for yr reply.
this is what i did in ItemDataBound & it works =) thanks a lot!

If e.Item.ItemIndex >= 0 Then

':: Format the DataGrid columns ::

':: Get the text from column to format ::
Dim lvl As String
lvl = e.Item.Cells(4).Text

':: Replace with the formatted text ::
e.Item.Cells(4).Text = Left(lvl, 2)

End If

regards,
xianxian

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***

[Elton Wang]

Good work!



More common way to distinguish datagriditem is



If (e.Item.ItemType = ListItemType.Item Or e.Item.ItemType =
ListItemType.AlternatingItem Then

' Process



End If



HTH

"xianxian" <xianxian@devdex.com> wrote in message
news:e4ZX7ipuFHA.2212@TK2MSFTNGP15.phx.gbl...

> hi again,
>
> thanks for yr reply.
> this is what i did in ItemDataBound & it works =) thanks a lot!
>
> If e.Item.ItemIndex >= 0 Then
>
> ':: Format the DataGrid columns ::
>
> ':: Get the text from column to format ::
> Dim lvl As String
> lvl = e.Item.Cells(4).Text
>
> ':: Replace with the formatted text ::
> e.Item.Cells(4).Text = Left(lvl, 2)
>
> End If
>
> regards,
> xianxian
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***