Привязка данных к элементу управления DataGridView в Windows Forms

 
         private BindingSource bindingSource1 = new BindingSource();
         public Form2()
        {
            InitializeComponent();
        }
 
        private void Form2_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource = bindingSource1;
            GetData("select * from Комната");
        }
 
 
        private void GetData(string selectCommand)
        {
            try
            {
                // Specify a connection string. Replace the given value with a 
                // valid connection string for a Northwind SQL Server sample
                // database accessible to your system.
                string connectionString = @"Data Source=DANIEL-PC\SQLEXPRESS;
                         Initial Catalog=Obshezhitie;
                         Integrated Security=True";
 
                // Create a new data adapter based on the specified query.
                SqlDataAdapter dataAdapter = new SqlDataAdapter(selectCommand, connectionString);
 
                // Create a command builder to generate SQL update, insert, and
                // delete commands based on selectCommand. These are used to
                // update the database.
                SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
 
                // Populate a new data table and bind it to the BindingSource.
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                dataAdapter.Fill(table);
                bindingSource1.DataSource = table;
 
                // Resize the DataGridView columns to fit the newly loaded content.
                //dataGridView1.AutoResizeColumns(
                   // DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            }
           catch (SqlException)
            {
                MessageBox.Show("");
            }

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
 
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
 
        SqlConnection connection;
        SqlDataAdapter adapterView1;
        DataSet dataSet1;
        BindingSource bindingSourceView1;
 
        SqlDataAdapter adapterView2;
        DataSet dataSet2;
        BindingSource bindingSourceView2;
 
        public Form1()
        {
            InitializeComponent();
 
            connection = new SqlConnection(@"Data Source=DANIEL-PC\SQLEXPRESS; Initial Catalog=Obshezhitie; Integrated Security=True"");
            
            adapterView1 = new SqlDataAdapter("select * from Комната", connection);
            dataSet1 = new DataSet();
            adapterView1.Fill(dataSet1, "View");
            bindingSourceView1 = new BindingSource(dataSet1, "View");
 
            dataGridView1.DataSource = bindingSourceView1;
 
 
            adapterView2 = new SqlDataAdapter("select * from Постояльцы", connection);
            dataSet2 = new DataSet();
            adapterView2.Fill(dataSet2, "View_");
            bindingSourceView2 = new BindingSource(dataSet2, "View_");
 
            dataGridView2.DataSource = bindingSourceView2;
 
        }
    }
}

dataGridView1.DataSource = _dataTable;