手记

DataSet与Xml相互转化

string sql = "Select Top 10 F_ID,F_Name From T_Product";
            DataSet Ds = Database.ExecuteDataset(conn, CommandType.Text, sql);
            Ds.WriteXml("c:\\test.xml", XmlWriteMode.WriteSchema);//将数据输出到xml
            

            DataSet Ds2 = new DataSet();
            Ds2.ReadXml("c:\\test.xml");//将xml加载到DataSet

            this.GridView1.DataSource = Ds2.Tables[0].DefaultView;
            this.GridView1.DataBind();

0人推荐
随时随地看视频
慕课网APP