Use Response.Write to output data from a database : Response « Page Lifecycle « ASP.NET Tutorial






  1. ASP.NET Tutorial
  2. Page Lifecycle
  3. Response
<%@ Page Language="VB" AutoEventWireup="false"%>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<body>
    Here comes the data!<br />
<%
    Dim connect As New SqlConnection( _
     "Server=mycomp;UID=sa;password=password01;database=Dummies")
    connect.Open()
    Dim cmd As New SqlCommand( _
       "select nameid from names where first_name ='Jeff'", _
      connect)
    Dim id As Int32
    id = cmd.ExecuteScalar()
    connect.Close()
    Response.Write(id)
%>    
    <br />How about that?<br />
</body>
</html>








5.9.Response
5.9.1.Use Response.Write to output data from a database
5.9.2.Response.ContentType
5.9.3.Display all controls on a page
5.9.4.Use Response.Redirect to transfer to another aspx file (C#)
5.9.5.Submit a named parameter via POST
5.9.6.Displaying the HTTP headers collection in ASP.NET
5.9.7.Displaying URL information in ASP.NET
5.9.8.Response.AddCacheItemDependencies
5.9.9.Adding a cache dependency in ASP.NET
5.9.10.Response.AddFileDependencies
5.9.11.Response.AddFileDependency
5.9.12.Response.AppendHeader
5.9.13.Response.AppendToLog
5.9.14.Response.ApplyAppPathModifier
5.9.15.Response.BinaryWrite
5.9.16.Response.BufferOutput
5.9.17.Response.Expires
5.9.18.Response.ExpiresAbsolute
5.9.19.Response.Charset
5.9.20.Response.ClearContent
5.9.21.Response.ClearHeaders()
5.9.22.Response.ContentEncoding
5.9.23.Response.End()
5.9.24.Response.IsClientConnected
5.9.25.Response.Output
5.9.26.Response.PICS
5.9.27.Response.RemoveOutputCacheItem
5.9.28.Response.StatusCode
5.9.29.Response.SuppressContent
5.9.30.Response.Write
5.9.31.Response.WriteFile