I have a data reader to read the datas from database.
I am reading TotalPrice from sales table.
I would like to show the total price as 2 decimal place.
The code is something link that:
TotalPrice.Text = myReader["TotalPrice"].ToString("N2");
However i encounted this error: no overload for method “ToString” takes 1 arguments
What’s wrong with the code?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
Assuming that TotalPrice is a Decimal column, and that myReader is a DataReader:
TotalPrice.Text = myReader.GetDecimal(myReader.GetOrdinal("TotalPrice")).ToString("N2");
The idea here is that myReader’s indexer (what you are using when you call myReader["TotalPrice"]) returns an Object. It has to, since it doesn’t know at compile time what type the column is. By using .GetDecimal(), you are assuring that you get a Decimal value back, or an error.
The .ToString overload that takes a format string is declared on Decimal, not on Object. Object’s .ToString takes no arguments.
The inner call to GetOrdinal returns the field’s index given the name- if you are doing this in a loop for multiple data rows, you’d probably want to cache that in a variable.
Method 2
String.Format() will do the trick. F2 is fixed-point notation with 2 decimal places.
TotalPrice.Text = string.Format("{0:F2}", (double)myReader["TotalPrice"]);
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0