SqlConnection conn;

        private void Page_Loaded(object sender, RoutedEventArgs e)
        {
            //set up sql connection and querry command from UserName database
            conn = new SqlConnection("Data Source=(local);Initial Catalog=UserName;Integrated Security=SSPI;");
            SqlDataReader rdr = null;
            //create an array to compare passwords in database to typed in password
            string[] Pword = new string[0];
 
            try
            {
                // Open the connection
                conn.Open();

                SqlCommand cmd = new SqlCommand("select Password from Login", conn);
                int x = 0;
                // 2. Call Execute reader to get query results
                rdr = cmd.ExecuteReader();

                // print the CategoryName of each record
                while (rdr.Read())
                {
                    Pword[x]=rdr[0].ToString();
                     x++;
                }
            }
            finally
            {
                // close the reader
                if (rdr != null)
                {
                    rdr.Close();
                }
 
                // Close the connection
                if (conn != null)
                {
                     conn.Close();
                }
            }   
        }