SqlXmlCommand xmlcom=new SqlXmlCommand(constring);
xmlcom.CommandText="<root xmlns:sql=/"urn:schemas-microsoft-com:xml-sql/" ><sql:xpath-query>/student[@id='aaa']</sql:xpath-query></root>";
xmlcom.CommandType=SqlXmlCommandType.Template;
xmlcom.RootTag="ROOT";
xmlcom.SchemaPath= schemapath;
string xmldata="";
using(Stream st=xmlcom.ExecuteStream())
{
using(StreamReader str=new StreamReader(st))
{
xmldata=str.ReadToEnd();
}
}
SQLXML知多少
最新推荐文章于 2023-12-14 10:00:00 发布