We are using PostgreSQL "point data" for a coordinate system (ie: latitude
longitude). Browsing a location table using phpPgAdmin shows for example

(29.451972,-98.748106) this is what we want.

My web app uses a Microsoft GridView and the corresponding point shows up
in the grid column as

(29.451972000000001,-98.748106000000007)

I cannot seem to round the values down and have been guessing at the format
specifier after reading this:
http://msdn2.microsoft.com/en-us/net.../aa569608.aspx

"{0:{{0.000000}}}"
had no effect: it was no different than if it was not coded up.

"{0:{{0.000000}}} {1:{{0.000000}}}"
gave an error that two values were expected but only one supplied.


I tried various combinations before giving up. I do not know how to format
the output (using the built in item format) so that the grid shows a pair of
values to only 6 places each. It seems I will have to format my own output
string and substitute it at RowDataBound time. The above format strings
work OK for fields with just single floats.


--
================================================== ====================
Joseph "Beemer Biker" Stateson
http://ResearchRiders.org Ask about my 99'R1100RT
================================================== ====================