How to format values in datagrid/dataset

  • Thread starter Thread starter George Yachán
  • Start date Start date
G

George Yachán

I have added a new column to a typed dataset which displays an expression
which is the result of one double (data type) field divided by another
double field. I would like format this column to show the number as a whole
number percentage, like 67 instead of as, say, .666666666667.

Is there a place in the expression or a dataset column property or a
datagrid
property twhere I can use the Format() function or some other way to specify
the format I would like?

Seems as though express columns may be read only which makes this even more
interesting.

I am looking for an answer other that using the data adapter's SQL Select
statement which populates the dataset in the first place.
 
In order to convert my column to to percent the best I have come up with so
far is to multiply it's expression *100 and to set it's type to Integer.
This is not an elegant solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top