formatting numbers to currency

john kanyora

am having trouble formating my numbers to currency..am drawing a bar chart and i want to have the numbers in the form of currency.what am getting is just integers for example instead of getting 200.00 am getting just 200.below is my code`

string connect=TraceBizCommon.Configuration.ConfigSettings.ConnectionString;

SqlConnection conn = new SqlConnection(connect);
conn.Open();
SqlCommand cmd = new SqlCommand("select substring(Customer, 1,8),[Total Amount] from CustomerDebts ", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string[] x = new string[dt.Rows.Count];
decimal[] y = new decimal[dt.Rows.Count];
for (int i = 0; i
{
x[i] = dt.Rows[i][0].ToString();
y[i] = Convert.ToInt32(dt.Rows[i][1]);
}
BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries { Data = y});
BarChart1.CategoriesAxis = string.Join(",", x);
BarChart1.ChartWidth =500.ToString();//(x.Length * 100).ToString();
BarChart1.ChartHeight = 600.ToString();//(y.Length * 75).ToString()`

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
Accepted answer
He6 J9hn When your data type is decimal then string.format will not work because it returns string datatype. Do try the code that I had given in my earlier reply. Do let me know if it works.
john kanyora8y ago
@Amit.. i have values which i want to represent as currency that is to have the fromat of currency.so am trying to convert the string to decimal or whatever will work.
from the graph above, those values at the end of the bars i want them to be in this form , for example instead of 6200 i want it to be 6200.00..i hope you get it now Amit.please help me
Amit Gupta8y ago
Can you explain your exact problem, where you are facing and what you are looking for
john kanyora8y ago
@Amit, it did not work..kindly help me out
8y ago
https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql
john kanyora8y ago
Thanks..Rafnas i have implemented ur suggestion but am getting this error that" cannot implicitly convert type 'string' to 'decimal'...kindly help out
Amit Gupta8y ago
Change your line from int to decimal
y[i] = Convert.ToInt32(dt.Rows[i][1]);
To
y[i] = Convert.ToDecimal(dt.Rows[i][1]);
Rafnas T P8y ago
hi,
]
to convert curency format try as below

for (int i = 0; i
{
x[i] = dt.Rows[i][0].ToString();
y[i] = string.Format("{0:##,##0.00}",Convert.ToInt32(dt.Rows[i][1]));
}

or

y[i] =string.Format("{0:C}",Convert.ToInt32(dt.Rows[i][1]));

or

y[i] =Convert.ToInt32(dt.Rows[i][1]).ToString("c");
john kanyora8y ago
Laxmidhar , i have tried that but its not working..let me send you the screen shot of the graph and explain what i mean. from the graph those values on the bars for example the first one ,6200, i want it to be 6200.00..thas what am trying to achieve.
Laxmidhar Sahoo8y ago
what is the data type of BarChart1.ChartWidth ? in the bellow code

BarChart1.ChartWidth =500.ToString();

if the data type string then that should
instated of 500.ToString(); please write Convert.toString(500)
john kanyora8y ago
thanks Altaf, my question is now where do i put this line of code because from my code you can see am drawing a graph..kindly help me fix it in my code
Altaf Ansari8y ago
int money = 1000;
Response.Write(string.Format("{0:C}", money));
Try this..