How to create a login form in visual c# using mysql database

Question

0.00/5 (No votes)

See more:

I am currently creating a login form in visual c#, but i am facing problem on how to check if the user input username and password match with the USERNAME and PASSWORD in mysql table. I want the user to input a username and password in the text box then the program will search the table and if the username and password found. the program will display the main form, if not display error message.

Please help on how to accomplish this task i am beginner in c# or please help if where can i find a references or resources in c# programming and mysql as database.

Thanks.

Posted 13-Oct-12 2:53am

Totoy lubacon

Updated 4-Sep-20 6:04am

Add a Solution

Comments

[no name] 13-Oct-12 9:01am

How is this a problem? Get the username and password from the user, connect to your database, and query the database to see if the username and password are valid.

2 solutions

Solution 2

http://social.msdn.microsoft.com/Forums/sk/csharpgeneral/thread/8b714ff6-acbf-43bf-9ab8-d61921549c36[^]
http://www.c-sharpcorner.com/Forums/Thread/84214/[^]

Posted 13-Oct-12 3:50am

ridoy

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)

Himanshu Yadav · Accepted Answer · 2012-10-13T03:07:00

Solution 1

HI This will help you copy and paste it

C#

SqlConnection con = new SqlConnection("Connection");
            SqlCommand cmd = new SqlCommand("select pwd,userName from LoginTable",con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(da);
            if (txtPassword.Text == dt.Rows[0]["pwd"].ToString() && txtUserName.Text == dt.Rows[0]["userName"].ToString())
            {
                Response.Redirect("abc.aspx");
            }
            else
            { 
            //Error display Msg
            }

Posted 13-Oct-12 3:07am

Himanshu Yadav

Updated 13-Oct-12 3:42am

v2

Comments

[no name] 13-Oct-12 9:11am

And this will allow the OP to connect to a MySql database?

Himanshu Yadav 13-Oct-12 9:12am

OP means

Himanshu Yadav 13-Oct-12 9:13am

asking regarding Connection String

Himanshu Yadav 13-Oct-12 9:18am

is this working ?

Luc Pattyn 4-Sep-20 19:21pm

That is horrible code.

1) whoever stores passwords as plain text should be fired right away.

2) for a single login, you think it is wise to read all known users from the database?

3) You don't need DataAdapters and DataTables for a simple read.

4) Objects that have a Dispose() method should be disposed of when done e.g. SqlConnection.

5) why would the user attempting to log in happen to be in the first row???