Login Control in ASP.NET 3.5

Raj Kumar

34 Comments

Join the conversation! Your thoughts help the community grow.

Miguel Sanchez6y ago
Hi. Where can i find the connectionstring that the control uses to access the aspnetdb database?. By default VS creates the App_data folder that contains the aspnetdb database. This is because my project runs well in Visual Studio, i can autenticate my users, manage them with then ASP net configuration tool but when i publish my site i can't authenticate my users i get "Your Login attemp was not successful. Please try again." message. i checked all the permissions to the folder and did all the suggestions that i found in some forums, but i can't get authenticate my users. Thank you in advence.
kumari Patil11y ago
please instruct me, I am new to asp.net
kumari Patil11y ago
I am getting an error like "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
hothorasman panjaitan11y ago
how to logout after login succes
RS Prajapati12y ago
Good.example
Punita14y ago
I want to develop a site--Online Examination system. For this How can i develop the admin panel??plz explain in detail i am new to asp.net.
Yogesh Upreti15y ago
Hello My dear i have implemented in my local server but still there is a problem with my Login1.PasswordRecoveryUrl not working well while i have typed password wrong more than three times. . . Please revert me back Thanks in advance Yogesh chandra upreti
Hassan Shaqhan15y ago
How to deploy ASPNETDB.mdf to remote server (from local PC to Internet) and what changes that required to be done on web.config file? Thank you - Hassan Shaqhan - [email protected]
- EMMANUEL JESUS15y ago
  No reconoce a login1 Error 2 El nombre 'Login1' no existe en el contexto actual C:\Users\Emmanuel\Documents\Visual Studio 2010\Projects\WebApplication3\WebApplication3\Default.aspx.cs 36 36 WebApplication3 n
- Raj Kumar15y ago
  From Visual Studio, in your Server Explorer tab, you'll notice all of the tables created by default. As well, there are Views, Stored Procedures, etc. First, we want to create a SQL script to recreate all of those objects. So right click the database and select Publish To Provider.This will bring up the Database Publishing Wizard. Select the button to continue.You will be presented with a list of your databases and asked to select your database. There is a checkbox to Script all objects in the database. Select it. Select Next to continue.Now you are given the option to script to a file. It presents a default path, I changed mine.In the next window you will be offered several options. In my case, I needed to change the target database to SQL Server 2008. Select the target you need, then Select to continue. As per Chris Rivera's comment below this blog, if 2008 doesn't show as an option, make sure you download and install SP1.Next you may review the options selected.Click Finish to complete the Wizard. You'll see the progress.Now you have a fancy script generated for you. This script will select, alter, drop, update, insert, etc. etc., all needed values. Now to get this to your database server. Mine happens to be on the same network as my webserver, but not on the same network as my development box, so I created a folder within my project and placed the script in there. When I updated my project, this sql script was then copied to my web server. From my database server, I then copied it via the network to my SQL Server 2008 Web Edition desktop. I opened my Microsoft SQL Server Management Studio and created my new blank database. Just right click Databases, and select New Database. Give it a name and select OK. Then with this new database selected, click the sql file on your desktop and it will open up in your screen. Again, with the new database selected, right click in the script and select "Execute." This will execute the script on the selected database and create all the objects needed.
sathya vcs15y ago
This working only in the current page. How to make to work login status and login name for all the page. Regards, Sathya
jasbir singh15y ago
how to make admin panel in asp.net with .cs
rajeev ranjan15y ago
sir can you please instruct me to design logout page using master page I'm a fresher to .net so please help me out
Sunita15y ago
Information is worhit.
Malek15y ago
the while loop should be like this -------------------------------------------------- while (Dr.Read()) { if ((username == Dr["username"].ToString()) & (password == Dr["password"].ToString())) { boolReturnValue = true; break; } } Dr.Close(); return boolReturnValue; -------------------------------------------------- other wise, it's just going to check the first username in the database.
- Raj Kumar15y ago
  you are right malek thanks.
Rajendra Salokhe15y ago
All articles of Raj Kumar are greate.
satish more15y ago
best of luck in future.....
- Raj Kumar15y ago
  Thanks
ghafran abbas15y ago
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" waiting for yours reply
- Raj Kumar15y ago
  connection string is not working properly. check your connection string.
Durga Sekaran16y agoedited
hi Raj, This example is not working. i am trying to solve that problem. but no answer. If i gave username,password ,then brower running without answer like "login successfully". It showed time expired error.
saeed16y ago
At first thanks for this topic and how can i use oracle provider in web sit administration tool(Figure 2.) because i have one provider (AspNetSqlMembershipProvider) i want (OracleProvider ) how can it be apear ?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
- Raj Kumar15y ago
  first you must change provider for membership and roles from sql server to oracle as above secand you must configration new provider like scand code. but but in your mind you must add references for Oracle.DataAccess.Client and oracle.web thired you must create schema in oracle database and give this user above privilages Change notification Create job Create procedure Create public synonym Create role Create session Create table Create view Drop public synonym Grant access to and allocate space in an Oracle tablespace also for your information ODP.Net have tools for oracle database you can run sql script you can find it in (odp_home)/ASP.NET\SQL you must first with InstallOracleASPNETCommon.sql and run all scripts start with install then you can configuation from admin tools web site 1.<remove name="OraAspNetConString"/> 2. <add name="DORKNOZZLE" connectionString="oracle connection" providerName="Oracle.DataAccess.Client" />
