Solved

How to format with $ in Datagrid and Decimal Type Column?

Posted on 2007-11-18
7
1,576 Views
Last Modified: 2013-11-26
Hi,

I have a datatable that I am filling with a SQL Adapter. The sql query looks something like

SELECT price1,price2 from prices

Now, I do some calculations and want to display the values in the datatable with a $.
such as:

(See code snipped)

Here is the error:
Input string was not in a correct format.Couldn't store <$1,125.00> in sell Column.  Expected type is Decimal.

grr, how can I show the values with a $?
num3 = ((Convert.ToDecimal(mSubTable.Rows[i][5]) * (Convert.ToDecimal(mSubTable.Rows[i][6]) * .01M) + Convert.ToDecimal(mSubTable.Rows[i][5])));
mSubTable.Rows[i][7] = num3.ToString("$#,#,##.#0");

Open in new window

0
Comment
Question by:melegant
  • 3
  • 2
  • 2
7 Comments
 
LVL 22

Expert Comment

by:RedKelvin
ID: 20309401
Hi,
you will need to cast your column to string, this can be done in your SQL for example this is how you would achieve this in Oracle

SELECT to_char(price1), to_char(price2) from prices

then when the columns are bound to your grid they are considered to be strings instead of decimal columns, and you can add the $.

RedK
0
 
LVL 15

Expert Comment

by:Solar_Flare
ID: 20309407
you cant put a string in a decimal column, you have 2 options"

add another column with datatype string and put the values with $ symbols in that column, or if your datagrid has predefined columns then you can enter a format of "C" for that column and it will format it as a $ string for display.

if your datagrid needs in-place editing which needs to update the datasource then you will need to use the second method.
0
 

Author Comment

by:melegant
ID: 20309432
Solar,
My grid is being populated with a sqladapter and I am mapping the schema from the source. How can I format the column after the fact with the C as you mentioned?
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 22

Expert Comment

by:RedKelvin
ID: 20309511
Cast the columns to strings in the SQL as I already mentioned, What DB are you using?
0
 

Author Comment

by:melegant
ID: 20309552
Hi Red,

I can do that yes, however I would have to go and alter a bunch of SP's which I am not crazy about doing.

The issue here is that I have an Infragistics Ultragrid where I am displaying the values..and I want to display the values as currency. I am using SQL and my datatype for these particular fields is Decimal (18,0).

I know how to parse it once it is a currency (Numberstyles.Any with a Decimal.Parse).

There must be a way for the column to take a deicmal as currency..it would be crazy not to!

0
 
LVL 15

Accepted Solution

by:
Solar_Flare earned 250 total points
ID: 20309652
Can you access the Columns collection of the grid? if you can then you might be able to set the format of the cells after  the columns have been generated...

in a normal datagridview control you have .Columns which is a collection, and then each column has a DefaultCellStyle and one of the style's properties is named Format which you can set.


maybe look at the ultragridview documentation and see if there are similar properties available, in which case you could do something like this


ultragridviewcolumn col = myGrid1.Columns["price1"];
col.DefaultCellStyle.Format = "C";

0
 

Author Comment

by:melegant
ID: 20309691
ha..that is it..and it was simple. Thanks! Have to do it during the grid init event...

e.Layout.Bands[0].Columns[6].Format = "$##,##.00";
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question