[WebMethod(Description = "一张表学生表输出XML格式(横向输出)")]
public XmlDocument xd_Get_Stu()
{
//学生表信息查询
string MySelectStr_1 = "select Sname, Sage, Ssex from dbo.Student order by Sname";
GetSQLData dt1 = new GetSQLData();
DataSet ds = new DataSet();
ds.Tables.Add(dt1.GetSqlData(MySelectStr_1));
XmlDocument xd = new XmlDocument();
//加入XML的声明段落,<?xml version="1.0" encoding="gb2312"?>
XmlDeclaration xmldecl = xd.CreateXmlDeclaration("1.0", "utf-8", null);
xd.AppendChild(xmldecl);
//添加根元素
XmlElement xmle = xd.CreateElement("", "Student", "");
xd.AppendChild(xmle);
//寻找根元素
XmlNode root = xd.SelectSingleNode("Student");
//判断表是否有数据
if (ds.Tables[0].Rows.Count > 0)
{
//读取该表每行信息
for (int nI = 0; nI < ds.Tables[0].Rows.Count; nI++)
{
//添加根元素xmle下的第一层子元素xeRow
XmlElement xeRow = xd.CreateElement("ttt");
//读取该表每列信息
for (int nC = 0; nC < ds.Tables[0].Columns.Count; nC++)
{
//判断改列是否为空,若不为空,则写入xml中
if (ds.Tables[0].Rows[nI][nC].ToString() != null && ds.Tables[0].Rows[nI][nC].ToString() != "" && ds.Tables[0].Rows[nI][nC].ToString() != "“" + "”")
{
//添加xeRow的属性及值
xeRow.SetAttribute(ds.Tables[0].Columns[nC].ColumnName.ToString(), ds.Tables[0].Rows[nI][nC].ToString());
root.AppendChild(xeRow);
}
}
}
}
xd.AppendChild(xmle);
return xd;
}
<?xm<?<?xml version="1.0" encoding="UTF-8"?>
-<Student> <ttt Ssex="女" Sage="15" Sname="李四"/> <ttt Ssex="男" Sage="16" Sname="王五"/> <ttt Ssex="男" Sage="14" Sname="张三"/> </Student>