In my sp (sql server) Im selecting a value like this:

SELECT ROUND(WHATEVER,3) AS WHATEVER FROM MYTABLE

I want the value rounded with 3 decimals.

I execute the SP and in the returned dataset I get the value, and there it is something like "3,000,000" Even though I stated that I want 3 decimals only. I guess it has something to do with the dbtype of the column in the dataset, but where should I then perform the round?

I have another problem!!!!! In dev studio, I often get this message:

An unhandled exception of type 'System.OutOfMemoryException' occurred in system.drawing.dll

Additional information: Out of memory.
kind regards
henrik