Formatting a Column in a Datagrid

#1

VS 2005 VB.Net ( Vb.2005 )
I have a datagrid which is filled from a SQL stored procedure. I have been
trying to format the grid and have managed to sort the column headers out and
highlight rows based on a cell content.

My problem is that I have a column called "OPENBALANCE" which is a
moneyfield. Currently a value is displayed in the grid as '10.0000'. How can
I format this column to display only 2 decimal places ie '10.00'

Any help would be appricated

#2

All Sorted

"Peter Newman" wrote:

Quote:

VS 2005 VB.Net ( Vb.2005 )
I have a datagrid which is filled from a SQL stored procedure. I have been
trying to format the grid and have managed to sort the column headers out and
highlight rows based on a cell content.

My problem is that I have a column called "OPENBALANCE" which is a
moneyfield. Currently a value is displayed in the grid as '10.0000'. How can
I format this column to display only 2 decimal places ie '10.00'

Any help would be appricated

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Formatting a Column in a Datagrid

Visual Studio.net (General) microsoft.public.vsnet.general

Formatting a Column in a Datagrid - 06-11-2009 , 09:17 AM

RE: Formatting a Column in a Datagrid - 06-12-2009 , 04:41 AM