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.