关于sqlserver查询得到xml数据流的问题!
Dim conn As New SqlConnection("data source=hq0;initial catalog=em_cd;user id=emnetdevlop;password=emnetdevlop;persist security info=True")
Dim strSql = "select * from tArea for xml auto "
Dim Cmt As New System.Data.SqlClient.SqlCommand(strSql, conn)
conn.Open()
Dim XmlRead As XmlReader = Cmt.ExecuteXmlReader()
Dim xmldoc As New XmlDocument()
'错误为:此文档已具有 DocumentElement 节点。
xmldoc.Load(XmlRead)
Dim xmlwt As XmlWriter
xmldoc.WriteTo(xmlwt)
Dim str As String
xmlwt.WriteString(str)
'我的目的就是将查询出来的xml字符串结果,用字符串表示出来。
'这个代码老是出错,请帮想一下办法,谢谢!!!!