Input String is not in Correct Format when reading DataTable values

Asked Feb 19 '16 at 12:53

Active Feb 19 '16 at 13:31

Viewed 73 times

I am performing sum of two columns using DataTable, first time converts and perform addition but second time it is giving me Input string is not in correct format My code is here:

Dim dt As New DataTable()
dt.Columns.Add("BillingAmount")
dt.Columns.Add("RecievedAmount")
dt.Columns.Add("Balance")

For i As Integer = 0 To mstr_DataTable.Rows.Count - 1
   Dim BillingAmount As Decimal = Decimal.Parse(drw("BillingAmount").ToString()) + Decimal.Parse(mstr_DataTable.Rows(0)("BillAmount").ToString()) 
   '^ I am getting exception here .
   drw("BillingAmount") = BillingAmount.ToString()
   drw("RecievedAmount") = mstr_DataTable.Rows(0)("PaymentAmount").ToString()
   Dim Balance As Decimal = Decimal.Parse(drw("BillingAmount").ToString()) - Decimal.Parse(mstr_DataTable.Rows(0)("PaymentAmount").ToString())
   '^ I am getting exception here .
   drw("Balance") = Balance.ToString()
Next

edited Feb 19 '16 at 13:31

Nathu

asked Feb 19 '16 at 12:53

Aman

4

You code seems to be VB.Net – Ian Feb 19 '16 at 12:54
1

What are the values of `mstr_DataTable.Rows(0)("BillAmount")` and `drw("BillingAmount")` and the rests? Do you see them in your debugger? – Ian Feb 19 '16 at 12:56
Please post your exception details also. – Sampath Feb 19 '16 at 12:58
Why are you converting the values of `BillAmount` etc to strings and then parse them? If they were decimals/doubles already, you'd only have to add the values (if you used `drw.BillingAmount`) or at most, cast them to their actual type – Panagiotis Kanavos Feb 19 '16 at 12:59
Use the debugger. See what the value is. Is it a number? – Cody Gray - on strike Feb 19 '16 at 13:07

Input String is not in Correct Format when reading DataTable values

0 Answers0