execute one insert query and two update query, in one single button click.

[mails4vijay]

i need to execute one insert query and two update query, in one single button click. how can i start write code in vb.net windows application.....

[reena12]

Hi,

Dim con as new Oledbconnection
con = new Oledbconnection(constring)
con.open()

Dim cmd1 as new OledbCommand
cmd1 = new OledbCommand("Insert Query",con)
cmd1.executenonquery()

cmd1 = new OledbCommand("Update Query 1",con)
cmd1.executenonquery()

cmd1 = new OledbCommand("Update Query 2",con)
cmd1.executenonquery()

con.close()

[Jx_Man]

open & close connection for every query.