• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 721
  • Last Modified:

formatting a string in VB.Net (tostring)

In the code attached, I want to be able to format vchr.inv_amt to be dollars and cents.  In C#, I believe I can use vchr.inv_amt.ToString("##,##0.00"), but in VB.Net I am getting
"Overload resolution failed because no accesible 'ToString' accepts this number of arguments."

This sub routine is in an "Actions" class, not the main form.  Am I missing a namespace or is this just not how you do it in VB.Net?  If not, how is it done.

Public Shared Sub FillVchrGrid(ByVal f As Form1)
            Dim ap3 As New Ap3DataContext(Globals.ConnString)

            Dim vchrs = From c In ap3.aptrxfil_sqls Select c

            For Each vchr In vchrs
                f.dgvVouchers.Rows.Add(vchr.batch_id, vchr.vchr_no, vchr.vend_no, vchr.inv_no, vchr.inv_amt.ToString(), vchr.ID.ToString())
            Next 'vchr

            For Each dr As DataGridViewRow In f.dgvVouchers.Rows
                For y As Integer = 0 To 4
                    dr.Cells(y).Style.BackColor = Color.LightGreen
                Next 'y
            Next 'datagridviewrow
        Catch ex As Exception
            Throw New Exception(ex.Message)
        End Try
    End Sub

Open in new window

1 Solution
Anil GolamariCommented:
http://www.codeproject.com/KB/string/vbnetformatcurrency.aspx (sample code)

// Private Function DoConvert(ByVal Str as String, ByVal DecPlc as Integer) as String
//      Return String.Format("{0:c" & DecPlc & "}",CDec(Str))
// End Function  

If those are floating point types, you can simply use vchr.inv_amt.ToString("c")
g_johnsonAuthor Commented:
.ToString("c") caused the same problem.  I ended up using format(vchr.inv_amt,"c") and that works.  Please see my next question because I need more detail on ToString

FormatNumber(vchr.inv_amt.ToString(), 2)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now