| | |
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
Views: 948 | Replies: 2
| Thread Tools | Search this Thread |
Tag cloud for VB.NET
.net 2005 2008 access account application arithmetic array arrays basic bing button buttons c# center check checkbox code combobox component convert crystalreport data database databasesearch datagrid datagridview design designer dissertation dissertations dropdownlist excel file-dialog folder ftp generatetags google gridview hardcopy highlighting images inline insert installer intel internet listview mobile monitor ms net networking output passingparameters peertopeervideostreaming picturebox picturebox1 plugin port print printing problem problemwithinstallation project save searchbox searchvb.net select serial server soap sorting studio syntax table tcp text textbox time timer toolbox trim update updown user vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web wpf






