C#,数据库读写XML

C#,数据库表读写XML 

//数据表写XML

privatevoid button2_Click(object sender, EventArgs e)

{

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

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

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

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

 

}

 

//读XML

 

privatevoid button3_Click(object sender, EventArgs e)

{

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

    DataTabledataSet = newDataTable("test");

    dataSet.ReadXmlSchema(MyReader);

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

 

    this.dataGridView1.DataSource = dataSet;

    MyReader.Close();

}