用DataSet直接把数据表读取为XML的例子

 

页面代码

Default.aspx

<% ... @ Page Language="C#" AutoEventWireup="true" ContentType="text/xml"  
CodeFile="Default.aspx.cs" Inherits="_Default"  %>

Default.aspx.cs

using  System;
using  System.Data;
using  System.Configuration;
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 =
            "Data Source=./SQLEXPRESS;AttachDbFilename=|DataDirectory|/Database.mdf;Integrated Security=True;User Instance=True";
        SqlConnection conn = new SqlConnection(connStr);
        SqlDataAdapter sqlAdapter = new SqlDataAdapter("select * from userTable;",conn);
        DataSet dataSet = new DataSet();
        try
        ...{
            sqlAdapter.Fill(dataSet);
            Response.Write(dataSet.GetXml());
        }
        catch (SqlException ex)
        ...{
            Response.Write(ex);
        }
        
    }
}