Hi,
I have created a 2 tables in Access.Front End i'm using Windows Form Application i have designed 3 Textbox. My Query is need to insert first 2 textbox values in 1st table and 2nd table.How to work on this process.I have tried the below coding but it is not working,
con.Open();
OleDbCommand cmd = new OleDbCommand("INSERT INTO SupplierMaster VALUES('" + textBox2.Text + "','" + textBox1.Text + "')", con);
OleDbCommand cmd1 = new OleDbCommand("INSERT INTO wtDetail VALUES [SupCode]='" + textBox2.Text + "'", con);
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
con.Close();
Regards
Balamurugan