enter code hereI am attempting to call SQL stored procedure that does an INSERT. However, when I walkthrough my vb.net code, I get a message saying "Procedure or function sp_InsertARPlanner has too many arguments specified." I have double checked, but the SQL string in VB has the same # of params as in the stored procedure.
Update
SQLCmd.CommandText = "sp_InsertARPlanner"
SQLCmd.CommandType = CommandType.StoredProcedure
[code].....
I was wondering how do I add a command button called "Start without Debugging"? Is there such a thing in Visual Basic?
View 2 RepliesI'm having to write a reporting application that gets information from some Interbase servers and it also has to work on Vista as well as XP, I'm using to connect Borlands Data Provider.[code]My Issue is that debugging on my xp Machine the dataset gets filled, debugging on my vista box it fails ("Interbase provider initialization failed"), my initial thought was that this could be UAC related but I've compiled the application and 'ran as admin' and still same issue. (by the way it failes on the line Dim da as BdpDataAdapter...)
View 1 RepliesFirst let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
I am currently using psexec.exe from PsTools to send a command to a remote system to fire a command through a command prompt however I am finding that the shell I am doing does not seem to like the spaces in the path.
[Code]...
Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...
I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:
Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")
This process runs through analyzing, runs it in normal mode & prints the progress to the command window.
My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.
I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).
I can only access the external program thru the command line (its not my program) and I must do so from a form app.
I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.
Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"
[Code].....
I want to add a new select command to my dataset. To do that, I have added a new partial class to my project. Because we have to use partial class if we want to extend generated dataset codes. [code]...
View 3 RepliesI 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]...
User need to select their prefferable data to show in report. What i did is i have a clear command first to delete the temporary table. The temporary table is basically a table to stored user selection parameter data. After the clear command, i have
a insert command to insert user selection data into the temporary table. What happened now is when i run the program exe, first run of the report is work fined, but not the second and the following times of execution. It will return null or blank report. The weird thing is when i execute it from development environment, it seem like the report is able to pick up user selection parameter and run the report for the first times and the subsequent execution.
i have seen this in many codes, just not sure where to start and how to call the command. what i'm talking about is having code as such (this is for save file dialog):
[Code]...
In the Windows Shell, there is a command that looks like this: copy /b fileA.zip + fileB.jpg fileC.jpg..Is there any equivalent function in VB.NET? I already know this works: [code] But I would much rather have a built-in function to work with. Here is what I am trying to do: url...Also, this doesn't just work for pictures. It works for any binary file. Is there any way in VB.NET to tell if a file is binary or text?
View 3 RepliesIs there a way to hide the characters of a "set /p password=Enter Password:" command? Or any new strand not using the SET command i could use instead?
View 2 RepliesI am struggling to pass a parameter to a VB.NET application via a Windows scheduled task. It works perfectly in Visual Studio (passing a command line arguement via project properties).If I am calling a VB6 application, then I will supply the following parameters and it works:
Run: c:progra~1TestTest.exe TestParameter Start In: c:progra~1Test However, if I supply the same parameters in VB.NET, the program throws an exception when it tries to create an instance of a class in the Form.Load: System.NullReferenceException cannot create instance of object.
I have also tried the following:Run: c:program filesTestTest.exe TestParameter Start In: "c:program filesTest" This time the status of the scheduled task changes to "cannot start".What is the correct way to specify command line parameters in a scheduled task for a VB.NET program?UPDATE I found the solution on this web page:[URL}.. I am still confused as to why the program would not create an instance of an object when I used the 8 bit paths (i.e. progra~1)
I'm running into the following error message when I click the button event: Command text was not set for the command object. [code]
View 1 RepliesIf I comment out MdiUpdate() this run fine. When I run it with MdiUpdate I get the following Error...
da.Fill(ds,
"Mdi") Command text was not set for the command object.
I have also taken the code from the select statement and put it into the other 2 (replace the CliendGroupID = 3) and it works fine
Here is the code:
Public
Class NewFileInput
Dim inc As Integer
[code]....
I have beginner skills using VB (am using the Express edition to learn). I would like to know how to set up a conditional statement in a Windows Form (WF) app that would check if a specific command line has been passed by another separate app that launchesthe Windows Form app using command lines, and if not passed, then the Windows Form app would shut down (exit, close).So far, I can use:
For Each s As String In My.Application.CommandLineArgs
If s <> "xyz" Then
Me.Close()
[code]....
I have a vb.net web application in visual web developer 2008 with a dll file and i need to debug a method in that dll. I also have project source files for the dll file itself. How could i make the web application use the source instead of the dll file so that i'd be able to debug it? I've tried debugging the dll project itself, but it's not a very good solution, because it seems the dll depends on the web application settings and data and it would simply be too much work to get it working. T
View 1 RepliesI set a breakpoint in one of the class. while debugging my vb.net winform project, the breakpoint moving to the next line which dont have any code. I could not understand what was wrong? I cleaned up my solution and re-build my solution but could not resolve this issue.
View 1 RepliesI installed VS2008 ona newVista Ultimate 64 Bit machine. Works great. But if I try to change some VB2008 code while debugging, the system says, "Changes to 64 Bit applications are not allowed". Why is this? And will programming on a 64Bit machine always be hampered like this
View 4 RepliesAnyway to view the content of a dataset or datatable in debug? I don't mean looking up a specific element of the dataset but to view the hole thing.
View 4 RepliesSo I've got some code that I've written in C and compiled into a DLL. This code is called by my VB.NET code. That interface is working fine, but I need to debug some of the C code. But obviously since it's not in VB I can't use the Visual Studio debugger. I've tried attaching a GDB debugger to the process while it's running. It lets me set the breakpoints and it even stops at them, but it doesn't let me see the lines of code. My code was compiled with debug information, so I don't know why it won't let me see it.
View 3 Repliesi am facing a problem while debugging . I have put break points in some place to trace the code . But while pressing the F11 key and when it reach that function , a new window called disassemby is coming and showing something like this .
00000000 push ebp 00000001 mov ebp,esp 00000003 push edi 00000004 push esi 00000005 push ebx 00000006 sub esp,44h 00000009 xor eax,eax 0000000b mov dword ptr [ebp-10h],eax
[code]....
I want to step through VB.net 2008 project file. The code is executed from the postbuild command line. Thus this code is really executed during the build process.Thus, can you tell me when I can do to debug this VB.net 2008 program that is executed from the command line? All I know what to do is have the solution (ide) open, set breakpoints, set the project as the startup file, and run the debugger.
View 3 Repliesi have an VB.NET application with few functions i need to debug (like ie. Assert in C#). Is it possible and how i do that ?
Public Shared Function createNumberArrayList(ByVal startValue As Integer, _
ByVal endValue As Integer, _
Optional ByVal isBackwards As Boolean = False) As ArrayList
[Code].....
Basically what i need is to enter few values and see if the function works and returns proper ArrayList.
I have a problem that When I Install my project on another computer it gives me the following error, even work good on my own system.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
Exception Text
System.Runtime.InteropServices.COMException (0x80040112): Class is not licensed for use
at SMS_ANSI.Form1.Form1_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
[Code] .....
When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog.
Here is my project: [URL]
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('1302a0f0e63d492f8ec0bef756e8246b')
I've programmed in C# for the majority of my .NET career - now I'm working on a VB.net project - when debugging it drives me insane the differences of how the debugging works.two off the top of my head are
1) having to prefix my immediate window queries with ?
2) not being able to mouse over a GUID, I have to ?myGuid.ToString() to actually see the value is there a way I can make it behave like C#?
I have many forms included in one project , now I am working on one form, but I want to run it directly for testing
for example, i have a project called Main with buttons that should open form1, form2, form3 I want to run form 2 independently without running the whole project
