DataSet Expression Question

[Sammy]

Is there a way to use the expression property for a datacolumn to specify
the number of digits after the decimal place? Is there another way of doing
this without having to code it myself?

Thanks

 

[William Ryan eMVP]

You can use a DataGridTableSytle and then use the DataGridColumnStyle to
specify the format of the column. This is done totally independent of the
Expression property

http://tek-tips.com/gviewthread.cfm/pid/732/qid/835262

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/

 

[Sammy]

This is not to show to user in a datagrid but rather to persist in the db.
So, I was looking for a way to round the "double" value to hold 3 decimal
places without having to use the Math class.

Thanks

 

[Guest]

Hi, Samm

I don't think that you can achieve this with expressions. DataColumn's Expressions only have some simple functionalities
So you can do either:
change the SQL code to convert the original data to the decimal value you want
or
do the manual computing using math functions.