如何将varchar转换为数字 [英] How to convert varchar to numeric

问题描述

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)

从上面的语句中，我要将this("+ dr(" SAVINGS)+")从varchar转换为数字
在这里，我从XML文件获取数据，然后将其导入数据库.在这里，保存字段是从XML FILE获取空值，但在后端(sqlserver)保存字段中定义为数字.当我尝试向数据库中插入空值时，我遇到了错误(即，错误地转换了数据类型)，因此我需要在这里将varchar转换为numeric
抱歉打扰了
此帖子的发布解决方案
在此先感谢

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

推荐答案

尝试以下操作:

Try this:

Convert.ToInt32(dr("SAVINGS"))

在可能的本地化问题(不同的deciaml分隔符等)的情况下，您也可以使用 CAST和CONVERT [ ^ ]

In case of possible localization problems (different deciaml separators etc) you can also use the TryParse[^] method.

Another possibility is to do the conversion when putting the data into the database, see: CAST and CONVERT[^]

这篇关于如何将varchar转换为数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！