将access数据库转换成XML文件

//按钮的事件

protected void Button1_Click(object sender, EventArgs e)
{

using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/MmcDWZ.mdb"))
{
conn.Open();
DataTable tablesName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
//dataGridView1.DataSource = tablesName.DefaultView;
conn.Close();
try
{
string Mypath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "myxmldata";
for (int num = 0; num < tablesName.Rows.Count; num++)
{
DataTable dt = new DataTable();
string AccessTableName = tablesName.Rows[num]["TABLE_NAME"].ToString().Trim();
//MessageBox.Show(Path.DirectorySeparatorChar + "xmldata" + Path.DirectorySeparatorChar);
OleDbCommand cmd = new OleDbCommand("select * from [" + AccessTableName + "]", conn);
OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
dap.Fill(dt);
WriteTableToXml(AccessTableName, Mypath, dt, AccessTableName);
cmd.Dispose();
}
Response.Write("<script language='javascript'>alert('XML数据导出成功');</script>");
}
catch (Exception ex)
{
conn.Close();
throw new Exception(ex.Message);
}
}
}
/// <summary>
/// 将表中数据保存到文件夹folderName下的xml文件xmlName；
/// </summary>
/// <param name="xmlName">要保存的xml文件名称</param>
/// <param name="folderName">文件所在路径，但是并不包括文件名称（Application.StartupPath + Path.DirectorySeparatorChar + "FolderName" + Path.DirectorySeparatorChar;）</param>
/// <param name="dataTable">要保存的数据表</param>
/// <returns>保存成功返回true，否则是false</returns>
public static bool WriteTableToXml(string xmlFileName, string serverFilePath, DataTable dataTable, string tableName)
{
if (dataTable.TableName != tableName)
{
dataTable.TableName = tableName;
}
if (!serverFilePath.EndsWith("//"))
serverFilePath += "//";
if (!xmlFileName.EndsWith(".xml"))
xmlFileName += ".xml";
serverFilePath += xmlFileName;
try
{
string directoryName = Path.GetDirectoryName(serverFilePath);//获取文件所在目录
bool isExists=Directory.Exists(directoryName);//检查该目录是否存在
if (!isExists)//不存在该文件目录，则创建
{
Directory.CreateDirectory(Path.GetDirectoryName(serverFilePath));
}
dataTable.WriteXml(serverFilePath, XmlWriteMode.WriteSchema);
return true;
}
catch
{
return false; ;
}
}