how to validate user login.. The problem is it always accept the username and password whatever the casing of the text.. I want to validate it exactly from the database.

See more:

C#

MS-Access

command = new OleDbCommand("SELECT uType FROM userAccount WHERE uName=? AND uPass=?", conString.con);
command.Parameters.AddWithValue("?", txtUsername.Text);
command.Parameters.AddWithValue("?", txtPassword.Text);
adapter.SelectCommand = command;
conn.conState();
OleDbDataReader reader = command.ExecuteReader();
if (reader.Read())
{
String uType;
uType = reader["uType"].ToString();

if (uType == "Admin")
{
mainForm mf = new mainForm();
mf.Show();
Hide();
}
else if (uType == "Billing")
{
BILLING bill = new BILLING();
bill.Show();
Hide();
}