| | |
execute one insert query and two update query, in one single button click.
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Oct 2008
Posts: 32
Reputation:
Solved Threads: 4
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()
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()
open & close connection for every query.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
![]() |
Other Threads in the VB.NET Forum
- Previous Thread: pass tableadapter as parameter to module
- Next Thread: Updating combobox with items
| Thread Tools | Search this Thread |
"crystal .net .net2008 2008 access add advanced application array assignment basic beginner box browser button buttons center click code combo convert cpu cuesent data database datagrid datagridview datetimepicker designer dissertation dissertations dissertationtopic dosconsolevb.net editvb.net employees excel exists firewall forms html images isnumericfuntioncall listview map math memory mobile module msaccess mssqlbackend mysql navigate net number opacity open pan pdf picturebox picturebox2 port position print printpreview record regex reuse right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure temp textbox timer timespan transparency txttoxmlconverter useraccounts usercontol vb vb.net vb.nettoolboxvisualbasic2008sidebar vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web wpf wrapingcode xml year






