using (var dataReader = command.ExecuteReader())

                    using (var dataReader = command.ExecuteReader())
                    {
                        if (dataReader.HasRows)
                        {
                            while (dataReader.Read())
                            {
                               var username = Convert<string>(reader["UserName"]);
                               var userId = Convert<string>(reader["UserId"]);
                               var userpass = Convert<string>(reader["UserPass"]);
                               var roleId = Convert<int>(reader["RoleId"]);
                            }
                        }
                    }