Displaying x decimal places in a datagrid.

[Les Hughes]

Hey guys (and gals!),

I have a dataset brought back from sqsl server, where some of the
columns are already rounded within the dataset (retrieved using SELECT
ROUND(data, decimalplaces) as myData...etc)

In my datagrid, say the value is 1.15, it displays 1.150000000.

Some columns are text columns, some need to only show 2 decimal places,
and others need to only show 1.

Is there an easy way of specifing which datagrid colums show what about
of decimal places somewhere in the code?

Thanks heaps,

Les

 

[Cor Ligthert]

Les,

I think that this link will give you the answer to your question.

http://msdn.microsoft.com/library/d...ormsdatagridtextboxcolumnclassformattopic.asp

I hope this helps?

Cor

However you can use the