How to make my userame and password case sensitive in C# windows form

Question

0.00/5 (No votes)

See more:

Good day please i created a login form but i noticed that the username and password is not case sensitive when the password is in capital letter the user can use small letter to log in which is not proper.

What I have tried:

 SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "Select * from Registration where Uname=@user and Password=@pass collate Latin1_General_CS_AS";
            cmd.Parameters.AddWithValue("@user", txtuser.Text);
            cmd.Parameters.AddWithValue("@pass", txtpass.Text);
//

Posted 18-Oct-17 12:09pm

akinwunmi

Updated 19-Oct-17 3:25am

Add a Solution

Comments

PIEBALDconsult 18-Oct-17 19:10pm

Never store passwords like that.

https://www.codeproject.com/Tips/186585/Password-Storage-How-to-do-it
https://www.codeproject.com/Articles/704865/Salted-Password-Hashing-Doing-it-Right
https://www.codeproject.com/Articles/608860/Understanding-and-Implementing-Password-Hashing
https://www.codeproject.com/Articles/14537/The-Art-Science-of-Storing-Passwords

Maciej Los 19-Oct-17 2:01am

My virtual 5!

Patrice T 19-Oct-17 8:32am

What makes you think that the database is not case sensitive ?

Richard Deeming 20-Oct-17 11:52am

Passwords should be case sensitive. Storing them properly, as mentioned above, will take care of that.

Usernames should not be case sensitive. Why would you want john, John and JOhn to be three separate users? Not to mention the additional burden on the users of making them remember the precise case of their username.

1 solution

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)

ZurdoDev · Answer 1 · 2017-10-19T03:25:00

Solution 2

If you do have to have passwords this way then change your COLLATE statement to be SQL_Latin1_General_CP1_CS_AS. That will make the password case sensitive.

Posted 19-Oct-17 3:25am

ZurdoDev

Comments

akinwunmi 19-Oct-17 18:55pm

it is given me incorrect syntax near SQL_Latin1_General_CP1_CS_AS

ZurdoDev 19-Oct-17 19:50pm

Then you'll need to fix the syntax. Not sure what you want me to tell you. You typed something in wrong.

akinwunmi 22-Oct-17 3:17am

this is the code
cmd.CommandText = "Select * from Registration where Uname=@user and Password=@pass SQL_Latin1_General_CP1_CS_AS";

ZurdoDev 22-Oct-17 10:21am

You need the word COLLATE.