Login username and password is matched open other page

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);
                       }
                   }