Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
808 views
in Technique[技术] by (71.8m points)

c# - no overload for method "ToString" takes 1 arguments

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...