Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)qqpublished in(发表于) 2014/7/9 1:40:04 使用asp.net函数把DataTable转成XML文件
ASP.NET把DataTable转成XML文件的函数下面我将用ASP.NET把DataTable的数据转成XML格式,并输出生成XML文件。数据库表position有三个字段:字段名 字段类型position_id intposition_name varcharposition_desc varchar下面是Datatable转XML的生成源码: protected void Page_Load(object sender, EventArgs e){//通过数据访问层把position读取到DatatableBizRules.PersonnelDAL pl = new PersonnelDAL();DataTable dt = pl.Getposition();StringBuilder str = new StringBuilder();str.Append(DataTableToXml(dt));this.CreateXml(str.ToString(), "test.xml");Response.Write("生成test.xml成功");}/// /// 生成文件/// /// /// public void CreateXml(string val, string filename){UnicodeEncoding ucode = new UnicodeEncoding();StreamWriter sw = new StreamWriter(Server.MapPath(filename));sw.WriteLine("");sw.WriteLine(val);sw.Close();sw.Dispose();}/// /// 转换成XML格式字符串/// /// /// public string DataTableToXml(DataTable dt){StringBuilder strXml = new StringBuilder();strXml.AppendLine("");for (int i = 0; i < dt.Rows.Count; i ){strXml.AppendLine(" ");for (int j = 0; j < dt.Columns.Count; j ){strXml.AppendLine(" <" dt.Columns[j].ColumnName ">" dt.Rows[i][j] "" dt.Columns[j].ColumnName ">");}strXml.AppendLine(" ");}strXml.AppendLine("");return strXml.ToString();}下面看下生成XML文件的效果:29业务员30业务经理31业务总监如果你使用DataSet,可以把DataSet转成Datatable,再使用上面的方法就可以了。
赞