data not committed in access using c#

Vote count:

0

try {

if (connection.con.State == ConnectionState.Closed) connection.con.Open();

com = new OleDbCommand("insert into dealer values(@id,@a1,@a2,@a3,@a4,@a5,@a6)", connection.con);

com.Parameters.AddWithValue("@a1",int.Parse(t1.Text)); com.Parameters.AddWithValue("@a2", t2.Text); com.Parameters.AddWithValue("@a3", t3.Text); com.Parameters.AddWithValue("@a4", t4.Text); com.Parameters.AddWithValue("@a5",t5.Text); com.Parameters.AddWithValue("@a6",t6.Text); com.Parameters.AddWithValue("@a7", c1.Text); int i = com.ExecuteNonQuery();

if (i > 0) { MessageBox.Show("dealer Registration Seccessfully !!");

}

} catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally {

connection.con.Close(); }

asked 32 secs ago

Dhiraj Lotake

1

data not committed in access using c#