首页 > 数据库技术 > 详细

C#读取数据库内容并转换成xml文件

时间:2017-01-17 13:49:54      阅读:373      评论:0      收藏:0      [点我收藏+]
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\bible.mdb");
string query_sql = "select VolumeName,ChapterNumber,SectionNumber,ChineseContent from BibleTable";
try
{
    conn.Open();
    OleDbCommand cmd = new OleDbCommand();
    cmd.CommandText = query_sql;
    cmd.Connection = conn;
    OleDbDataAdapter da = new OleDbDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    cmd.ExecuteNonQuery();

    if (dt.Rows.Count > 0)
    {
        System.IO.StringWriter sw = new System.IO.StringWriter();
        System.Xml.XmlTextWriter xw = new System.Xml.XmlTextWriter(sw);
        dt.TableName = "Bible";
        dt.WriteXml(xw);
        File.WriteAllText("bible.xml", sw.ToString(), Encoding.Default);
    }
}
catch (Exception a)
{
    throw a;
}
finally
{
    conn.Close();
}

 

C#读取数据库内容并转换成xml文件

原文:http://www.cnblogs.com/wzwyc/p/6292627.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!