In this example I will show you how to create xml document using Linq .In order to extract data from a database and create an xml document we need to include the namespace using System.Xml.Linq. The important class with the Linq to Xml hierarchy XElements and XDocument, XElement class represents an XML element node that contains child elements as child nodes.The output xml file will be saved at a specified location of the project folder.
This example I used northwind sample database for more detail about how to download click link button it will show a popup.
Example:
protected void Page_Load(object sender, EventArgs e)
{
models db = new models();
var customerOrders = from customer in db.Customers
where customer.ContactName.StartsWith("C") && customer.Orders.Count> 0
orderby customer.ContactName
select customer;
var xml = new XElement("customers", from customer in customerOrders.ToList()
select new XElement("ContactName",
new XAttribute("ContactName", customer.ContactName), new XAttribute("phone", customer.Phone)));
var path = Path.Combine(Server.MapPath("~/Xmlfiles"), "file1" + ".xml");
System.IO.File.WriteAllText(path,xml.ToString());
}
Output:
Post your comments / questions
Recent Article
- How to use if else statement in c++?
- How to use godaddy domain name with another godaddy hosting account?
- Restore of database 'DATABASE' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
- How to programmatically modifying the AppSetting value in web.config using c#?
- TypeError [ERR_INVALID_CALLBACK]: Callback must be a function. Received undefined
- How to calculate the age from jQuery ui datepicker using c#?
- How to calculate days difference between two dates in c#?
- Changing date format in jQuery ui datepicker
Related Article