如何通过VB.NET单独检索xml数据类型中的正常值？ [英] How to retrieve the normal values alone in xml datatype through VB.NET ?

问题描述

Hi all,

I am just doing to start working in VB.Net. I want to separate the normal values alone in my XML datatype in SQL 2008.

I Couldn't able to read the xml data types and separate the values.


Please help me to get out this problem.

XML Data in my DB:-

#1
<dataSet><Table1><SNo>1</SNo><NormalCommentsVaules>0-40 IU/L</NormalCommentsVaules><NormalComments /></Table1></dataSet>

#2

<dataSet><Table1><SNo>1</SNo><NormalCommentsVaules>Less than 0.6 mg/dl</NormalCommentsVaules><NormalComments /></Table1><Table1><SNo>2</SNo><NormalCommentsVaules>More than 0.6 mg/dl</NormalCommentsVaules><NormalComments /></Table1></dataSet>

In that above i want to separate the NormalCommentsVaules alone, ie.,

#1 0-40 IU/L

#2 Less than 0.6 mg/dl
   More than 0.6 mg/dl

Suresh P

推荐答案

这篇关于如何通过VB.NET单独检索xml数据类型中的正常值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！