C#读取XML文件

最新推荐文章于 2024-01-07 10:30:18 发布

放开那段代码让我来

最新推荐文章于 2024-01-07 10:30:18 发布

阅读量509

点赞数

分类专栏： c# 文章标签： c#

本文链接：https://blog.csdn.net/u014424282/article/details/77943517

版权

c# 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

1、一般处理程序查询数据返回xml类型的字符串：

       public string ProjectData()
        {
            string connectionStrings = BookStrap.SqlHelp.constr;
            string sql = "select ID,ProjectName,Lng,Lat,jsdw,extStaus  from LbtProjectMap";
            DataTable dt = BookStrap.SqlHelp.ExecuteDataset(connectionStrings, sql, CommandType.Text, null).Tables[0];
            string xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
            xml += "<rows>";
            foreach (DataRow dr in dt.Rows)
            {
                xml += "<row id=\"" + dr["ID"] + "\">";
                xml += "<cell>" + dr["ID"] + "</cell>";
                xml += "<cell>" + dr["ProjectName"] + "</cell>";
                xml += "<cell>" + dr["Lng"] + "</cell>";
                xml += "<cell>" + dr["Lat"] + "</cell>";
                xml += "<cell>" + dr["jsdw"] + "</cell>";
                xml += "<cell>" + dr["extStaus"] + "</cell>";
                xml += "</row>";
            }
            xml += "</rows>";
            return xml;
        }

2、Jquery点击按钮读取xml类型的string字符串，绑定到table上：

   $(function () {
            $("#Button1").click(function () {             
                $.ajax({
                    url: 'Handler2.ashx',
                    type: 'get',
                    //data: "",
                    dataType: 'text',
                    success: function (data) {
                        var htmls = "<table width=\"1200\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
                        htmls += "<thead>";
                        htmls += "<tr>";
                        htmls += "<th>ID</th>";
                        htmls += "<th>工程名称</th>";
                        htmls += "<th>经度</th>";
                        htmls += "<th>纬度</th>";
                        htmls += "<th>建设单位</th>";
                        htmls += "<th>实施状态</th>";
                        htmls += "</tr></thead>";
                        console.log(typeof (data));//打印string类型
                        var $xmlDoc = $($.parseXML(data));
                        var $rows = $xmlDoc.find("row");

                        for (var i = 0; i < $rows.length; i++) {
                            console.log($rows[i]);//读取row
                            
                            console.log($rows[i].innerHTML);//读取row里面的所有cell
                            htmls += "<tr>";
                            //console.log($rows[i].textContent);//

                            var childl = $rows[i].children;
                            console.log($rows[i].children);//打印出HTMLCollection对象
                            for (var j = 0; j < childl.length; j++) {
                                console.log(childl[j].innerHTML);
                                htmls += "<td>"+childl[j].innerHTML+"</td>";
                            }                    
                            htmls += "</tr>";
                        }
                        htmls += "</table>";
                      
                        $("body").append(htmls);
                    },
                    error: function (jqXHR, textStatus, errorThrown) {
                        alert("加载失败");
                    }

                });
                 
            })
        })

html代码：

<body>
    <input id="Button1" type="button" value="XML文件" />
 
</body>

放开那段代码让我来

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
C#读取XML文件

1、 public string ProjectData() { string connectionStrings = BookStrap.SqlHelp.constr; string sql = "select ID,ProjectName,Lng,Lat,jsdw,extStaus from LbtProject
复制链接

扫一扫

专栏目录