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 Repliescatch 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].....
I need to execute AS/400 System Commands thru VB. What would be the way to perform this?
View 4 RepliesI 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 RepliesI 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 RepliesI 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 RepliesI'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.
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.
i'm tring to execute some commands in cmd prompt in vs 2008. (with out using BATCH FILE)
[Code]...
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;
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?
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 RepliesI 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]....
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 RepliesJust 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 RepliesI've added few stored procedures to my SQL Server 2005 database. Few of them were a procedures containing SELECT statements and one of them contains INSERT statement. While executing the procedures with select statements are as easy as displying tables, the procedure with INSERT statement is not so easy [for me].At first, i've tried to add the procedure to the dataset and execute it as others, by filling the table adapter. But... there is now way to access the tableadapter within the code... VB does not recognise it! Just like it wasn't there! It's not even listed on with the other tableadapters below my project. It's viible only in the dataset!After few minutes i've removed the procedure from the dataset and tried to add it as a query. Everything seemed to be ok... but... after naming a function, that would execute the query.... the function is visible nowhere. I can't execute it within the code.
View 3 RepliesI was wondering if there is anyway you could go about executing what's stored in a variable....kinda like in an #Eval statement....
E.g.
dim i as integer
dim PlaceHolder as String
for i = 1 to 10
[Code].....
I have a stored procedure that clears student accounts to showed that they have paid their bills. I am trying to create a form in vb.net that allows them to enter a parameter and then execute the stored procedure.
View 9 RepliesI have a form that requires me to execute several stored procedures one after the other. I'm wondering how to do that in vb.net. I realize that I could just have one stored procedure with all of my queries in it, but for clarities sake, I want to keep them seperate.
View 14 RepliesI have the following code:
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Main.payrollButton.Enabled = True
[Code]....
and I'm trying to execute several stored procedures and it doesnt seem that it is.
On my final form that this connects to, I'm trying to fill data that is summed by these stored procedures and I'm getting the error of :
'The SelectCommand property has not been initialized before calling 'Fill' ... which I'm told is because there is no data in my query.
We are working on a VB.Net project to execute a SQL Stored Procedure and passing it parameters. We have the execution up and working as expected, however the application will only successfully execute once. On the second execution,[code]...
View 3 RepliesThis is a bit old-contents to be discussed but I need someone who can explain me how to create stored procedure in SQL Server for returning a value from procedure, example:[code]Then I need the name of its customer and the address instead.I need to make it as a stored procedure and show me how to execute it on VB.NET. Perhaps we assume that the name will be prompted to LABEL1.TEXT and the address will be prompted to LABEL2.TEXT. I've improved this SQL-Server Stored Procedure Using return but I have nothing to return after I execute it.[code]
View 1 RepliesI've created a simple parameterless stored procedure which I've pasted below. I've imported the stored procedure to my Entity Model and created a Function Import. The function in the model is never created and I am unable to execute this stored procedure using the ADO.NET Entity Framework. I've opened the .edmx file in XML view and have confirmed there are no errors regarding this stored procedure. What am I doing wrong? Is it really impossible to call such a simple stored procedure from the Entity Framework? I've set the return type for the import function to None seeing this stored procedure does not need to return any recordsets or values.
Stored Procedure:
ALTER PROC [dbo].[Inventory_Snapshot_Create]
AS
SET NOCOUNT ON
DECLARE @Inventory_Snapshot_ID int
[Code]...
How can I execute a stored procedure using sqldatasource and get the return value in vb.net.
View 2 RepliesIn vb.net is it possible to execute a sp for a dataset (datatable) ?
If no is there any alternative to do this as when I execute a sp from database it gives data saved in my db but if I am working on local dataset how to get updated data from same sp without saving to sql db first
I have code that runs a deal.deal is a series of conditional steps [e.g., pay Fee1 from Account2 if (Variable5 > 500, Variable5 / 2, 0)].
These conditional steps are stored as strings in an access database.The conditional part can be extremely complex.
What is the best way to get my code to understand the conditional part?Do have to write some huge parser?
Is there a function that can do this for me(something similar to application.evaluation function in VBA)?Or do I need to approach this in an entirely different way?
In my VB.NET code I construct a ODBC.COMMAND to call a stored procedure that eliminates a record from table in SQLSERVER 2008, I use this code in a FOR NEXT loop, it may contain 1 to 20 records_ID to pass to stored procedures to delete the records.
This code work well for several months, but since the last compilation it only deletes the first 2 records.
In debug mode in VS 2008 IDE works fine.
VB.NET CODE
''' <summary>
''' DELETE CANCELED CUSTOMER ORDERS
''' </summary>
[Code]....
i'm trying to execute a SQL stored procedure with a parameter that needs the SQL datetime format as:
Dim str_runproc As String
str_runproc = "exec UP_stopactivity @Activity='" & DGV_currentactivities.CurrentRow.Cells(0).Value & "' ,@Client='" & DGV_currentactivities.CurrentRow.Cells(2).Value & "',@starttime='" &
DGV_currentactivities.CurrentRow.Cells(3).Value & "'"
the DGV_currentactivities.CurrentRow.Cells(3).value is a datetime value that is put into a Datagridview via another stored procedure. When I run it in sql, it lists as a correct SQL datetime: 2011-04-27 05:54:51.003, in the datagridview it lists as: 27/04/2011 5:54:51
I have some VB code like
Dim data As DataTable = DataAccess.ExecuteDataSet("AuthenticateWebServiceClient" _
, New SqlParameter("@ClientID", ClientId) _
, New SqlParameter("@Password", Password) _[code]....
Except PrepareSPCommand isn't recognized by VS. Does anyone know the correct way to convert this function to C#.
In VB.NET, how do I do the following?
Execute a Stored Procedure
Read through the DataTable returned