public void LoginButton_Click(object sender, RoutedEventArgs e)
        {

            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnString"].ToString();

                try
                {
                    conn.Open();
                    var username = UsernameTextbox.Text;
                    var userpass = PasswordBox.Password;
                    string Query = "select * from accounts where username='" + username + "' userpass='" + userpass + "' ";
                    SqlCommand command = new SqlCommand(Query, conn);
                    command.ExecuteNonQuery();
                    SqlDataReader dr = command.ExecuteReader();

                    int count = 0;
                    while (dr.Read())
                    {
                        count++;
                    }
                    if (count == 1)
                    {
                        MessageBox.Show("Logged In");
                    }
                    if (count < 1)
                    {
                        MessageBox.Show("„Login failed. Please try again.");
                    }
                }
                catch (Exception ex)
                {

                    MessageBox.Show(ex.Message);
                }