protected void Page_Load(object sender, EventArgs e) { string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\abc\\My Documents\\Visual Studio 2005\\WebSites\\test\\App_Data\\test.mdb"; OleDbConnection con = new OleDbConnection(connectionString); DataTable dt = new DataTable(); //creating new connection to database Employee con.Open(); //opening connection //assigning data to DataAdapter according to the query OleDbDataAdapter adpt = new OleDbDataAdapter("select * from emp", con); //filling dataset. adpt.Fill(dt); dt.WriteXml("test.xml"); con.Close(); }
IDynamicMetaObjectProvider
IXmlSerializable
dt.WriteXml("test.xml");
dt.WriteXml("C:\test.xml");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)