另一种查询显示方式

后台查出后转换成XML直接显示到页面

-------------------------------------------------------
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString2"].ConnectionString);
        SqlCommand cmd = new SqlCommand("checkuser", con);
        cmd.CommandType = CommandType.StoredProcedure;
        //SqlParameter d=new SqlParameter(
        SqlParameter username = new SqlParameter("@username", SqlDbType.VarChar,50);
        SqlParameter userpwd = new SqlParameter("@userpwd", SqlDbType.VarChar,50);
        //username.Value = "hbu";
        //userpwd.Value = "hbu";
        cmd.Parameters.Add(username).Value="hbu";
        cmd.Parameters.Add(userpwd).Value="hbu";
        con.Open();
        DataSet ds = new DataSet();
        ds.DataSetName = "myname";
        ds.Load(cmd.ExecuteReader(), LoadOption.OverwriteChanges, "myname");
        Response.ContentType = "text/xml";
        ds.WriteXml(Response.OutputStream);
        con.Close();

页面上<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="test_Default" %>
不能有任何标签 不然就出错
登陆页面后只显示xml 并且只有xml