- 当前位置：首页 >域名 >SQL Server XML查询工具
SQL Server XML查询工具
发布时间：2025-11-05 08:02:15 来源：码上建站 作者：域名
复制 private void btnSearch_Click(object sender,查询 System.EventArgs e) { string s = "<?xml version="1.0" encoding="utf-8"?><SearchResult>"; string endWith = ""; // 创建连接对象实例 SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectString"]); SqlCommand myCommand = new SqlCommand(txtCondition.Text, myConnection); myCommand.CommandType = CommandType.Text; // 创建 XML Reader，并读取数据到 XML 字符串中 XmlTextReader xmlReader = null; try { // 打开数据库连接 myConnection.Open(); // 运行存储过程并初始化 XmlReader xmlReader = (XmlTextReader)myCommand.ExecuteXmlReader(); while(xmlReader.Read()) { if (xmlReader.NodeType == XmlNodeType.Element) { s += "<" + xmlReader.Name; if (xmlReader.IsEmptyElement) endWith ="/"; else endWith = ""; if (xmlReader.HasAttributes) { while(xmlReader.MoveToNextAttribute()) s += " " + xmlReader.Name + "="" + ToMIMEString(xmlReader.Value) + """; } s += endWith + ">"; } else if (xmlReader.NodeType == XmlNodeType.EndElement) { s += "</" + xmlReader.Name + ">"; } else if (xmlReader.NodeType == XmlNodeType.Text) { if (xmlReader.Value.Length != 0) { s += ToMIMEString(xmlReader.Value); } } } s+="</SearchResult>"; txtResult.Text = s; } catch (Exception) { txtResult.Text = "Got an error"; //不处理任何错误 } finally { // 关闭数据库连接并清理 reader 对象 myConnection.Close(); xmlReader = null; } XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(s); //============================================= //将结果写入 //============================================= try { MemoryStream ms = new MemoryStream(); XmlTextWriter xtw = new XmlTextWriter(ms,工具 Encoding.UTF8); xtw.Formatting = Formatting.Indented; xmlDoc.Save(xtw); byte[] buf = ms.ToArray(); txtResult.Text = Encoding.UTF8.GetString(buf,0,buf.Length); xtw.Close(); } catch { txtResult.Text = "出现错误！香港云服务器查询"; } } private string ToMIMEString(string s) { StringBuilder sb = new StringBuilder(); char[] ssource = s.ToCharArray(); foreach(char c in source) { if(c==<) sb.Append("<"); else if(c==&) sb.Append("&"); else if(c==>) sb.Append(">"); else if(c==") sb.Append("""); else sb.Append(c); } return sb.ToString(); } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.105.106.107.108.109.110.111.112.113.114.亿华云计算
企商汇益华科技服务器租用IT技术网亿华云香港云服务器源码库IT资讯网源码下载益强数据堂技术快报益强智未来益强资讯优选益强科技思维库亿华云计算益华科技云站无忧益华科技极客编程智能时代极客码头科技前瞻益强科技云智核亿华智造亿华云创站工坊运维纵横益强编程舍亿华科技益强编程堂益华IT技术论坛IT资讯网亿华灵动码力社码上建站亿华互联益强IT技术网益强智囊团益强前沿资讯亿华智慧云
- Copyright © 2025 Powered by SQL Server XML查询工具,码上建站 滇ICP备2023006006号-47sitemap