Home
|
Articles
|
Namespace
|
Interview Questions
|
Tools
|
Jobs
|
Projects
|
Community
»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
Forums
»
ASP.NET Forums»
generate xml file from sql server 2005 database using asp.net (C#) 2.0
Hello, I am working on a web application. I want to generate xml file from database table. I am working on asp.net(C#) 2.0. If you have any idea please guide me. I have done some work on it ---------------------- SqlConnection sqlCon; SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataSet dsTest = new DataSet("table"); DataTable dt = new DataTable("table"); string XmlFileName = ""; protected void Page_Load(object sender, EventArgs e) { XmlFileName = "D:/Ashraf/XMLFileFromdatabase"; sqlconnection con = ConfigurationManager.AppSettings["LocalSqlServer"]; string Query = "select * tblMaster"; XMLGenerate(con, Query, XmlFileName); } private void XMLGenerate(string conString, string Query, string FileName) { sqlCon = new SqlConnection(con); da.SelectCommand = new SqlCommand(Query, sqlCon); da.Fill(dsTest); FileStream fs = null; fs = new FileStream(FileName + ".xml", FileMode.OpenOrCreate, FileAccess.Write); dsTest.WriteXml(fs); fs.Close(); }
© 2008 dotnetwatch.com --
Privacy policy
Website Design
&
Internet Marketing
by Shivam