ASP.NET Tutorial/Response/ContentType

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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

   <source lang="csharp">

<%@ 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);
       }
   }

}</source>


Extracting XML from a SQL Server with System.Data.DataSet (VB)

   <source lang="csharp">

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> File: Default.aspx.vb Imports System.Data Imports System.Data.SqlClient Partial Class _Default 

   Inherits System.Web.UI.Page
   Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) _
          Handles Me.Load
       Dim connStr As String = "database=Northwind;Data Source=.\SQLEXPRESS; " _
              & "User id=Tom;pwd=password"
       Using conn As New SqlConnection(connStr)
           Dim command As New SqlCommand("select * from customers", conn)
           conn.Open()
           Dim ds As New DataSet()
           ds.DataSetName = "Customers"
           ds.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "Customer")
           Response.ContentType = "text/xml"
           ds.WriteXml(Response.OutputStream)
       End Using
   End Sub

End Class</source>


Response.ContentType = "image/jpeg"

   <source lang="csharp">

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Image" Debug="true" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> 

   <title>Untitled Page</title>

</head> <body> </body> </html> File: Default.aspx.cs using System; using System.Web; using System.Web.UI; using System.IO; public partial class Image : System.Web.UI.Page { 

   protected void Page_Load(object sender, EventArgs e)
   {
       string fileName = Server.MapPath(@"/1.jpg");
       Response.ContentType = "image/jpeg";
       Response.WriteFile(fileName);
   }

}</source>

Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/Response/ContentType&oldid=3449»