Aspdotnet
From Bashlinux
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
- Open the command line, go to Start > run and type `cmd` in the box.
- Go to `c:\Windows\Microsoft.Net\framework\v2.xxxxx` folder.
- Run the command `aspnet_regiis.exe -i`.
- Check IIS Setup
- Go to Start > Control Panel > Administrative Tools > Internet Information Services menu.
- Expand local computer node.
- Right Click on Web Sites folder.
- On sub-menu click on Properties.
- Click on Documents tab.
- Ensure `Default.aspx` is listed on Default documents, and add it if not listed.
- 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>
