CREATE PROCEDURE usp_Users_VerifyingLogDetails ( @UserName NVARCHAR(50), @PassWord NVARCHAR(50) ) AS BEGIN SELECT * FROM Users Where [UserName] = @UserName AND [Password] = @PassWord AND IsActive = 1 END
using (SqlCommand cmd = new SqlCommand("usp_Users_VerifyingLogDetails", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserName", txtLogUserName.Text.Trim()); cmd.Parameters.AddWithValue("@PassWord", SecureData.EncryptData(txtLogPassword.Text.Trim())); if (con.State != ConnectionState.Open) con.Open(); DataTable dtRole = new DataTable(); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.HasRows) { dtRole.Load(sdr); DashboardForm dbf = new DashboardForm(); dbf.ShowDialog(); } else { MessageBox.Show("User Name and Password Not Matched", "Authontication Error", MessageBoxButtons.OK,MessageBoxIcon.Error); } }
SELECT CASE WHEN [IsActive] = 1 THEN 'TRUE' ELSE 'FALSE' END [IsActive] FROM [dbo].[Users]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)