private void dataGridView1_SelectionChanged(object sender, EventArgs e)
        {
            using (var connection = new SqlConnection(CONNECTION_STRING))
            {
                var sqlCmd = new SqlCommand("spAgentByDeal", connection);
                sqlCmd.CommandType = CommandType.StoredProcedure;
                sqlCmd.Parameters.AddWithValue("@ид_сделки", LastDealsView.CurrentRow.Cells[0].Value);

                connection.Open();
                var rslt = sqlCmd.ExecuteReader();
                while (rslt.Read())
                {
                    label2.Text = rslt["фио"].ToString();
                    label3.Text = rslt["телефон"].ToString();
                }
                connection.Close();
                connection.Dispose();
                
            }


        }