protected void btnToXml_ServerClick(object sender, EventArgs e)
{
ISelectDataSourceFace select = new SelectSQL { DataBaseAlias = "Integrated" };
select.SelectFromTable("Tbl_UpdateLogs");
select.SelectColumns("id", "title", "content", "module", "updateTime", "operator");
DataSet ds = select.ExecuteDataSet();
ds.Tables[0].Columns[0].ColumnMapping = MappingType.Attribute;
ds.Tables[0].Columns[1].ColumnMapping = MappingType.Attribute;
ds.Tables[0].Columns[2].ColumnMapping = MappingType.Attribute;
ds.Tables[0].Columns[3].ColumnMapping = MappingType.Attribute;
ds.Tables[0].Columns[4].ColumnMapping = MappingType.Attribute;
string fileName = Guid.NewGuid().ToString("N") + ".xml";
XmlTextWriter xtw = new XmlTextWriter(Server.MapPath("~/App_Data/" + fileName), //生成XML
Encoding.GetEncoding("utf-8"));//设置encoding类型为:utf-8
xtw.WriteRaw("<?xml version=/"1.0/" encoding=/"utf-8/"?>");
ds.DataSetName = "UpdateLog";//这里改了dataSet对像的名称,对应了XML文档的根结点
ds.WriteXml(xtw);
xtw.Close();
Page.RegisterStartupScript("", "<script language='javascript'>alert('生成成功! ')</script>");
}