private void button1_Click(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
string strPro = @"Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\GOFFBEES\Desktop\product_db.mdb";
conn.ConnectionString = strPro;
conn.Open();
string SQL;
SQL = "Insert into tbl_product
(product_id,product_name,product_desc,prodct_price,product_in_stock,product_re_order)";
SQL += "values ('" + tbproduct_id.Text + "','" + tbproduct_name.Text + "'";
SQL += ",'" + tbproduct_desc.Text + "','" + tbproduct_price.Text + "'";
SQL += ",'" + tbproduct_in_stock.Text + "','" + tbproduct_re_order.Text + "')";
OleDbCommand cmdInsert = new OleDbCommand(SQL, conn);
cmdInsert.ExecuteNonQuery(); ------------------------------------มันติดตรงนี้-----------------------------
SQL = "select*from tbl_product order by product_id";
OleDbCommand selectCMD = new OleDbCommand(SQL, conn);
OleDbDataAdapter productDA = new OleDbDataAdapter();
productDA.SelectCommand = selectCMD;
DataSet productDS = new DataSet();
productDA.Fill(productDS, "product");
data.DataSource = productDS;
data.DataMember = "product";
}