المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : how to combine two dataset to one xml file



C# Programming
08-11-2011, 02:50 PM
how to combine two dataset to one xml file

and how to read this after ?

i have this:

dsView1 = new DataSet("1");
SQL = "SELECT * FROM ConfTbl";
adp = new OleDbDataAdapter(SQL, Conn);
adp.Fill(dsView1, "ConfTbl");
adp.Dispose();
dsView2 = new DataSet("2");
SQL = "SELECT * FROM DipTbl";
adp = new OleDbDataAdapter(SQL, Conn);
adp.Fill(dsView2, "ConfTbl");
adp.Dispose();
dsView.WriteXml(@"d:\Test.xml");

how to combine dsView1 and dsView2 to one dataset, that i have table[0] and table[1]

thanks in advance