c# Datagridview, Values для ID, dateTimePicker1

c# Datagridview с подключенной базы данных Mysql, пользователь заносит данные в Базу данных через Datagrid, у меня в базе данных ID стоит AUTO_INCREMENT, есть dateTimePicker1 (в базе стоит тип date) вот при вводе данных выскальзывает ошибка (MySql.Data.MySqlClient.MySqlException: "Incorrect integer value: '' for column 'ID' at row 1") на dateTimePicker1 тоже такая ошибка выскакивает ... помогите разобраться

 using MySql.Data.MySqlClient;
 using System.Globalization;
 using System.Threading;
 using System.IO;
 using System.Drawing.Imaging;
 using System.Threading.Tasks;

namespace LOCAL_PROJECT
{


public partial class form1 : Form
{
     
    public form1()
    {
        InitializeComponent();
    }
    DataTable dt = new DataTable("dbmary");
    private MySqlCommand command;
    MySqlConnection con = new MySqlConnection("server = 192.168.1.102; server = admin-admin; UserId = mark; Password = mark; database = mark");
    MySqlDataAdapter adapter = new MySqlDataAdapter();
  
        public void spisok()
       {
        con.Open();
        MySqlDataAdapter adapter = new MySqlDataAdapter(" SELECT* FROM `dbmary` ", con);
        DataSet dset = new DataSet();
        adapter.Fill(dset);
        dataGridView1.DataSource = dset.Tables[0];
        con.Close();
    }
   
    private void ExecuteQuery(string txtQuery)
    {
        spisok();
        con.Open();
        command = con.CreateCommand();
        command.CommandText = txtQuery;
        command.ExecuteNonQuery();
        con.Close();
    }
    private void form1_Load(object sender, EventArgs e)
    {
        spisok();
        dataGridView1.EnableHeadersVisualStyles = false;
        dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.Lime;
        dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Times new Roman", 13, FontStyle.Bold);
        dataGridView1.ColumnHeadersHeight = 35;
        dataGridView1.DefaultCellStyle.Font = new Font("Times new Roman", 12);
        dataGridView1.Columns[0].Width = 40;
        dataGridView1.Columns[1].Width = 140;
        dataGridView1.Columns[2].Width = 160;
        dataGridView1.Columns[3].Width = 490;
        dataGridView1.Columns[4].Width = 400;
                  
    }

    private void button4_Click(object sender, EventArgs e)
    {
        Application.Exit();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        this.Hide();
        menu menu44 = new menu();
        menu44.Show();
    }

  

    private void button2_Click(object sender, EventArgs e)
    {
       con.Open();

      
        // int.Parse(this.dataGridView1.Columns[0].ToString());
     
        string sql = "insert into dbmary(ID, register_date, register_number, name_organization, description, Employee, status) Values ('', '" + dataGridView1.Columns[1].ValueType + "', '" + textBox2.Text + "',  '" + textBox3.Text + "', '" + textBox4.Text + "', '" + textBox1.Text + "','" + "' )";
                
        MySqlCommand cmd = new MySqlCommand(sql, con);

        cmd.ExecuteNonQuery();
        con.Close();
        
        MessageBox.Show("added successfully");
       
        textBox2.Text = string.Empty;
        dateTimePicker1.Text = string.Empty;
        textBox1.Text = string.Empty;
        textBox3.Text = string.Empty;
        //  textBox4.Text = string.Empty;
        spisok();
        dateTimePicker1.Format = DateTimePickerFormat.Custom;
    }
           
    private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
    {
        // dataGridView1.CurrentRow.Cells[0].Value.ToString();
        dateTimePicker1.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
        textBox2.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
        textBox3.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
        textBox4.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
        textBox1.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
        dateTimePicker1.Format = DateTimePickerFormat.Custom;
        DataSetDateTime.Local.ToString();
    }
}

}