C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Code Snippets » XML »

Dataset and XML


Posted Date: 21 Jul 2009    Resource Type: Code Snippets    Category: XML
Author: mahanteshMember Level: Gold    
Rating: 1 out of 5Points: 5



Write dataset values to an XML file.


//Make database connection
SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=Dashboard;Integrated Security=True");
string cmd = "select EmployeeNo,Name,Email from mySymphony";
SqlDataAdapter da = new SqlDataAdapter(cmd, conn);
DataSet ds = new DataSet();
ds.Locale = System.Globalization.CultureInfo.CurrentCulture;
da.Fill(ds);
// Get a StreamWriter object
StreamWriter xmlDoc = new StreamWriter(@"D:\\Mahantesh.Net\ALLWebconceptsamples\ds.xml", false);
// Apply the WriteXml method to write an XML document
ds.WriteXml(xmlDoc);
xmlDoc.Close();
Response.Redirect(@"..\\ALLWebconceptsamples\ds.xml");




Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Sign In to add tags.
Dataset and XML  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Beautify your XML
Previous Resource: Reading XML file in asp.net
Return to Discussion Resource Index
Post New Resource
Category: XML


Post resources and earn money!
 
More Resources



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use