Accessµ¼³öxml

Êý¾Ý¿âÖÐÓжà¸ö±í£¬eg£¬SMT_Folder_Table£¬SMT_Object_Table£¬SMT_Control_TableµÈ£¬¹ØϵÊÇ£ºSMT_Object_Table.ParentID=SMT_Folder_Table.ID,  SMT_Control_Table.ParentID=SMT_Object_Table.ID
ÔõÑùдsqlÓï¾ä£¬½«ÕâÈý¸ö±íÖеÄÄÚÈݶÁ³öÀ´Ð´³ÉÏëxmlÎļþ£¿

ÏÖÔÚÎҵĴúÂëÊÇÕâÑùµÄ
C# code:

DataTable dt = new DataTable();
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @"E:\Project\Copy of SmartTesterNet\SmartTesterNet.Web\App_Data\MR_System_All.mdb"))
{
try
{
OleDbCommand cmd = new OleDbCommand("select * from SMT_Folder_Table,SMT_Object_Table where SMT_Object_Table.ParentID =SMT_Folder_Table.ID", conn);
OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
oda.Fill(dt);
dt.TableName = "SMT_Folder_Table";
cmd.Dispose();
}
catch (Exception ex)
{
conn.Close();
throw new Exception(ex.Message);
}
}

dt.WriteXml(@"E:\Project\Copy of SmartTesterNet\SmartTesterNet.Web\App_Data\123.xml",true);



µÃµ½µÄ½á¹ûÊÇÒÔϸñʽ
XML code

---

Cod