private void Places_Click(object sender, RoutedEventArgs e)
        {
            SearchStatus.Visibility   = Visibility.Hidden;
            SearchCategory.Visibility = Visibility.Hidden;
            SearchPlace.Visibility    = Visibility.Visible;
            SearchPlace.Focus();
            string connetionString = null;

            connetionString = "Data Source=SLAVIK;Initial Catalog=hotel;Integrated Security=True;";
            SqlConnection  cnn     = new SqlConnection(connetionString);
            string         command = "Select NumberOfRoom as [Номер комнаты], Place as [Место] from Places";
            SqlDataAdapter da      = new SqlDataAdapter(command, cnn);
            DataSet        dt      = new DataSet();

            da.Fill(dt, "Places");
            DataGrid1.ItemsSource = dt.Tables[0].DefaultView;
        }