formatting numbers in data grid

My datagrid doesnot show the numbers (price,rate) in the same format as the SQL query returns....

means fields like Price, Rate as sent by backend are like this...
1200.00, 150.00

but they look in the grid like this

1200, 150.1

how do we show the same format as sent by the backend.

though dates and time donot have this problem...

please help with the numbers:confused: :confused:

use a datagrid style to create a custom datacolumn style you can then set the output display to be in any format you wish

MSDN has a great little article demonstrating exactly how to customise the datagrid.

Format these in coming numbers before you put them into the Grid! something similar to this :

VB Code:

MsgBox(Format(32003, "0#-####"))

Dim dv As DataView
dv = x.GetDataView(SQLString)
DataGrid1.DataSource = dv

.... where SQLString is a Procedure Call in which everything is already formatted. Means from backend it comes well formatted. but the same format doesnt show in grid.

Create a template column, and use a custom binding expression for the label in the column. Something like this:

DataBinder.Eval(Container.DataItem, "MyPriceField", {0:c})

That is how I do it in ASP.Net with the web datagrid. I haven't checked if it works for the Win Forms datagrid.