XML替换节点问题高手请进

andyking_ 2010-10-28 10:23:10

数据库中有一个XML字段存的值是
<Question>
<QuestionType Code="1" Type="单选题" />
<QuestionField>
<Field Name="Q_Title" />
<Field Name="Q_Type" />
<Field Name="Q_DropDownBox" />
<Field Name="Q_PictureRotation" />
<Field Name="Q_Rotation"/>
</QuestionField>
</Question>

要将换节点
<QuestionField>
<Field Name="Q_Title" />
<Field Name="Q_Type" />
<Field Name="Q_DropDownBox" />
<Field Name="Q_PictureRotation" />
<Field Name="Q_Rotation"/>
</QuestionField>
替换为
<QuestionField>
<Field Name="T_Title" />
<Field Name="T_Type" />
</QuestionField>

怎么写sql？

...全文

97 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

q107770540 2010-10-28

打赏
举报

update tb set xml="new 值" where id=@id

边城的刀声 2010-10-28

打赏
举报



<Question>

	<QuestionType Code="1" Type="单选题" />

	<QuestionField>

		<Field Name="T_Title" />

		<Field Name="T_Type" />

	</QuestionField>

</Question>

边城的刀声 2010-10-28

打赏
举报



XmlDocument doc = new XmlDocument();

            doc.LoadXml(@"

<Question>

  <QuestionType Code=""1"" Type=""单选题"" />

 <QuestionField>

  <Field Name=""Q_Title"" />

  <Field Name=""Q_Type"" />

  <Field Name=""Q_DropDownBox"" />

  <Field Name=""Q_PictureRotation"" />

  <Field Name=""Q_Rotation""/>

  </QuestionField>

</Question>");





            doc.SelectSingleNode(@"//Field[@Name=""Q_Title""]").Attributes["Name"].InnerText = "T_Title";

            doc.SelectSingleNode(@"//Field[@Name=""Q_Type""]").Attributes["Name"].InnerText = "T_Type";



            doc.FirstChild.LastChild.RemoveChild(doc.SelectSingleNode(@"//Field[@Name=""Q_DropDownBox""]"));

            doc.FirstChild.LastChild.RemoveChild(doc.SelectSingleNode(@"//Field[@Name=""Q_PictureRotation""]"));

            doc.FirstChild.LastChild.RemoveChild(doc.SelectSingleNode(@"//Field[@Name=""Q_Rotation""]"));



            Console.Write(doc.InnerXml);