Use Parameters "@" In An SQL Command In Program?
Jun 21, 2012I have this code to update my SQL database from data in a textbox, in VB. I need to use parameters in case the text contains a tic mark ,', or a quote ,", etc.[code]...
View 2 Replies
ADVERTISEMENT
Command Line (console) Program With Parameters For SharePoint?
Oct 29, 2009I would like to create a console program in VB.net that would allow parameters. What i would like to do is in the code below add parameters so the webpart page can be created from the Run menu. e.g. C:.......MyProgram.exe "Design" --This would then create the Design webpart page.
I tried looking at the internet but was not very successfull.
Module Main
Public Sub Main(ByVal args As String())
Dim prj As String
[Code].....
Adding Parameters To Sql Command?
Dec 1, 2009I am running visual basic 2008 express. When I run the code that I have written it gives me the the following error message
- Incorrect syntax near '?'.
Does anyone know what causes this error. My code is as follows -
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
[Codee].....
SQL Command Object Parameters?
Feb 10, 2010I have been working on this all day and still haven't had any luck at getting it to work. I am using the SqlDataReader Object to retrieve data. I am using the code below to send a value to the stored procedure.The problem is that the value is sent enclosed in quotes so I dont get any data back. I have tried using .text.replace("""","")
View 9 RepliesCreated Checkboxes To Add Parameters To Command
Oct 16, 2009i am running a dos command. now i created checkboxes to add parameters to the command. [code] but it only gives me a 1 or 0 but i want the parameter -h, -t, -v when the checkbox is checeked.
View 10 RepliesSplitting Command Line Parameters?
Apr 7, 2011I am passing some comma separated parameters to console Application. I want to split those string for that I have written below script but it is giving error .
static void Main(string[] args)
{
Console.WriteLine("Command Parameters :" + Environment.CommandLine);
[code].....
Syntax For Shell Command With Parameters?
Sep 9, 2009I am trying to setup a variable in VB, which will execute a shell command (autostatus.exe) with a parameter (-j JobName), and later display the output of the said variable. The code thus far is...
Dim JobName
Dim JobStatus
JobName = "asysr11_set_global_var_2day"
JobStatus = ShellExecute("autostatus.exe", -j, JobName)
What is the easiest way to achieve this? Currently, the above code returns error message "line:4, Type mismatch: 'ShellExecute', code: 800A000D"
VS 2008 How To Set Two Command Line Parameters
Dec 23, 2009as i need add the two commandline parameter on debug window.
/url=
one is okay
[code].....
Command Parameters Procedure Or Function Has Too Many Arguments Specified
Nov 4, 2009I don't know where the extra character 'N' is coming from, there should only be one parameter coming from my SP which is the ID:
cmd1 = oStringConnection.SetCommand(sqlConnectMain, _
cmd1, "TestStoredProc", _
DBConnections.myType.cmdAsProc)
[code]....
When I ran the SQL Profiler, I found this:
exec TestStoredProc @StudentID=N'12345'
Pass Command Line Parameters Through The Executable
Mar 5, 2009I'm currently creating a new process and then executing an executable from a specified location:
[Code]...
Setting Parameters Of Command Object Seems To Fail?
Nov 3, 2011I use the following VB code to execute a scalar function on my sql server:
cmd.CommandText = "[STFRA].[dbo].MyScalarFunc"
cmd.Parameters.Add("@Fastener", SqlDbType.Int)
cmd.Parameters("@Fastener").Value = 4148
[code].....
VS 2005 Data Class And Command Parameters
Mar 2, 2012I'm rewriting a small application and I'm working on moving the data access logic from the form to a separate class. All was working will when I had all the code in the form. Lets say I had code similar to this in my form:
[Code]...
VS 2008 Giving Parameters On Startup In Command Prompt?
Mar 18, 2009I need to give an app 2 string values on startup via the command prompt like this
C:myapp.exe string1 string2
How do I accept these values?
VS 2010 Sending Arguments/parameters To Command Button?
Dec 8, 2009how to send a procedure call to a Command Button.
What I would like to do is have one button be able to call any number of other sub routines when needed. In other words...the app is running and I need it to stop so the user can either read information presented...or make choices...then click the CONTINUE button to pick up where the app left off. However, I need this to happen many times across several forms and modules.
I know I can use a MessageBox and get the same effect..
Command Parameters Not Working When Calling A Stored Data Procedure?
Sep 28, 2010I have a stored Procedure
CREATE PROCEDURE sp_DescriptionLookup
-- Add the parameters for the stored procedure here
@manfactureid as int
[Code].....
DB/Reporting :: .Net/Oracle Application Best Design When Building Sql Command Parameters
Oct 2, 2009Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
VS 2005 : Passing Command Parameters To A Data Access Class?
Mar 31, 2011I've got a program where the insert/update SQL was created with the values coded directly into the SQL string. I've changed this to use the Command's Parameters.AddWithValue method and all worked well. I'm now in the process of separating the data access code out into it's own class. I've got the Select code working using a DataSet in the form that I pass ByRef to my data class so it can populate or refresh it. My sticking point is in how to pass the parameters for the Insert/Update commands to the class since from the form I no longer have access to a Command object. Do I need to make the Command object in the data access class available to the form?
View 6 RepliesVS 2005 Execute A Command Line EXE (busobj.exe) With Required Parameters Through .Net?
Jul 3, 2009I am trying to execute a command line EXE (busobj.exe) with required parameters through VB.Net. Because of unknown reason the report is not being generated. Here's the commandline:
Shell(txtBOExecutable.Text & _
" -user " & txtUserName.Text & _
" -pass " & txtPassword.Text & _
" -system " & txtDomain.Text & _
[code].....
Command Line Program To End Before Moving Onto The Next Command In Loop?
Feb 4, 2011I am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.
1) I would like to have a button that can Pause/Restart the Loop.
2) I would like to have a button that can Stop the Loop so the whole process can end.
3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.
4) I would like to display a Message once all the files have been processed.
5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.
6) And the ability to add some error handling if possible.
Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.
[Code]...
Command Line Strings - Make The Program Close If The -1 String Is Sent With The Program
Feb 25, 2010If e.CommandLine.Count > 0 Then
Dim IncomingCommand As String = e.CommandLine.Item(0).ToString
If IncomingCommand.Substring(0, 2) = "-1" Then
form1.close()
End If
End If
I am trying to make the program close if the -1 string is sent with the program. See my installer allows for me to run certain programs before it actually installs, but it doesn't shut down copies of the program itself. So I have a next startup instance set to shut the program down if the -1 is received. But if the program is not running it starts up instead. This is not desired. form1.close doesn't work. e.cancel = true doesn't work, etc etc. What can I do to make the program not start during this instance.
Convert Old GW-BASIC Program To A Command Line Program With Arguments?
Mar 1, 2012This is going to be a lot to ask, but I'd like to convert my old GW-BASIC program to a command line program with arguments. I'd like it to operate as follows:
elapse [drive:][path]filename This is my old code.
5 CLS
10 OPEN "G:Calc.txt" FOR INPUT AS #1
20 WHILE NOT EOF(1): INPUT #1, A$, B$
30 IF MID$(A$,3,1)=":" THEN C$="DOUBLE DIGIT":GOTO 50
40 IF MID$(A$,2,1)=":" THEN C$="SINGLE DIGIT":GOTO 120
[Code]...
Access Query With Parameters In Program?
Sep 3, 2010Microsoft Access queries with somecolumnname = [?] do not show up in the list of Views in the New DataSource Wizard in Visual Studio.
The query works perfectly from within Microsoft Access by just prompting for the values of the parameters.
The columns of the query should populate labels on my form based on the values in a couple textboxes.
What is the "best-practices" way to use parameter queries in my .NET application?
Use Interfaces As Method Parameters In C# Or Program?
Feb 1, 2012How to pass a object that is initialized from a derived class to a method that has Interface as the parameter?[code]...
View 1 RepliesVS 2008 - Create A Program That We Like With Certain Parameters?
Apr 26, 2012we are suposed to create a program that we like with certain peramiters, I have done as much however I have an error and I can not find a solution anywhere. We are, before you ask, able to seek help on this matter. Here is what I have:
[code]...
Parameters - User Login Before Program Loads
Nov 30, 2010I am writing a program where the user has to log in before the program loads. Right now I have all the users and passwords hard coded into the program. Recently I have written a Oracle function that the username and password is sent to the DB and a yes or no is sent back after comparing the passwords. I am getting the correct response back and it will display in a label (I tried it to make sure the response is correct). The problem I am having is that the program after receiving the response doesn't recognize the response so I always get an incorrect password error.
Below is my code:
empName = tbxUser.Text
passWord = tbxPassword.Text
dbConn.ConnectionString =
"Data Source=!!!!; User Id=!!!!; Password=!!!!"
[Code] .....
Stopwatch And Monitors - Defining Program Parameters
Aug 13, 2011If at all possible, how can my app detect the number, physical location, and size/resolution of monitors in use so as to define the program's parameters? Secondly, I have created a stopwatch variable ("Count"). I can't seem to get it to function properly unless using full seconds. In the following code, I have tried to use a fraction of a second (like .5) and using "count.elapsed.milliseconds = 500" and the program doesn't act like the code is even there...
Code:
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
If count.Elapsed.Seconds = 1 Then
Run()
End If
End Sub
Pass Parameters Back And Forth Between A Windows Service And .NET Program?
Aug 29, 2011Can I pass parameters back and forth between a Windows Service and .NET program? For ex: I want to pass a compressed/encrypted byte paramater to the Windows Service, who then decompress/decrypt it and return back the decompressed/decrypted bytes.
View 1 RepliesPassing Parameters To A Flash Movie Inserted In A VB Program?
Mar 15, 2010I need to insert a Flash movie in a Visual Basic 2008 express form and send parameters to the movie. The flash movie will plot points sent by VB in a graph.
I tried to insert the Shockwave Flash control in the form but cannot find it anywhere. So I inserted the webbrowser control, which I understand can be used to a similar purpose. But how would I send the values of X and Y (coordinates to plot in Flash) to the flash swf?
Use DOS Command In Program?
Jul 10, 2011I want to run this "rar a -rr10 -s c:ackup.rar c:file.txt" DOS command in vb.net, my main problem is that i want to compress file in Winrar software using vb.net coding. a button is press in window form that compress the file.
This "rar a -rr10 -s c:ackup.rar c:file.txt" DOS command compress the file.txt to backup.rar
C# - Search For Names In The Database That Matches Whole Parameters Or Any Part Of Parameters
May 13, 2011I'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....