Difference between revisions of "ASP.Net"

From Bashlinux
Jump to: navigation, search
(Created page with "__NOTOC__ === 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: ...")
 
 
Line 1: Line 1:
 
__NOTOC__
  
__NOTOC__
 
=== How to install ASP .Net on IIS and Windows XP Pro ===
  
=== 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:
 +
The following steps are necessary to register ASP.Net 2.xxxxx on IIS, which already comes on Windows XP:
   
 
* '''Register ASP .Net '''
  
* '''Register ASP .Net '''
−
*# Open the command line, go to ''Start > run'' and type `cmd` in the box.
 +
*# Open the command line, go to <code>Start > run</code> and type <code>cmd</code> in the box.
−
*# Go to `c:\Windows\Microsoft.Net\framework\v2.xxxxx` folder.
 +
*# Go to <tt>c:\Windows\Microsoft.Net\framework\v2.xxxxx</tt> folder.
−
*# Run the command `aspnet_regiis.exe -i`.
 +
*# Run the command <code>aspnet_regiis.exe -i</code>
 
* '''Check IIS Setup'''
  
* '''Check IIS Setup'''
−
*# Go to ''Start > Control Panel > Administrative Tools > Internet Information Services'' menu.
 +
*# Go to <code>Start > Control Panel > Administrative Tools > Internet Information Services</code> menu.
−
*# Expand ''local computer'' node.
 +
*# Expand <tt>local computer</tt> node.
−
*# Right Click on ''Web Sites'' folder.
 +
*# Right Click on <tt>Web Sites</tt> folder.
−
*# On sub-menu click on ''Properties''.
 +
*# On sub-menu click on <tt>Properties</tt>.
−
*# Click on ''Documents'' tab.
 +
*# Click on <tt>Documents</tt> tab.
−
*# Ensure `Default.aspx` is listed on ''Default documents'', and add it if not listed.
 +
*# Ensure <tt>Default.aspx</tt> is listed on <tt>Default documents</tt>, if not, then add it.
 
*# Restart IIS.
  
*# Restart IIS.
   
Line 19: Line 19:
 
Connection string for MS SQL Server from ASP .Net
  
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:
 +
* Create a <tt>Connection String</tt> by adding the following code into the <tt><configuration></tt> tags in <tt>web.config</tt> file:
 
<connectionStrings>
  
<connectionStrings>
 
<add name="MyDbConn"
 
<add name="MyDbConn"
Line 26: Line 26:
 
</connectionStrings>
  
</connectionStrings>
   
−
# Create a `Deafault.aspx` file with the following content:
 +
* Create a <tt>Deafault.aspx</tt> file with the following content:
 
<%@ Page Language="C#" %>
  
<%@ Page Language="C#" %>
 
<%@ Import Namespace="System.Data" %>
  
<%@ Import Namespace="System.Data" %>
 
<%@ Import Namespace="System.Data.SqlClient" %>
  
<%@ Import Namespace="System.Data.SqlClient" %>
  +
−  
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
  
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
  +
−  
 
<script runat="server">
  
<script runat="server">
 
protected void Page_Load(object sender, EventArgs e) {
  
protected void Page_Load(object sender, EventArgs e) {
Line 44: Line 44:
 
}
  
}
 
</script>
  
</script>
  +
−  
 
<html >
  
<html >
 
<head runat="server">
  
<head runat="server">

Latest revision as of 17:17, 9 June 2015

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:
<connectionStrings>
  <add name="MyDbConn" 
       connectionString="Server=PC2007\SQLEXPRESS; Database=MyDb; User Id=MyUser; password=MyPass"
       providerName="System.Data.SqlClient" />
</connectionStrings>
  • 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" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<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);
         cn.Open();
         SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
         rdr.Read();
         Response.Write(rdr[0].ToString()); //read a value
     }
 }
</script>

<html  >
<head runat="server">
   <title>SQL Authentication</title>
</head>
<body/>
</html>
Retrieved from "http://wiki.bashlinux.com/index.php?title=ASP.Net&oldid=941"