Mega Code Archive

 

Categories / ASP.Net Tutorial / Response

 

Extracting XML from a SQL Server with System Data DataSet (C#)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"  Inherits="_Default" %> File: Default.aspx.cs using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {         string connStr = "database=Northwind;Data Source=.\\SQLEXPRESS;User id=Joe;pwd=password";         using (SqlConnection conn = new SqlConnection(connStr))         {             SqlCommand command = new SqlCommand("select * from customers", conn);             conn.Open();             DataSet ds = new DataSet();             ds.DataSetName = "Customers";             ds.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "Customer");             Response.ContentType = "text/xml";             ds.WriteXml(Response.OutputStream);         }     } }