SQL取xml中节点值，该怎么解决

/// <summary>

/// 读取xml中的指定节点的值

/// </summary>

private string ReadXmlNode(string filename)

{

string result = "-1"

XmlDocument xmlDoc = new XmlDocument()

try

{

xmlDoc.LoadXml(filename)

//读取Activity节点下的数据。SelectSingleNode匹配第一个Activity节点

XmlNode root = xmlDoc.SelectSingleNode("//head")//当节点Workflow带有属性是，使用SelectSingleNode无法读取

if (root != null)

result = (root.SelectSingleNode("code")).InnerText

}

catch //(Exception e)

{

//显示错误信息

}

return result

}

不能被函数调用是什么意思?你的函数呢?函数不写出来怎么帮你看?

我这个是假设你的到了XmlFiles/StuElements.xml,你不是已经通过File.CreateText(stuFileName)创建了该文件了吗?

我建议你直接DataSet1.WriteXml(filepath)这种方式直接把DataSet生成xml文件

string strFilePath = Server.MapPath ( "XmlFiles/StuElements.xml" )

System.Xml.XmlDocument xmlDocument = new System.Xml.XmlDocument ( )

xmlDocument.Load ( strFilePath )

System.Xml.XmlElement xmlElement = xmlDocument.DocumentElement

foreach ( System.Xml.XmlNode node in xmlElement.ChildNodes )

{

Response.Write ( "lat: " + node [ "lat" ].InnerText + ", lng: " + node [ "lng" ].InnerText + "<br />" )

}

//修改后的

System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Data Source=.Initial Catalog=PubsIntegrated Security=True")

System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("Select * from Authors", conn)

System.Data.DataSet ds = new System.Data.DataSet()

conn.Open()

da.Fill(ds, "Authors")

System.Data.DataTable dt

dt = ds.Tables["Authors"]

foreach (System.Data.DataColumn dc in dt.Columns)

{

dc.ColumnMapping = System.Data.MappingType.Attribute

}

string filePath = Server.MapPath("XmlFiles/Stu.xml")

ds.WriteXml(filePath)

System.Xml.XmlDocument xmlDocument = new System.Xml.XmlDocument()

xmlDocument.Load(filePath)

System.Xml.XmlNodeList Authors= xmlDocument.GetElementsByTagName("Author")

foreach (System.Xml.XmlNode node in Authors)

{

Response.Write("FirstName:" + node.Attributes["FirstName"].Value + "<br />")

}

---