How to create an user login in C# with Forms

Question

Hello would like to know how I can create a user login in C # , I'm new in this forum, and programming has only incidentally 2 years thanks for help

Ryan Alford · Answer

or, you could use this.... ================================================== private void btnLogin_Click(object sender, EventArgs e) { string connectionString = "whatever"; string sql = "SELECT COUNT(*) FROM Users WHERE Name = @Name AND Password = @Password"; using (SqlConnection cn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(sql, cn)) { cmd.Parameters.AddWithValue("@Name", txtUserName.Text); cmd.Parameters.AddWithValue("@Password", txtPassword.Text); cn.Open(); int count = (int)cmd.ExecuteScalar(); if (count > 0) MessageBox.Show("Login Successful", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("Login Failed. Try Again.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } ============================================================

Niradhip Chakraborty · Answer

I have two textbox txtEmployeeID is for userName and txtPIN for password,onclick of submit button execute the following code. In my user table usr_vch_Name field is for userId and usr_vch_Password holds tha password bool blnFound = false; SqlConnection sqlCon = null; Array arrOptions; int intIndex = 0; sqlCon = new SqlConnection(ConfigurationManager.AppSettings["con"].ToString());//fetching the connection string from web.config. sqlCon.Open(); SqlCommand cmd = new SqlCommand("select * from Users where usr_int_Type=1 or usr_int_Type=3 ", sqlCon); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr["usr_vch_Name"].ToString() == txtEmployeeID.Text) { if (dr["usr_vch_Password"].ToString() == txtPIN.Text) { blnFound = true; // SUCCESSFULLY USER VALIDATED } } } if (!blnFound) MessageBox.Show("Wrong login info is provided"); txtEmployeeID.Text = ""; txtPIN.Text = ""; dr.Close(); sqlCon.Close();

M K Jangid · Answer

Hello What are u want to know? About Login Page UI or Connectivity of Login control with Database? you can drag and drop Login control from toolbox!!!!!