private void DepartmentsDirectoryBasic_Load(object sender, EventArgs e)
        {
            dataGridView1.AutoGenerateColumns = false;
            dataGridView1.DataSource = Populate("SELECT * FROM Employees");
        }

 private void SpecialtysDirectoryBasic_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource = Populate("SELECT * FROM specialtys");
        }

        private DataTable Populate(string sqlCommand)
        {
            SqlConnection bcollegeConnection = new SqlConnection(connectionString);
            bcollegeConnection.Open();

            SqlCommand command = new SqlCommand(sqlCommand, bcollegeConnection);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = command;

            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);

            return table;
        }