【C#】mysqlと接続した状態（Fill）にて、DataGridViewの最後尾にデータを入力、確定させたい。

using System;
using System.Data;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace WindowsFormsMySql
{
    public partial class Form2 : Form
    {
        MySqlDataAdapter adapter;
        DataTable table;

        public Form2()
        {
            InitializeComponent();

            this.dataGridView1.DataSource = this.bindingSource1;
        }

        private void Form2_Load(object sender, EventArgs e)
        {       
            var connString = "接続文字列";
            var selectQuery = "select Id, Name, Qty, UnitPrice from list";

            var connection = new MySqlConnection(connString);
            var command = new MySqlCommand(selectQuery, connection);
            this.adapter = new MySqlDataAdapter();
            this.adapter.SelectCommand = command;
            _ = new MySqlCommandBuilder(this.adapter);
            this.table = new DataTable();

            this.adapter.Fill(this.table);
            this.bindingSource1.DataSource = this.table;

            this.components.Add(connection);
            this.components.Add(command);
        }

        private void Update_Click(object sender, EventArgs e)
        {
            this.bindingSource1.EndEdit();
            this.adapter.Update(this.table);
        }

        private void Remove_Click(object sender, EventArgs e)
        {
            this.bindingSource1.RemoveCurrent();
        }

        private void Paste_Click(object sender, EventArgs e)
        {
            string data = Clipboard.GetText();
            if (!string.IsNullOrEmpty(data))
            {
                string[] array = data.Split(new char[] { '\t' });
                if (array.Length == 4)
                {
                    DataRow row = this.table.NewRow();
                    row["Id"] = int.Parse(array[0]);
                    row["Name"] = array[1];
                    row["Qty"] = int.Parse(array[2]);
                    row["UnitPrice"] = decimal.Parse(array[3].Trim());

                    table.Rows.Add(row);
                }
            }
        }
    }
}