RE: Formatting a Column in a Datagrid

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

All Sorted :)

"Peter Newman" wrote:

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
.

Relevant Pages

  • Re: MSHFlexgrid displayed value
    ... Whatever formatting you apply to a column when loading the grid will be ... Therefore, depending on the cell content, ... which returns the format string for me. ... and display the value to the user. ...
    (microsoft.public.vb.controls)
  • Formatting a Column in a Datagrid
    ... trying to format the grid and have managed to sort the column headers out and ... Currently a value is displayed in the grid as '10.0000'. ... I format this column to display only 2 decimal places ie '10.00' ...
    (microsoft.public.vsnet.general)
  • Re: Truncate Values in Grid
    ... I need to truncate values from the database and show in the grid. ... it should be formatted to 100.57 and display in the grid. ...
    (microsoft.public.vb.general.discussion)
  • Re: UK Date / Fomatting in Mshflexgrid Problem
    ... > I am working on an invoice sheet which saves data to a database. ... it is saved in whatever format Jet uses to store dates. ... only how Access will display them. ... That line of code is taking a string representation of the date frm the grid ...
    (microsoft.public.vb.general.discussion)
  • Re: Tapble top fusion generator
    ... >increased my monitor format to 1280x1024 and display it on a Mitsubishi ... >using a screen format less than 1280x1024 and the low -resolution LCD ... >Since the poster writing about the character overlap, ... is, when you make one web site viewable, you can render others ...
    (sci.physics.fusion)