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; }