How do I go about validating login

Question

0.00/5 (No votes)

See more:

Here is what I have done up til now, I have two text boxes and two buttons, with prett standard names my approch is like this.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace AccessLogin
{
    public partial class LogIn : Form
    {
        public LogIn()
        {
            InitializeComponent();
        }
        OleDbConnection connect = new OleDbConnection();

        private void btnOk_Click(object sender, EventArgs e)
        {
            
            connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\XX\Documents\Visual Studio 2013\Projects\Access\Database.accdb;Persist Security Info=False";
            string UserName = txtUserName.Text;
            string PassWord = txtPassWord.Text;
            connect.Open();
            OleDbCommand cmd = new OleDbCommand("SELECT UserName, PassWord FROM TAdminPW WHERE"); 
        }

    }
}

So now I think I am makeing connection and I need the logic where I should see that the entered user name and pass word exists in the DB if so the I can have access to the main program.
Thanks in advance for your assistence

Posted 4-Mar-14 12:02pm

Jahangir Khan

Add a Solution

3 solutions

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)

Peter Leow · Accepted Answer · 2014-03-04T14:02:00

Try this:

C#

string connectionString= @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\XX\Documents\Visual Studio 2013\Projects\Access\Database.accdb;Persist Security Info=False";
string sql= "select count(*) from TAdminPW where UserName=@UserName and [PassWord]=@Password"
using(OleDbConnection con = new OleDbConnection(connectionString))
using(OleDbCommand cmd = new OleDbCommand(sql, con))
{
     con.Open();
     cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
     cmd.Parameters.AddWithValue("@Password", txtPassWord.Text);
     int result = (int)cmd.ExecuteScalar()
     if(result > 0)
          MessageBox.Show("Login Successful.");
     else
         MessageBox.Show("Login Failed!");
}

Aravindba · Accepted Answer · 2014-03-04T16:08:00

Hai
Solution 1 is work fine,if u want ur coding way try this

C#

   private void btnOk_Click(object sender, EventArgs e)
        {
            
            connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\XX\Documents\Visual Studio 2013\Projects\Access\Database.accdb;Persist Security Info=False";
DataTable dt1 = new DataTable();
string strcmd1 = "";
OleDbDataAdapter cmd1 = new OleDbDataAdapter;
            string UserName = txtUserName.Text;
            string PassWord = txtPassWord.Text;
            connect.Open();
           strcmd1  = ("SELECT UserName, PassWord FROM TAdminPW WHERE UserName='" & txtUserName.Text.Trim() & "' and Password='" & txtPassWord.Text.Trim() & "'");


cmd1 = new OleDbDataAdapter(new OleDbCommand(strcmd1));
cmd1.SelectCommand.Connection = connect;

cmd1.Fill(dt1)
if ((dt1.Rows.Count > 0)) {
	//redirect to main page
} else {
	//show worng username or password error msg
}
        }
 
    }
}

Regards
Aravind

Krunal Rohit · Accepted Answer · 2014-03-04T17:38:00

Try something like,

C#

private void btnOk_Click(object sender, EventArgs e)
{
    connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\XX\Documents\Visual Studio 2013\Projects\Access\Database.accdb;Persist Security Info=False";
    string UserName = txtUserName.Text;
    string PassWord = txtPassWord.Text;
    connect.Open();
    OleDbCommand cmd = new OleDbCommand("SELECT * FROM TAdminPW WHERE UserName='"+userName.Txt+"',  Password='" +passwordTxt.Text+ "'"); 
    int n = cmd.ExecuteNonQuery();
    
    if(n > 0)
        MessageBox.Show("Login Successful.");
    else
        MessageBox.Show("Login Failure.");
}

-KR

How do I go about validating login

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0