Difference between revisions of "Aspdotnet"
From Bashlinux
(Redirected page to ASP.Net) |
|||
| Line 1: | Line 1: | ||
| + | #REDIRECT [[ASP.Net]] |
||
| − | __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: |
||
| − | |||
| − | * '''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> |
||
Latest revision as of 01:03, 7 June 2015
Redirect to:
