读取Xml中的数据并保存到表里

 protected void Button1_Click(object sender, EventArgs e)
    {
        OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/ExamSystemData/12.mdb");
        conn.Open();
        OleDbDataAdapter adapter = new OleDbDataAdapter("select * from Admin_User_Table", conn);

        DataSet xmlds = new DataSet();
        xmlds.ReadXml(@"c:/test.xml");

        OleDbCommandBuilder cmdb = new OleDbCommandBuilder(adapter);
        cmdb.GetInsertCommand();
        adapter.Update(xmlds, "Table");

        conn.Close();
    }