如果标记值等于null，则如何将XML中的标记值获取到VB.NET [英] If tag value equal to null then How to get tag value in XML to VB.NET

问题描述

- <ENVELOPE>
- <SHGREPAYMENT>
  <CLUSTERID>SLMCLT0002</CLUSTERID> 
  <UNITTYPE>VIL</UNITTYPE> 
  <VPRCID>SLMVIL0019</VPRCID> 
  <YYYYMM>201106</YYYYMM> 
  <PIPNO>67890b</PIPNO> 
  <NAMEOFTHEMEMBER>Parvati-67890b</NAMEOFTHEMEMBER> 
  <SHGID>S1</SHGID> 
  <SHGNAME>Omshakthi</SHGNAME> 
  <TYPEOFLOAN>DL</TYPEOFLOAN> 
  <PRINCIPAL>1000.00</PRINCIPAL> 
  <INTEREST> </INTEREST>
  </SHGREPAYMENT>
- <SHGREPAYMENT>
  <CLUSTERID>SLMCLT0002</CLUSTERID> 
  <UNITTYPE>VIL</UNITTYPE> 
  <VPRCID>SLMVIL0019</VPRCID> 
  <YYYYMM>201106</YYYYMM> 
  <PIPNO>67891a</PIPNO> 
  <NAMEOFTHEMEMBER>Valli-67891a</NAMEOFTHEMEMBER> 
  <SHGID>S1</SHGID> 
  <SHGNAME>Omshakthi</SHGNAME> 
  <TYPEOFLOAN>DL</TYPEOFLOAN> 
  <PRINCIPAL>1000.00</PRINCIPAL> 
  <INTEREST> </INTEREST>
  </SHGREPAYMENT>
</ENVELOPE> 

上面是XML数据.在这里，我得到了所有标签值，但是我却无法获得兴趣标签值，因为如果此标签包含空值，则意味着如何获取该值并将其存储在数据库中.兴趣字段在数据库(SQL Server)中定义为数字，因此它不接受null，我们要将其保存为0.
我也尝试了以下方法
Convert.Toint32datareader("INTEREST")，但我无法解决问题
此帖子的发布解决方案
祝你新年快乐
在Advance中致谢

THE ABOVE IS THE XML DATA. Here i got all the tag value, but interest tag value i m not able to get that, because if this tag contain null value means how to get that and store in the database. The interest field defined as numeric in the database(sql server) so it does not accept null we want to save it as 0.
i tried the following method also
Convert.Toint32datareader("INTEREST") but i could not solve the problem
post solution for this post
WISH U HAPPY NEW YEAR
Thanks in Advance

推荐答案

如何从xml获取(读取)数据?
您使用sqlconnection还是其他任何方法?

在MS SQL中，您会找到 IsNull() [ OPENXML() [ ^ ]函数，该函数可以将空值替换为整数.


您可以编写命令来插入数据，如下所示:

How do you get (read) data from xml?
Do you use sqlconnection or any other method?

In MS SQL you''ll find IsNull()[^] and OPENXML()[^] function, which can replace null value into integer.


You can write command to insert data like this:

INSERT INTO [Database].[dbo].[Table] (..., [Interest])
SELECT ..., ISNULL([INTEREST], 0) AS [Interest]
FROM OPENXML(...)

这篇关于如果标记值等于null，则如何将XML中的标记值获取到VB.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！