C#,数据库读写XML

C#,数据库表读写XML 

//数据表写XML

private void button2_Click(object sender, EventArgs e)

{

    Db_Class dbClass = new Db_Class(@"E:/northwind.mdb", "");

    DataTable dataSet = dbClass.Db_CreateDataTable("select * from 客户");

    dataSet.WriteXml(@"c:/1.xml");

    dataSet.WriteXmlSchema(@"c:/2.xml");

 

}

 

//读XML

 

private void button3_Click(object sender, EventArgs e)

{

    StreamReader MyReader = new StreamReader(@"C:/2.xml");//XmlSchema

    DataTable dataSet = new DataTable("test");

    dataSet.ReadXmlSchema(MyReader);

    dataSet.ReadXml(new StreamReader(@"C:/1.xml"));

 

    this.dataGridView1.DataSource = dataSet;

    MyReader.Close();

}

数据库操作的类Db_Class看
http://blog.csdn.net/yanleigis/archive/2007/10/23/1838445.aspx