ASP.Net
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 typecmd
in the box. - Go to c:\Windows\Microsoft.Net\framework\v2.xxxxx folder.
- Run the command
aspnet_regiis.exe -i
- Open the command line, go to
- 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, if not, then add it.
- Restart IIS.
- Go to
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>