Help Regarding Login page

gokilavasan m

14y2.5k.NET

hi,

i want to create login page with 2 labels for username and password,2text boxes,and 3 buttons for login,signup,cancel.if i press login button means the data's(username,password) are retrived from the sqlserver.and if i click signup means i want to enter some(firstname,lastname,age....) details.i don't know how to i do it.please help me.if i click cancel button means the page is exit from the server.

thanks & regards

gokilavasan

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Accepted answer
Hi Gokilavasan,

For sign up

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Register_using_param.WebForm1" %>

    Untitled Page

















using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Register_using_param
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
        string str;
        SqlCommand cmd;


        protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str="INSERT INTO test VALUES (@amount, @description)";
            cmd = new SqlCommand(str,con);
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@amount", Convert.ToInt64(txt_amount.Text));
            cmd.Parameters.AddWithValue("@description", rtxt_description.Text);
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
            con.Close();
            Response.Write("Records Inserted");
        }
    }
}

For login

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="login_using_parameter._Default" %>

    Untitled Page







                 Width="100px" BackColor="#FFFF66" ForeColor="#FF3300">


                    Width="100px" BackColor="#FFFF66" ForeColor="#FF3300">
                    TextMode="Password" Width="100px">

                    BackColor="#CCFF99" onclick="btn_login_Click" />






using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace login_using_parameter
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string str = null;
        SqlCommand com;

        protected void btn_login_Click(object sender, EventArgs e)
        {
            object obj = null;
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select count(*) from login where UserName=@UserName and Password =@Password";
            com = new SqlCommand(str, con);
            com.CommandType = CommandType.Text;
            com.Parameters.AddWithValue("@UserName", TextBox_user_name.Text);
            com.Parameters.AddWithValue("@Password", TextBox_password.Text);
            obj = com.ExecuteScalar();
            if ((int)(obj) != 0)
            {
                lb1.Text = "WELLCOME :: " + TextBox_user_name.Text;
            }
            else
            {
                lb1.Text = "invalid user name and password";
            }
            con.Close();
        }
    }
}

Thanks
gokilavasan m14y ago
very very very thank u
gokilavasan m14y ago
very very very thank you

Senthilkumar14y ago

Hi,

Step 1:
Create the sql server table.

CREATE TABLE Users

(

UserID INT IDENTITY(1,1) PRIMARY KEY

,FirstName VARCHAR(100)

,LastName VARCHAR(100)

,UserName VARCHAR(100)

,Password VARCHAR(100)

,Address VARCHAR(100)

,LastUpdatedDate DATETIME DEFAULT GETDATE()

)

Step 2:
Design the login page:

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

Untitled Page

User name:
Password:

onclick="btnSignin_Click" />

Don't have user id? then	onclick="lbtnsignup_Click">

Code File:

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class Default3 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnSignin_Click(object sender, EventArgs e)

{

if (!string.IsNullOrEmpty(txtUserName.Text) && !string.IsNullOrEmpty(txtPassword.Text))

{

SqlConnection sqlConnection = new SqlConnection();

sqlConnection.ConnectionString = @"Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;";

sqlConnection.Open();

string sqlQuery = "SELECT * FROM Users WHERE UserName=@UserName AND Password=@Password";

SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);

sqlCommand.CommandType = CommandType.Text;

sqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar).Value = txtUserName.Text.Trim();

sqlCommand.Parameters.Add("@Password", SqlDbType.VarChar).Value = txtPassword.Text.Trim();

SqlDataReader sreader = sqlCommand.ExecuteReader();

string _userName = string.Empty;

string _password = string.Empty;

while(sreader.Read())

{

_userName = sreader[3].ToString();

_password = sreader[4].ToString();

}

sqlConnection.Close();

if (txtUserName.Text.Trim() == _userName && txtPassword.Text.Trim() == _password)

{

Response.Redirect("welcome.aspx");

}

else

{

lblMessage.Text = "User name/password wrong! Try again!!";

}

else

{

}

protected void lbtnsignup_Click(object sender, EventArgs e)

{

Response.Redirect("Registration.aspx");

}

Step 3: If they don't have user id then registration page

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

Untitled Page

User Registration Form
First Name:
Last Name:
Username:
Password:
Address:
onclick="btnSubmit_Click" /> Text="Reset" onclick="btnReset_Click" />

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class Registration : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnReset_Click(object sender, EventArgs e)

{

ClearFields();

}

private void ClearFields()

{

txtFirstName.Text = "";

txtLastName.Text = "";

txtUserName.Text = "";

txtPassword.Text = "";

txtAddress.Text = "";

}

protected void btnSubmit_Click(object sender, EventArgs e)

{

SqlConnection sqlConnection = new SqlConnection();

sqlConnection.ConnectionString = @"Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;";

sqlConnection.Open();

string sqlQuery = "INSERT INTO Users(FirstName,LastName,UserName,Password,Address) VALUES(@FirstName,@LastName,@UserName,@Password,@Address)";

SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);

sqlCommand.CommandType = CommandType.Text;

sqlCommand.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = txtFirstName.Text.Trim();

sqlCommand.Parameters.Add("@LastName", SqlDbType.VarChar).Value = txtLastName.Text.Trim();

sqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar).Value = txtUserName.Text.Trim();

sqlCommand.Parameters.Add("@Password", SqlDbType.VarChar).Value = txtPassword.Text.Trim();

sqlCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = txtAddress.Text.Trim();

int irows = sqlCommand.ExecuteNonQuery();

lblMessage.Text = "User inserted successfully...";

ClearFields();

}