From Bashlinux
Jump to: navigation, search

How to install ASP .Net on IIS and Windows XP Pro

The following steps are necessary to register ASP.Net 2.xxxxx on IIS, which already comes on Windows XP:

  • Register ASP .Net
    1. Open the command line, go to Start > run and type cmd in the box.
    2. Go to c:\Windows\Microsoft.Net\framework\v2.xxxxx folder.
    3. Run the command aspnet_regiis.exe -i
  • Check IIS Setup
    1. Go to Start > Control Panel > Administrative Tools > Internet Information Services menu.
    2. Expand local computer node.
    3. Right Click on Web Sites folder.
    4. On sub-menu click on Properties.
    5. Click on Documents tab.
    6. Ensure Default.aspx is listed on Default documents, if not, then add it.
    7. Restart IIS.

How to connect ASP .Net to MS SQL Server

Connection string for MS SQL Server from ASP .Net

  • Create a Connection String by adding the following code into the <configuration> tags in web.config file:
  <add name="MyDbConn" 
       connectionString="Server=PC2007\SQLEXPRESS; Database=MyDb; User Id=MyUser; password=MyPass"
       providerName="System.Data.SqlClient" />
  • Create a Deafault.aspx file with the following content:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "">

<script runat="server">
  protected void Page_Load(object sender, EventArgs e) {
     using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDbConn"].ToString())) {
         SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM authors", cn);
         SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         Response.Write(rdr[0].ToString()); //read a value

<html  >
<head runat="server">
   <title>SQL Authentication</title>