how to login my webpage using database is sqlserver 2008 give me full code DL & BL & login.aspx.cs

Question

1.00/5 (2 votes)

See more:

how to login my webpage using database is sql server 2008 give me full code..

if may be possible give me separate code dl layer , bl layer then login.aspx.cs
code

thanks

Posted 19-Jun-13 23:48pm

santsho kumar

Updated 19-Jun-13 23:50pm

v2

Add a Solution

4 solutions

Solution 4

Login.aspx.cs page code =============================================

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BL;
using System.Data;
using System.Web.Administration;
using System.Web.UI.HtmlControls;
using System.Web.DynamicData;

public partial class Login : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

}

//login code
protected void Button1_Click(object sender, EventArgs e)
{
clsBLayer c2 = new clsBLayer();

DataSet ds = new DataSet();
ds = c2.LoginToSystem(txtUserName.Text,txtPwd.Text);

if (!String.IsNullOrEmpty(txtUserName.Text))
{
// Session["UserName"] = txtUserName.Text.Trim();
// Response.Redirect("~/Admin/AdminDashboard.aspx");

if (ds.Tables[0].Rows.Count != 0)
{

Session["UserName"] = ds.Tables[0].Rows[0][1].ToString();
Session["UserName"] = txtUserName.Text.Trim();
Response.Redirect("~/Admin/indexAdmin.aspx");
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Invalid Username and Password')</script>");
}
}
}

protected void btnClear_Click(object sender, EventArgs e)
{
clear();
}

protected void clear() {

txtUserName.Text = "";
txtPwd.Text = "";
}

}

DLayer................... code ===================================================

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace DL
{

public class clsDLayer
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString.ToString());
public DataSet LoginToSystem(string UserName, string Passsword)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from tbluser where UserName='" + UserName.ToString() + "' and Password = '" + Passsword.ToString() + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);

return ds;

if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}

BL Layer code: ===============================================================================

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DL;
using System.Data;
using System.Data;
namespace BL
{
public class clsBLayer
{

clsDLayer obj = new clsDLayer();

public DataSet LoginToSystem(string UserName, string Password)
{
DataSet ds = obj2.LoginToSystem(UserName,Password);
return ds;

}
}
}

success full code i use this...

Posted 9-Aug-13 0:02am

santsho kumar

Solution 2

Hello Santosh,

You will find following articles quite useful.

More articles can be found here[^].

Regards,

Posted 19-Jun-13 23:53pm

Prasad Khandekar

Comments

Prasad_Kulkarni 20-Jun-13 6:00am

Even better, +5!

Prasad Khandekar 20-Jun-13 6:10am

Thank's Prasad!

Solution 1

Here you go[^]. The complete code with lot of options.

Posted 19-Jun-13 23:51pm

Prasad_Kulkarni

Comments

Prasad Khandekar 20-Jun-13 5:54am

Nice answer. +5

Prasad_Kulkarni 20-Jun-13 6:00am

Thank you Prasad! :D

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Chintan Desai1988 · Accepted Answer · 2013-06-21T20:11:00

It is very easy way to make login functionality with different classes. Please refer below code it's helping you:

Create two class file for declaring properties and method to perform some operation:

Class1:-----------

C#

//declare properties as per your table defination
namespace _classDL
{
    public class Class1
    {
        public Class1()
        {

        }

        public int id { get; set; }
        public int username { get; set; }
        public int password { get; set; }
    }
}

Class2:-----------

using System.Data;
using System.Data.SqlClient;

namespace _classBL
{
public class Class2
{
SqlConnection cnn = new SqlConnection("Pass your connection string over here");
public Class2()
{

}

public DataSet LoginToSystem(string username, string passsword)
{
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from users where username='" + username.ToString() + "' and '" + passsword.ToString() + "'", cnn);
DataSet ds = new DataSet();
da.Fill(ds);

return ds;

if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
}
}
}

Login.aspx:---------

using System.Data;
using _classBL;
using _classDL;

public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnLogin_Click(object sender, EventArgs e)
{
Class1 c2 = new Class2();

DataSet ds = new DataSet();
ds = c2.LoginToSystem(txtusername.text, txtpassword.text);

if (ds.Tables[0].Rows.Count != 0)
{
Session["username"] = ds.Tables[0].Rows[0][1].ToString();
Response.Redirect("Default.aspx");
}
else
{
Response.Write("Sorry! Incorrect Username and Password.");
}
}
}