Ad:

ASP.NET Discussion Thread
Unsolved
Views: 937

Feb 9th, 2010

asp.net login with sql

Expand Post »

I'm trying to create a login system that checks the username and passsword from an sql database.

I've created a local server named coffee that has a table named 'users' - I have created fields for username & password.

I'm using ASP.NET web application and I want to connect to my SQL database 'coffee' and check that if username / password typed into textboxes is the same as database then redirect to new page.

I've tried looking at a few tutorials but its confusing the hell out of me.

I've tried creating my connection string to the database.

ASP.NET Syntax (Toggle Plain Text)
        protected void Page_Load(object sender, EventArgs e)
        {
            string connectionstring = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";                        
            SqlConnection connection = new SqlConnection(connectionstring);
            connection.Open();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            string connectionstring = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";                        
            SqlConnection connection = new SqlConnection(connectionstring);
            connection.Open();
        }

However once submit button is clicked it needs to check the user input against the database. Any help i'd be extremely grateful.

Similar Threads

Simple ASP.Net Login Page using C# in C#
Updated : Simple ASP.Net Login Page in ASP.NET

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Feb 9th, 2010

Re: asp.net login with sql

If u write ur connection string in config file that would be good,
however as a basic tutorial can look that, can get coon string from db properties

Quote ...

STRING USER=TEXBOX1.TEXT;
STRING PASS =TEXBOX2.TEXT
string connectionstring = @"data source=.\\sqlexpress;attachdbfilename=database1.mdf;integrated security=true;user instance=true";

sqlconnection connection = new sqlconnection(connectionstring);
string str = "select * from cafffe where username= '" + user + "'" + "and password='" + password + "'";
sqlcommand cmd = new sqlcommand(str, connect);
connect.open();
sqldatareader red = cmd.executereader();
if (red.hasrows)
{

session["user"] = user;
session["pass"] = password;
red.close();
connect.close();
response.redirect("userpage.aspx");
}

kdcorp87

Reputation Points: 14

Solved Threads: 9

Junior Poster in Training

Offline

54 posts
since Jan 2010

Permalink

Feb 9th, 2010

Re: asp.net login with sql

Thanks for your help

I've written in my web.config

ASP.NET Syntax (Toggle Plain Text)
    <appSettings/>
    <connectionStrings>
        <add name="coffeeConnectionString1" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
    <appSettings/>
    <connectionStrings>
        <add name="coffeeConnectionString1" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Feb 9th, 2010

Re: asp.net login with sql

Click to Expand / Collapse Quote originally posted by dawsonz ...

Thanks for your help

I've written in my web.config
ASP.NET Syntax (Toggle Plain Text)
    <appSettings/>
    <connectionStrings>
        <add name="coffeeConnectionString1" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
<appSettings/> <connectionStrings> <add name="coffeeConnectionString1" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False" providerName="System.Data.SqlClient" /> </connectionStrings>

U R IN COMPLETELY RIGHT TRACK

kdcorp87

Reputation Points: 14

Solved Threads: 9

Junior Poster in Training

Offline

54 posts
since Jan 2010

Permalink

Feb 9th, 2010

Re: asp.net login with sql

Thanks for your help kdcorp.

I've got it working creating my connection string, how can I get it so that I dont have to type a connection string and do it through my web.config

Code:

ASP.NET Syntax (Toggle Plain Text)
namespace number1
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
 
        }
 
        protected void btnSubmit_Click1(object sender, EventArgs e)
        {
            string username = txtUsername.Text;
            string password = txtPassword.Text;
 
            string connectionstring = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";
 
            SqlConnection connection = new SqlConnection(connectionstring);
 
            string str = "SELECT * FROM users WHERE username= '" + username + "'" + "AND password='" + password + "'";
 
            SqlCommand cmd = new SqlCommand(str, connection);
            connection.Open();
            SqlDataReader login = cmd.ExecuteReader();
 
            if (login.HasRows)
            {
                Session["username"] = username;
                Session["password"] = password;
                login.Close();
                connection.Close();
                Response.Redirect("After_Login.aspx");     
            }
         }
    }
namespace number1
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
     
        }

        protected void btnSubmit_Click1(object sender, EventArgs e)
        {
            string username = txtUsername.Text;
            string password = txtPassword.Text;

            string connectionstring = @"Data Source=localhost\sqlexpress;Initial Catalog=coffee;Integrated Security=True;Pooling=False";

            SqlConnection connection = new SqlConnection(connectionstring);

            string str = "SELECT * FROM users WHERE username= '" + username + "'" + "AND password='" + password + "'";

            SqlCommand cmd = new SqlCommand(str, connection);
            connection.Open();
            SqlDataReader login = cmd.ExecuteReader();

            if (login.HasRows)
            {
                Session["username"] = username;
                Session["password"] = password;
                login.Close();
                connection.Close();
                Response.Redirect("After_Login.aspx");     
            }
         }
    }

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

Permalink

Feb 9th, 2010

Re: asp.net login with sql

Quote ...

string connectionstring=configurationmanager.connectionstrings["nameof constring"].connectionstring;

also u can use the select command by stored procedures

Last edited by kdcorp87; Feb 9th, 2010 at 11:17 am.

kdcorp87

Reputation Points: 14

Solved Threads: 9

Junior Poster in Training

Offline

54 posts
since Jan 2010

Permalink

Feb 9th, 2010

Re: asp.net login with sql

Thank you very much, working perfectly now.

Your help is kindly appreciated.

ASP.NET Syntax (Toggle Plain Text)
string connectionstring = ConfigurationManager.ConnectionStrings["coffeeConnectionString1"].ConnectionString;
string connectionstring = ConfigurationManager.ConnectionStrings["coffeeConnectionString1"].ConnectionString;

dawsonz

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

49 posts
since Feb 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: timer_tick event in ASp.net C#

Next Thread in ASP.NET Forum Timeline: JavaScript and CheckBox

DaniWeb Message

Cancel Changes

User Name
Password