sql server - Public member 'Value' on type 'Decimal' not found - Removing last two characters -


i trying take last 2 decimals off number pulling sql server.

it comes out this:

4790.2000 

i want be:

4790.20 

i tried this:

txtboxvisatotalbank.text = dt.rows(0).item("bank_vi").string.format("{0:n2}", 10) 

but error:

public member 'value' on type 'decimal' not found.

txtboxvisatotalbank.text = string.format("{0:n2}", decimal.parse(dt.rows(0).item("bank_vi"))) 

Comments