พอกดปุ่ม ลบข้อมุล ก็จะขึ้น MessageBox ที่แสดงรายระเอียด Error ต้องการทราบว่า Error เพราะอะไร ใช้ฐานข้อมูล Access

        private void btDelete_Click(object sender, EventArgs e)
        {
            try
            { 
                connection.Open();
                OleDbCommand command = new OleDbCommand();
                command.Connection = connection;
                string query = "delete from Category where ID_Category = " + txtID_Category.Text + " ";
                command.CommandText = query;
 
                command.ExecuteNonQuery();
                MessageBox.Show("Data Deleted");
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error" + ex);
            }
        }

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.OleDb;

namespace ProJSale
{
    public partial class Category : Form
    {
        private OleDbConnection connection = new OleDbConnection();

        public Category()
        {
            InitializeComponent();
            connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\ProJSale\ProJSale\ProJSale.accdb;";
        }

        private void Customer_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'proJSaleDataSet.Category' table. You can move, or remove it, as needed.
            this.categoryTableAdapter.Fill(this.proJSaleDataSet.Category);
            this.WindowState = FormWindowState.Maximized;
        }

        private void btInsert_Click(object sender, EventArgs e)
        {
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand();
                command.Connection = connection;
                command.CommandText = "insert into Category (ID_Category,NamethaiCategory,NameEngCategory) values('" + txtID_Category.Text + "','" + txtNameThaiCategory.Text + "','" + txtNameEngCategory.Text + "')";

                command.ExecuteNonQuery();
                MessageBox.Show("Data Saved");
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error" + ex);
            }
        }

        private void btDelete_Click(object sender, EventArgs e)
        {
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand();
                command.Connection = connection;
                string query = "delete from Category where ID_Category = " + txtID_Category.Text + " ";
                command.CommandText = query;

                command.ExecuteNonQuery();
                MessageBox.Show("Data Deleted");
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error" + ex);
            }
        }

        private void btEdit_Click(object sender, EventArgs e)
        {
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand();
                command.Connection = connection;
                string query = "Update Category set ID_Category = '" + txtID_Category.Text + "' ,NamethaiCategory = '" + txtNameThaiCategory.Text + "' , where NameEngCategory = '" + txtNameEngCategory.Text + "'";
                MessageBox.Show(query);
                command.CommandText = query;

                command.ExecuteNonQuery();
                MessageBox.Show("Data Edit Successful");
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error" + ex);
            }
        }

        private void btLoad_Click_1(object sender, EventArgs e)
        {
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand();
                command.Connection = connection;
                string query = "select * from Category ";
                command.CommandText = query;

                OleDbDataAdapter da = new OleDbDataAdapter(command);
                DataTable dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt;

                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error" + ex);
            }
        }
    }
}