How to read database values from backend to front end in login page?

SqlConnection objConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionString"].ToString());
               SqlCommand objCommand = new SqlCommand();
               SqlDataReader dr;
               objConnection.Open();
               objCommand.Connection = objConnection;
               objCommand.CommandType = CommandType.Text;
               objCommand.Parameters.Clear();
               objCommand.CommandText = "select Count(*) from Table_Name where [UserId]='" + UserId + "' and [Password]='" + Password + "' and Status='A' ";
               int val = int.Parse(objCommand.ExecuteScalar().ToString());
               if (val > 0)
               {
                   while (dr.Read())
                   {
                       //like this retrieve all values
                       if (dr["UserId"] != System.DBNull.Value)
                       {
                           if (dr.HasRows == true)
                           {
                               int UserId = Convert.ToInt32(dr["UserId"]);
                           }
                       }
                       if (dr["Password"] != System.DBNull.Value)
                       {
                           if (dr.HasRows == true)
                           {
                               string Slno = dr["Password"];
                           }
                       }
                   }
               }