user authentication login C# Desktop App

Question

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

Ramesh Palanivel · 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" ); } }

Munesh Sharma · Answer

go to the following link http://geekswithblogs.net/Ramaraju/archive/2009/07/14/windows_authentication_in_winform_application.aspx

Ramesh Palanivel · Answer

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 Yeshitila · Answer

Hi Rami, its good code but my requirement is when the application Installed the program create the Database automatically.

user authentication login C# Desktop App

Answers (4)