How to convert varchar to numeric

Rajkumar R

15y2.1k.NET

Dim cmdinsert As New SqlCommand("insert into VMIS_30(RptUnitTypeID,Rpt_Unit,YYYYMM,pipno,name1,clt,savings,typ_loan,amt,no_installme,rate_interest,randm_code)values('" + dr("UNITTYPE") + "','" + dr("VPRCID") + "'," + dr("YYYYMM") + ",'" + repipcode + "','" + dr("NAMEOFTHEMEMBER") + "','" + shgcode + "'," + dr("SAVINGS") + ",'" + dr("TYPELOAN") + "'," + dr("AMOUNT") + "," + dr("NOOFINSTALLMENT") + "," + dr("RATEOFINTEREST") + "," + rancode1.ToString() + ")", conDB)
From the above statement i want convert this(" + dr("SAVINGS") + ") from varchar to numeric

here i m getting data from XML file, then i m importing into database. Here the savings field i m getting null value from XML FILE but in the backend(sqlserver) savings field defined as numeric. While i try to insert null value into DB i m getting error (ie., error converting datatype) so i need to convert here from varchar to numeric

Sorry for interrupt

Post solution for this post
Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Try:

Dim temp As Double = 0.0

If dr("SAVINGS") IsNot Nothing Then temp = Convert.ToDouble(dr("SAVINGS"))

Dim cmdinsert As New SqlCommand("insert into VMIS_30(RptUnitTypeID,Rpt_Unit,YYYYMM,pipno,name1,clt,savings,typ_loan,amt,no_installme,rate_interest,randm_code)values('" + dr("UNITTYPE") + "','" + dr("VPRCID") + "'," + dr("YYYYMM") + ",'" + repipcode + "','" + dr("NAMEOFTHEMEMBER") + "','" + shgcode + "'," + temp + ",'" + dr("TYPELOAN") + "'," + dr("AMOUNT") + "," + dr("NOOFINSTALLMENT") + "," + dr("RATEOFINTEREST") + "," + rancode1.ToString() + ")", conDB)
0
Rajkumar R15y ago
This also been not working
0
Pravin Ghadge15y ago
Hi Rajkumar,
Just replace
dr("SAVINGS")
with (dr("SAVINGS") ==null?"0":dr("SAVINGS"))

It may help u.
0