62,074
社区成员
发帖
与我相关
我的任务
分享
update ts_markcategory set [Property] = '
<?xml version="1.0" encoding="utf-8"?>
<item>
<property>万能型
</property>
</item>';
create table ts_markcategory
(
property nvarchar(1000)
)
insert into ts_markcategory values('<?xml version="1.0" encoding="utf-8"?>
<item>
<property>万能型
</property>
</item>')
string s = String.Empty;
using (SqlConnection conn = Connection)
{
SqlCommand cmd = new SqlCommand("select property from ts_markcategory", conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
s = dr[0].ToString();
}
dr.Close();
}
XmlDocument doc = new XmlDocument();
s = s.Replace("<", "<").Replace(">",">");//在这替换了一下就OK了
doc.LoadXml(s);