Execute 3 Commands (SQL Statements) To 3 Different Oracle Tables At One Shot?
Apr 24, 2012
I'm implementing an application using vb.net 2005 with oracle 10g and I came across a functionality that should Select/Insert/Update/Delete data from three different tables in oracle.So I`m wondering if there is a way to prepare all the 3 commands (SQL Statements) separately and then execute them in one shot to the oracle, so in this way I can guarantee that all of them are successfully executed or all are failed to execute, and also I could gain more performance which is critical in my case.Thus I`m looking for a syntax in vb.net that helps me execute more than one OracleCommand in one shot to the oracle.
View 1 Replies
ADVERTISEMENT
Apr 26, 2011
I have some code in Form Load event. It is doing fine. But when it reaches to pick data from database, no commands are executing after that. There is no error at all but it just goes silent.[code]...
View 3 Replies
Nov 7, 2011
I am trying to use Bind Variables in my SQL statements which I pass to an Oracle database, but I get the Oracle error ORA-01008 Not all variables bound.[code]...
View 17 Replies
Dec 31, 2009
catch statements - it works well just checking my disk drive for a file, if an error is thrown then I open the disk tray and ask them to put the disk in, click OK on the message box and it performs another check for the file, if this fails the button that starts all this is disabled on my main form (the code is shown below).
Okay, so my problem is I'd like to have the message box pop up and the have the drive open up (using an API which I have) either at the same time or in the order of: message box then drive open. I can see two ways to do this: Have the commands happen at the same time (Can you even do this?) OR Have the message box appear and then open the disk drive (but how I could achieve this I don't know as the message box waits for the user to click OK... I originally though of starting a timer just before and getting it to open the disk drive tray in the tick event,
Code:
Public Class Form1
'open cd-rom tray API
Private Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" (ByVal lpstrCommand As String, ByVal _
[Code].....
View 5 Replies
Jan 20, 2009
I need to execute AS/400 System Commands thru VB. What would be the way to perform this?
View 4 Replies
Jun 1, 2010
with vb.net05 + access 03;how can i execute a bunch of SQL statements against a connectionwhich are written in a text file (as like we do in reading from backup file in MySQL)
View 9 Replies
Jan 29, 2010
I was rooting around in one of our company apps which is done in VB.net. I'm not familiar with VB.net (I do stuff in C#) so I'm asking this question: Does the code after the clean up comment execute? [code]It is my understanding once you say return, you give the calling function control again.
View 6 Replies
Feb 26, 2012
I am new to VB and am trying to write a program that will open cmd and execute commands when a button is clicked.[code]...
View 14 Replies
Jun 29, 2009
I want to make a program with a button and a textbox. When i click the button the program (don't know how) writes the text from the textbox in a process called test.exe. Test.exe is a cmd like window, there is only one place to write on it. How can i make it happen?
View 4 Replies
Sep 20, 2009
I know of the Shell method to run files, but how can I execute normal command prompt commands like nslookup, and capture the output as a string?
View 1 Replies
Jun 6, 2011
I trying to figure out how to execute commands stored in string, let's say i have string called "command" and a textbox, so i want vb to run command that i typed in textbox, e.g. i type in textbox "label1.text = "bla bla"", and then type like "msgbox.show". Is that even possible?
View 12 Replies
Feb 25, 2012
I'm evaluating the best approach to implement the following periodic task:
Get some users from SQL Server (2008) and then for each user enable licences in the Cloud (Office 365) using PowerShell.
My first thought was a console-based app in C# or VB.net but now that I realize that running a PS Script remotely using C# can be quite a challenge I'm starting to think in alternatives like perform all the stuff using PowerShell, I guess this is a better approach but I'd like to hear your thoughts on this.
View 2 Replies
Mar 2, 2010
I cant understand why this works (Start a service "test" on a remote computer):
Dim rCommand As String
rCommand = "c:pstoolspsservice \computer -u admin -p blabla start test"
Shell("cmd.exe /c" & rCommand)
[Code]....
The above code that doesnt work starts a virtual machine on VmWare Server. I have the exact same line in a .bat file and if i call the batfile from VB it starts the batfile and execute the commmand. I cant understand why this doesnt work without the batfil when i have no problem executing the PsTools command from VB-code.
View 2 Replies
Feb 2, 2010
i'm tring to execute some commands in cmd prompt in vs 2008. (with out using BATCH FILE)
[Code]...
View 4 Replies
Sep 1, 2009
How to execute the DB2 commands programatically for Backup..Here are the commands that need to be executed for DB2 Backup.I am using IBM.Data.DB2 namespace, And as soon as we connect to Dbase in step 2 it crashes to QUIESCE.
1.CONNECT TO <DataBase Name>
2.QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;The Exception Message I am getting [code]
3.CONNECT RESET;
4.BACKUP DATABASE <DataBase Name> TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING;
5.CONNECT TO <DataBase Name>;
6.UNQUIESCE DATABASE;
7.CONNECT RESET;
View 1 Replies
Oct 9, 2011
I need a coding to execute multiple at commands simultaneously. when first command execute and get the response from the port and then the second command will be executed. how to write the coding. it is possible. i am using siemens gsm modem.
[Code]...
when i execute this coding i can't get the correct result because the port response will take some times.how can i identify the time delay. when i use thread.sleep(300) means this is also not correct for my solution. Because the port response will take more than 300 milliseconds?
View 1 Replies
Nov 18, 2009
I need to start a "Run" window(The one that opens when you press Windows+R or Start->Run) and run few commands in it from a VB.NET program.
View 5 Replies
Sep 2, 2009
We have a VB6 program that uses an ADODB.Connection to establish a database connection and use its execute function to run SQL statements. The connection we have established is to a SQL Server. It has been working fine. Currently, I am trying to change the connection to a MySQL database. I changed the connection string and the connection is ok.
However, when it comes to running the execute function, it returns a runtime error 3246 - connection object cannot be explicitly closed while in a transaction.
I checked the connection.status before calling execute and found that it is open. When I use MySQL's server connections to check the status, I found that there was a connection before and after execute was called.
I encountered this same error whether I used MySQL ODBC 5.1 Driver or MySQL ODBC 3.51 Driver.
View 1 Replies
Sep 11, 2010
I am working on a "de-bugging" back-end sorta thingy for my program, and I have a "dll" that executes most of the work for the program. For the ease of tech-support, I plan on trying to impliment a hidden back-door into the engine that is password protected and activated by a key-press. What I want to do is:when the enter key is pressed, have the dll run the sub that is listed in the enter key, for example:
In the dll:
Public Sub msg(ByVal text as string)
MsgBox(text)
[code]....
View 2 Replies
Nov 22, 2010
Just trying to execute commands in cmd.exe just a simple Net Stop [service] and get a error 5. I want it to run cmd in administrator mode. One way I have seen that you can by holding down ctrl & shift while clicking cmd.exe?
View 26 Replies
Jan 26, 2012
I have 2 tables in MySQL database. These table were joined through a query and handled by a dataset. Im displaying these data through setting the dataset as the datasource of my datagridview. But when it comes to Update, Insert and Delete statements, I got an error because the sqlcommandbuilder does not generate statements in multiple tables.I want is, when I press the update button..all the changes made in the datagridview will be updated in the database. Can i make it without creating a datasource in design mode or through smart tag? If I have to manually create an UpdateCommand for adapters..Can I have a code snippet for that?
View 1 Replies
Apr 18, 2009
i am using ASP.NET with VB.NET to connect to a MS Access database. how can i make the sql statement to insert a new record into the existing table and join tables?
View 1 Replies
Aug 17, 2009
How can i execute my query to insert records in tables?[code]...
View 7 Replies
Jul 6, 2011
I was recently assigned to do some research on how to approach a project. Right now we have an old program written in tcl. From this tcl program ( running on VMS client computer), we are able to run unix commands to execute processes on a unix server. This is done via tcpip. Now, we are thinking of making upgrades to this system . We are wondering if this kind of thing was possible with Visual Basic. Are we able to run a VB program on windows computer to run UNIX commands on a server? If so, what issues might be brought up. If anyone has even the briefest guideline or tip on this,
View 3 Replies
Dec 13, 2011
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 Replies
Jul 27, 2009
I have two data tables within my data set that are loaded onto my form on form_load using statements written in code (not the designer. When I change a value for the first table via a text box the change is made to the data set. But when I try the same for the second table, the change doesn't remain in the data set when I switch to a different company and come back. I query the second table using the primary key of the first table but no code is needed when I change the values for the first table so I don't understand why the same doesn't work for the second when I change a value via a data-bound text box....
Here is my code that initially binds the data:
'This is used to read our data from the data base
Public Sub Read_Data_SQL()
Call Clear_Bindings()
[CODE]...
Here is the code I call when the selected index of my company combo box changes to have the second table reflect that of the first:
'This sub populates any information contained in the Contact2 table
Private Sub Update_Contact_2()
Dim Company As String = cmbCompany.Text.Replace("'", "''")
[CODE]...
View 1 Replies
Oct 11, 2009
Can someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
View 3 Replies
Mar 4, 2010
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Replies
Dec 29, 2009
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 Replies
Feb 5, 2012
I have a snippet how to kill multiple instances of one proccess
Dim pProcess() As Process = System.Diagnostics.Process.GetProcessesByName("notepad")
For Each p As Process In pProcess
p.Kill()
Next
If i want to kill multiple instances of "notepad","excel" and "word" how the code should look?
View 2 Replies