I have a situation that I am trying to resolve. If I do this:

MessageBox.Show((25).ToString("#########0"))

It works. But, if I do this:

        Dim loDataProviderTotal As Framework.Framework.Data = New Framework.Framework.Data(oApp)
        Dim loRowTotal As DataRow

        If Not loDataProviderTotal.SQLExec("SELECT SUM(NewAccount) AS SumColumn FROM Monthly", oApp.aConnection(3)) Then
            MessageBox.Show(oApp.cError + " : " + loDataProviderTotal.cSQL + " : " + loDataProviderTotal.cConnectionString)
            Exit Sub
        End If

        loRowTotal = loDataProviderTotal.oDataView(0).Row
        MessageBox.Show(loRowTotal("SumColumn").ToString("#########0"))

I end up with an error:

Conversion from string "#########0" to type 'Integer' is not valid.

Basically, there seems to be something different in the way .NET handles a SUM column from the SQL. Anyone knows what need to be adjusted in order to apply the same formatting from the sum column?