将一个表的信息以XML格式显示?这是什么意思啊!我不懂其中的意思!我现在有2种思路,我不知道是哪一种思路了!我第一种理解为:将一个表的信息用treeview给显示出来,不知是否正确!还是第二种思路:代码如下
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="P_load.aspx.cs" Inherits="P_load" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>加载xml文件</title> <script language="javascript" type="text/javascript">
function Xmlload()
{
var xDom = new ActiveXObject("Microsoft.XmlDom");
//同步访问
xDom.async = false;
xDom.load("Xml_Movie.xml");
//获取根节点
var xNood = xDom.documentElement;
//根节点的第一个子节点
var xSubNood = xNood.childNodes[1].childNodes[0];
//节点名称
//alert(xNood.nodeName);
//节点文本值
alert(xSubNood.text);
}
</script></head>
<body>
<form id="form1" runat="server">
<div>
<input type="button" value="加载xml文件" onclick="Xmlload();" />
</div>
</form>
</body>
</html>哪位高手有源码,给我发一下啦!
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="P_load.aspx.cs" Inherits="P_load" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>加载xml文件</title> <script language="javascript" type="text/javascript">
function Xmlload()
{
var xDom = new ActiveXObject("Microsoft.XmlDom");
//同步访问
xDom.async = false;
xDom.load("Xml_Movie.xml");
//获取根节点
var xNood = xDom.documentElement;
//根节点的第一个子节点
var xSubNood = xNood.childNodes[1].childNodes[0];
//节点名称
//alert(xNood.nodeName);
//节点文本值
alert(xSubNood.text);
}
</script></head>
<body>
<form id="form1" runat="server">
<div>
<input type="button" value="加载xml文件" onclick="Xmlload();" />
</div>
</form>
</body>
</html>哪位高手有源码,给我发一下啦!
SqlCommand cmd = conn.CreateCommand();
//把列的内容作为属性,根元素名子为<root>
//cmd.CommandText = "select * from P_Book for xml auto,root('root')";
cmd.CommandText = "select Book_id,BookName,BookIntro,ImgUrl from P_Book for xml auto,root('bookstore'),elements";
conn.Open();
XmlReader xr = cmd.ExecuteXmlReader();
XmlDocument dd = new XmlDocument();
dd.Load(xr); ;
XmlNode xx = dd.FirstChild; //取得根元素
XmlDeclaration xd = dd.CreateXmlDeclaration("1.0", "utf-8", "yes"); //创建XML声明
dd.InsertBefore(xd, xx); //在根元素前加入XML声明
dd.Save(Server.MapPath("MaoMao.xml"));
conn.Close();