ankit mahendru16y ago
Hey thanks alot ..you saved me alot of time...this was awesome..thanks alot !!
doam minh tam16y ago
thanks you
Pubudini Prasanna17y ago
Your article is very clear to understand. Thank you so much.
mohamed anis17y ago
thanks
MONIA17y ago
Hi Thank u for the post. I am new to .NET and ur post really helped me a lot. can u please post the code for remember me next time option? Thanks in Advance Viki
Pedro17y ago
I am trying to set up a login page and have to use the ASP.NET Web Site Administration Tool in the process. I am running Visual Studio as an administrator. I got the following error message when I clicked to the Security tab in the Administration Tool: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. Any ideas what is going on? Peter
Qais Akhtar18y agoedited
Your example is not working.............
Ambika kandasamy18y ago
Hi, Nice example. Could you please explain detail on asp.net website administration tool? which options to be clicked how to get asp_net.mdf db? Regards, Ambika
- Raj Kumar18y ago
  Just click on ASP.NET configuration link under Website tab. and in security tab click enable roles. that will automatically add ASPNETDB.MDF in App_Data folder.
- Raj Kumar15y ago
  The ASP.NET Web Site Administration Tool is a utility provided along with Microsoft Visual Studio which assists in the configuration and administration of a website created using Microsoft Visual Studio 2005 and later versions Accessing the Tool the Web Site Administration Tool could be accessed by clicking ASP.NET Configuration from the Website menu. It can also be accessed by clicking on the ASP.NET Configuration icon in the Solution Explorer window. Features The ASP.NET Web Site Administration tool is a multi-tabbed utility which has the following features: Web Site Administration Tool Security Tab Web Site Administration Tool Application Tab Web Site Administration Tool Provider Tab Web Site Administration Tool Internals asp_net.mdf is auto generated database which is stored in App_Data asp.net folder in application.

.LoginControl
{
background-color:#F7F7DE;
border-color:#CCCC99;
border-style:solid;
border-width:1px;
font-family:Verdana;
font-size:10px;
}

And now apply CSS to control.

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Login Control</title>
<link href="StyleSheet.css" type="text/css" rel="Stylesheet" />
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Login ID="Login1" runat="server" CssClass="LoginControl">
<TitleTextStyle BackColor="#6B696B" Font-Bold="True" ForeColor="#FFFFFF" />
</asp:Login>
</div>
</form>
</body>
</html>

If you running the page and if the CSS file is placed in a directory where anonymous access is denied, add the following configuration for the CSS file to your web.config file.

<location path="StyleSheet.css">
  <system.web>
    <authorization>
      <allow users="*"/>
    </authorization>
  </system.web>
</location>

You can add several hyperlinks to your Login control, such as a hyperlink to a help text page, or a hyperlink to to a registration page.

<asp:Login ID="Login1" runat="server" CssClass="LoginControl"
           CreateUserText="Register"
           CreateUserUrl="~/Register.aspx"
           HelpPageText="Additional Help" 
           HelpPageUrl="~/Help.aspx"
           InstructionText="Please enter your user name and password for login.">
  <TitleTextStyle BackColor="#6B696B" Font-Bold="True" ForeColor="#FFFFFF" />
</asp:Login>

Looks like this

Here is.CS Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
            ViewState["LoginErrors"] = 0;
    }
    protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    {
        if (YourValidationFunction(Login1.UserName, Login1.Password))
        {
            // e.Authenticated = true;
            Login1.Visible = false;
            MessageLabel.Text = "Successfully Logged In";
        }
        else
        {
            e.Authenticated = false;
        }
    }
    protected void Login1_LoginError(object sender, EventArgs e)
    {
        if (ViewState["LoginErrors"] == null)
            ViewState["LoginErrors"] = 0;
        int ErrorCount = (int)ViewState["LoginErrors"] + 1;
        ViewState["LoginErrors"] = ErrorCount;
        if ((ErrorCount > 3) && (Login1.PasswordRecoveryUrl != string.Empty))
            Response.Redirect(Login1.PasswordRecoveryUrl);
    }
    private bool YourValidationFunction(string UserName, string Password)
    {
        bool boolReturnValue = false;
        string strConnection = "server=.;database=Vendor;uid=sa;pwd=wintellect;";
        SqlConnection sqlConnection = new SqlConnection(strConnection);
        String SQLQuery = "SELECT UserName, Password FROM Login";
        SqlCommand command = new SqlCommand(SQLQuery, sqlConnection);
        SqlDataReader Dr;
        sqlConnection.Open();
        Dr = command.ExecuteReader();
        while (Dr.Read())
        {
            if ((UserName == Dr["UserName"].ToString()) & (Password == Dr["Password"].ToString()))
            {
                boolReturnValue = true;
            }
        }
        Dr.Close();
        return boolReturnValue;
    }
}

If you insert the wrong username and password then the message will show like this.

If you insert the right username, and password then redirect your page wherever you want or you can show ma message in ErrorLabel, Like this.

Successfully logged in

I am attaching my database with the application in the pp_Data folder, if u want to use my database then attach my MDF file.

Any questions or queries ask me any time.