0

Hi All, am a new web developer in ASP.NET, am developing an application that involves user Interface. In my application am assuming that there is already a database which consists of user profile e.g Username, password, Firstname etc., so I created a database and I manually put in values. the reason why am doing this is that there is already an existing application interface which am not going to deal with.
Also, I created a login button with username and password and I want the application to check if username and password are valid before allowing the User to log in. I used two sqldatasource control for the username and password, in the Where tab I clicked on Control e.g userrname and ControlId e.g userTxt(this is the text box).The application is working if the user enter correct username and password but for the other way is not really working. dnt knw where the problem is.
How can I encrypt my the password and also how can I make the user to change their password so that it can reflect in the existing database
. here is my code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LoginMenu.aspx.cs" Inherits="LoginMenu" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            text-align: center;
            font-family: Arial, Helvetica, sans-serif;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       
            <p style="margin-left: 320px">
               
                <asp:Label ID="UserLb" runat="server" Text="UserName"></asp:Label>
                
                <asp:TextBox ID="UserTxt" runat="server"></asp:TextBox>
               
                <asp:RequiredFieldValidator ID="RequiredUserTxt" runat="server" 
                    ControlToValidate="UserTxt" ErrorMessage="Required"></asp:RequiredFieldValidator>
                
                <asp:Label ID="Label1" runat="server" Text="Enter correct name" Visible="False"></asp:Label>
            </p>
            <p style="margin-left: 320px">
               
                <asp:Label ID="PasswrdLb" runat="server" Text="Password"></asp:Label>
                
                <asp:TextBox ID="PasswrdTxt" runat="server"></asp:TextBox>
                
                <asp:RequiredFieldValidator ID="RequiredPasswrdTxt" runat="server" 
                    ControlToValidate="PasswrdTxt" ErrorMessage="Required"></asp:RequiredFieldValidator>
               
                <asp:Label ID="Label2" runat="server" Text="Enter Correct Password" 
                    Visible="False"></asp:Label>
            </p>
                        
                        
                <asp:Button ID="LogOnBtn" runat="server" Height="26px" onclick="LogOnBtn_Click" 
                    Text="LogOn" />
            </p>
            <p style="margin-left: 320px">
                Do You want to Change Your Password?&nbsp;&nbsp;
                <asp:HyperLink ID="ChangePasswrdHyp" runat="server" 
                    NavigateUrl="~/ChangePassword.aspx">Click Here</asp:HyperLink>
                
            <p style="margin-left: 320px">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    SelectCommand="SELECT * FROM [Users] WHERE ([UserName] = @UserName)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="UserTxt" Name="UserName" PropertyName="Text" 
                            Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </p>
            <p style="margin-left: 320px">
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    SelectCommand="SELECT * FROM [Users] WHERE ([Password] = @Password)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="PasswrdTxt" Name="Password" 
                            PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </p>
        </ContentTemplate>
		
		
        <asp:Label ID="UserLb0" runat="server" Text="UserName"></asp:Label>
        <asp:TextBox ID="UserTxt0" runat="server"></asp:TextBox>
       
  
  <asp:Label ID="PasswrdLb0" runat="server" Text="Password"></asp:Label>
        <asp:TextBox ID="PasswrdTxt0" runat="server"></asp:TextBox>
                
        <asp:CheckBox ID="CheckBox2" runat="server" />
        
       
        <asp:Button ID="LogOnBtn0" runat="server" Height="26px" 
            onclick="LogOnBtn_Click" Text="LogOn" />
        
        
        To Change Your Password? <asp:HyperLink ID="HyperLink2" runat="server">HyperLink</asp:HyperLink>
        &nbsp;</p>
    </form>
    </body>
</html>





 protected void LogOnBtn_Click(object sender, EventArgs e)
    {
        DataView user_reader = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
       
        DataView password_reader = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);


        if (user_reader.Table.Rows.Count == 0)
            this.Label1.Visible = true;
        else
        {
            if (password_reader.Table.Rows.Count == 0)
                this.Label2.Visible = true;
            else
                Response.Redirect("ChangePassword.aspx");
             
         
            }
    
        

        


    }

    
}

cheers

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by nikweb
0

Its just the label that I used to display the error message that is malfunctiong. for example if the user enters correct name, wrong password, it will display an error messaga(enter correct password). if the user now enter correct Username and correct passwrd it will go to the required page but the error message will still show. the same thing applies to Username error message.
The error message remain static once it being popup even when the person enters correct data.

cheers

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.