no overload for method “ToString” takes 1 arguments

by

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.

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Search SQL by date ASP.NET
  3. Sql: Incorrect syntax near ‘(‘ [closed]
  4. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  5. Is there a good LINQ way to do a cartesian product?
  6. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  7. Entering keys manually with Entity Framework
  8. Read SQL Table into C# DataTable
  9. Pass table valued parameter using ADO.NET
  10. DropdownList DataSource
  11. Stop SQL query execution from .net Code
  12. ASP.NET ODBC Query with parameters
  13. What is passing parameters to SQL and why do I need it?
  14. How to make LINQ execute a (SQL) LIKE range search
  15. Index (zero based) must be greater than or equal to zero
  16. Database Error: There is no row at position 0
  17. Memory leak in Data Access layer using enterprise library
  18. C# SQL Server – Passing a list to a stored procedure
  19. linq case statement
  20. Child actions are not allowed to perform redirect actions, after setting the site on HTTPS [duplicate]
  21. Attach Debugger to IIS instance
  22. Is current request being made over SSL with Azure deployment
  23. Why use HttpClient for Synchronous Connection
  24. How can I convert a class into Dictionary?
  25. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  26. Access Query string parameters with no values in ASP.NET
  27. System.web.mvc missing
  28. How to use String property as primary key in Entity Framework
  29. How can I ensure that appsettings.dev.json gets copied to the output folder?
  30. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

Leave a Comment