xml读取表的数据!
XmlReader xr = cmd.ExecuteXmlReader();
StreamWriter sw = new StreamWriter(Server.MapPath("XMLFile.xml"));
sw.WriteLine("<?xml version='1.0' encoding='GB2312' ?>");
sw.Write("<Menu>");
while (xr.Read())
{
sw.Write(xr.ReadOuterXml());
}
sw.Write("</Menu>");
xr.Close();
cn.Close();
sw.Close();
我读取出来了以后是
<Menu>
<SystemMenu ID="1" MenuName="工作室管理" IsStartup="1" CreateDate="2007-01-01T00:00:00" StudioID="1" ParentMenuID="1" MenuCategory="1" MenuID="1" />
</Menu>
我想要变成
<Menu>
<SystemMenu>
<ID>1</ID>
<MenuName>工作室管理</MenuName>
............
</SystemMenu>
</Menu>