user authentication login C# Desktop App

Henok Yeshitila

I want a program that create database and table (username, password) field in mysql then authenticated users in C# desktop application.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi Henok,

Try this Code,
Login_ButtonClick() //Write the code in login button
{
string UserName=txtUserName.Text;
string UserName=txtPassword.Text;
int IsPresent;
using(Sql Connection=new SqlConnection("Connectionstring"))
{
SqlCommand cmd=new SqlCommand("select UserName from LoginTable where UserName='"+UserName+"' and Password='"+Password+'"",con);
isPresent=cmd.ExecuteScalar();
}
if(IsPresent>0)
{
/Redirect to next form
}
else
{
MessageBox.Show("Invalid User Name and Password");
}
}
Ramesh Palanivel9y ago
Hi Henok,

My Suggestion is ,

Take the backup of your database and put the back up in installed folder.

First time run the application , it want to check whether the database already exists or not,

If it not exist restore the backup to your server, It is exist don't restore the db.

you can restore the database db using C#..

Try this link, It will help you!..

http://www.c-sharpcorner.com/UploadFile/rohatash/restore-sql-server-backup-file-with-C-Sharp/
Henok Yeshitila9y ago
Hi Rami,

its good code but my requirement is when the application Installed the program create the Database automatically.
Munesh Sharma9y ago
go to the following link

http://geekswithblogs.net/Ramaraju/archive/2009/07/14/windows_authentication_in_winform_application.aspx