Input string was not in a correct format.

john kanyora

Hi, am converting string to decimal because i want my values to be represented in decimal form in my bar chart.am getting the error that " Input string was not in a correct format"..

the error is in this line y[i]=Convert.ToDecimal(string.Format("{0}.00",dt.Rows[i][1].ToString()));

am usin this code below

string[] x = new string[dt.Rows.Count];

decimal[] y = new decimal[dt.Rows.Count];

for (int i = 0; i < dt.Rows.Count; i++)

{

x[i] = dt.Rows[i][0].ToString();

y[i]=Convert.ToDecimal(string.Format("{0}.00",dt.Rows[i][1].ToString()));

}

BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries {Data=y });

BarChart1.CategoriesAxis = string.Join(",", x);

BarChart1.ChartWidth = 500.ToString();

BarChart1.ChartHeight = 600.ToString();

}

kindly help

16 Replies

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

Dharmraj Thakur8y ago
Accepted answer
Now you have to setting up the chart control... no mistake in c#. Chart control should have some settings or bits for set this type of number format.
john kanyora8y ago
@Dharmraj, thanks i get it..will you kindly help me then with the chart control..just help me to fix it
john kanyora8y ago
@Dharmraj, i have changed but still no change
Dharmraj Thakur8y ago
Then no need of integer conversion...
y[i] = Convert.ToInt32(Convert.ToDecimal(Convert.ToString(dt.Rows[i][1])));

Replace above code with:
y[i] = Convert.ToDecimal(Convert.ToString(dt.Rows[i][1]));
john kanyora8y ago
@Dharmraj, i have done so ..now there is no error but the values are just the same..they are not in decimal..here it is

the values on the bar chart i want them to be in decimal form like 6200.00
Dharmraj Thakur8y ago
Ohkay got it...
string[] x = new string[dt.Rows.Count];
decimal[] y = new decimal[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
    x[i] = dt.Rows[i][0].ToString();
    y[i] = Convert.ToInt32(Convert.ToDecimal(Convert.ToString(dt.Rows[i][1])));
}
BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries {Data=y });
BarChart1.CategoriesAxis = string.Join(",", x);
BarChart1.ChartWidth = 500.ToString();
BarChart1.ChartHeight = 600.ToString();
}
john kanyora8y ago
@Dharmraj. i have done so and this is the error am getting
Dharmraj Thakur8y ago
I think you applied in wrong way... did you like this?
string[] x = new string[dt.Rows.Count];
int[] y = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i]=Convert.ToInt32(Convert.ToDecimal(Convert.ToString(dt.Rows[i][1])));
}
BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries {Data=y });
BarChart1.CategoriesAxis = string.Join(",", x);
BarChart1.ChartWidth = 500.ToString();
BarChart1.ChartHeight = 600.ToString();
}
john kanyora8y ago
@Amit, i can send it..do you want the code i send it all
Amit Gupta8y ago
If possible, can you share your graph chart project to analyse it
john kanyora8y ago
@Amit, thanks..would you kindly help me on that..i have tried to solve it but am stuck
Amit Gupta8y ago
@John It's not a matter to convert to string, it should be decimal. Just you need to format your Y axis labels to show deci.al points. Just dig a little to the chart properties for Y axis lable
john kanyora8y ago
@Dharmraj , i have tried it and still it does not work
Dharmraj Thakur8y ago
Solved...
Just covert first into decimal and after convert into int like this...

Convert.ToInt32(Convert.ToDecimal("214545.00"));
john kanyora8y ago
@Dharmraj, this is how the data is..
but i want it to be like it is there.because from my graph it does not have that decimal point.instead of 154336.00 it shows 154336
Dharmraj Thakur8y ago
Can you show what data you have in DataTable?