select sql from normal column and xml datatype

Hi EE,

I have following table format and using xmlreader to query data on asp.net app. But I can not access the value of ID column?
how to handle such issue?

sql = select ID, Data from TBL

Column  Name  DataType
ID                      int
Data                  XML

Thanks
LVL 2
salojAsked:
Who is Participating?
 
mayank_joshiConnect With a Mentor Commented:
XML reader is used for reading only xml content.
use data reader or data adapter for reading the ID column.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.