我在数据库里创建如下表哥 create table List(
LID int PRIMARY KEY,
LList xml);xml格式如下
<list>
<name = "123" />
</list>如果我执行 declare @LID int;
declare @List xml;
select @List = LList from List where LID = @LID;
那么我将如何取出 @List ,将它放如一个XML格式的文件里,请高手指教
LID int PRIMARY KEY,
LList xml);xml格式如下
<list>
<name = "123" />
</list>如果我执行 declare @LID int;
declare @List xml;
select @List = LList from List where LID = @LID;
那么我将如何取出 @List ,将它放如一个XML格式的文件里,请高手指教
{
/* create table List(
LID int PRIMARY KEY,
LList xml
); insert into List values(1,'<list><name name="123"/></list>')
*/ SqlConnection con = new DBConnection().GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Select LList from List", con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
XmlDocument xml = new XmlDocument();
xml.LoadXml(reader.GetString(0)); xml.Save("E:\\xml.xml");
con.Close();
}
}