i trying to insert into database everytime a loop complete. but there is a syntax error saying "Incorrect syntax near '1'" at myCommand.ExecuteNonQuery(). here is my code and i really don't where went wrong. expert,
[Code]...
I 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]...
I'm foolin round with stream reader/writer and I'm running into this problem: If I have my if/then statement inside my loop I get a million msgboxes(which I understand why), however if I put it outside my loop, and the if/then returns a false then the whole program freezes up. I can't move my mouse around, I can't click on any objects, ect. Here is what I'm using:
[Code]...
The command to a string to another inside lable text box
View 6 RepliesIs it safe to place the code of INSERT Sql command inside my While End While
[code]...
Im having a problem with a loop inside a C++ dll being called from VB. I want this loop to update a global variable, but when I call the function the variable does not update the first time round, but does so every subsequent time.
This is how I am trying to update the variable.
else
{
::nScore = nHighest;
[Code].....
As a workaroud I am forcing the variable to be what I want in the VB code
How do I get the position of the XML element in this loop?
For Each objNode In objDoc.SelectNodes("//books/book")Next
What I want in output would be something like
Is it possible to change many labels inside a for loop? Let's say I have labels 1 to 4. Can I do something like:
for i = 1 to 4
label%i.text = some text
next
I am having trouble using FOR loop with array in query.What I am trying to do is for all the data pulled out of database I convert it to an array list and then string (this works fine). After that I am trying to make a FOR loop query for each of the data pulled out and this is where i am having trouble.
[Code]...
I am writing a program and i need to declare matrices but there will be a different number to declare everytime the program is run so I was wondering if anyone knew how to declare them inside a for loop
eg.
For i = 1 to NumberOfMatrices
Dim matrix i (5,5) As Double
Next
Using VB.NET .NetFramwork 3.5. This fails and strikes me as odd. Is this correct behavior:
Public Sub TestForEach()
For index As Integer = 1 To 10
Dim z As Integer
Assert.AreEqual(0, z)
z = index
Next
End Sub
I would expect z to always equal 0 as I thought the dim-ing of an integer would set the value to 0. If you run this. It fails at the second loop. For some reason z retains it's value of 1. I know I can manually initialize z to = 0, but I wanted to know if this is a bug or expected behavior.
I would like to be able to stop a loop while executing using the ESC key.I've found a lot about using the above key from within a Form (for example, to unload it), but very little for the use of the key within a Procedure (Sub, Function) and particularly with respect of preventing a loop from carrying on execution.
View 3 RepliesFor i As Integer = 1 To 10
Dim j As Integer = 10
Next
now my question is, Is memory allocated to j every time its executed inside for loop? or only value of 10 is assigned on subsequent iterations?
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim s As New Staff
[Code]....
Basically I am trying to update each record with 2 random numbers each time the button was clicked,my problem now is, the system will update the record but the data was wrong. Example, by right all data should be different (randomly string) but for some row it was updated with same data but in randomly, something row1 row2 row3 has exactly same data for column 1 and 2 then row 3 has distinct data, second time, row1 row2 same data row3 ro4 with different data. It is in random sequence. When I add a MsgBox to do testing in the For loop the data was updated correctly with all different data.
For my own basic understanding ... what is the difference between these two snippets?
Dim y As Integer
For x As Integer = 1 To 100
y = x
[code].....
May i know how to insert a AT command method inside my program to receive incoming sms?
My program is in visual basic windows form 2005.
Here is how my program goes.
After i click connect button in my application, the gsm modem will automatically read the incoming sms and display in the textbox on the program.
I already have the list of AT commands to be used, they are :
1. AT
2.AT+CMGF=1
3.AT+CMGL="ALL"
I also would like to know how to declare these commands as string inside the program.
Here is my program so far:
CODE;
This code is for the user to click on connect button which will connect to the serial port. So after connecting the modem will then auto read and display new incoming sms.
Is there a way in VB to make something that will simulate an advanced command prompt inside of a Windows Form? For example, something like a greenscreen app?
View 1 RepliesBasically, I am looking to create a program with the CMD (command prompt) window inside of it.Along with a drop-down list, containing a few pre-made codes.For example;Is the easiest way to kinda accurately show what i'm attempting.Cross-thread operation not valid: Control 'txtResults' accessed from a thread other than the thread it was created on.
View 2 RepliesI have some variables that are distinct by numbers, like in1, in2...If I have for loop, how would I access those variables, using the counter, and attaching it to the variable?I believe in JAVA, you could just use in+ct... where ct is the counter to access the variable.also how could you make a new variable in the for loop?Initially I had variables declare outside of the for loop. The problem was how to access those variables using the for loop.
var_nm1 = in1.Text
var_nm2 = in2.Text
var_nm3 = in3.Text
Dim nmList(2) As Integer
[code]....
This is object oriented programming, and I made the textboxes in1, in2, and in3 using the GUI editor. that was so easy.
I would like to show that the computer is busy and not frozen during a long file transmitted over Serial Port.I have the following loop.The intention was to show one "*" for every line sent.
While (fs.EndOfStream = False)
lineRead = (fs.ReadLine)
TextBox1.Text = "* "
SerialPort1.Write(lineRead)
End While
I can see the data sent on the Scope but the chain of "******...." show up after the transmission ends.The WHILE LOOP is actually working but the TextBox1.Text = "*" is not writing to screen.I would like to see the train of ******** same time as the transmission is active.The * is to show that the computer is busy and not frozen.Writing a copy of the actual serial data transmitted to screen is also another option that I can use.
how to wait for a second inside a loop?
This is what I tried (including everything else in my form):
Public Class test5
Public z As Integer
Private Sub test5_GotFocus1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.GotFocus
[Code]....
I have several textboxes in a winform, some of them are inside a groupbox. I tried to loop over all textboxes in my form:
For Each c As Control In Me.Controls
If c.GetType Is GetType(TextBox) Then
' Do something
[code].....
I have an FTP connection with around 50 folders in it, I have one file that I need to upload to all of these folders, how can I get the list of these folders in there so I can go ahead and upload the file automatically? The folder # keeps increasing and I can't manually keep uploading the file to each folder.
View 2 RepliesIm using Vb.net visual studio 2008. i have got a process(system.diagnostics.process) to be run in background and it updates the Ui thread progressbar and a label and i have worked it using backgroundworker.runworkerAsync. Now the problem is i have to work the same process for a number of time with different inputs.
The code block is :
Private Sub fnStartEvent(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnStart.click
Dim inputFolder = Directory.GetFiles(textboxSourceFolder.text)
Dim currentNumberOfFile As Integer=1
[code]....
The problem in here is the fnStartEvent method once gets started, it calls BackgroundWorker1.runWorkerAsync process and that runs in a seperate thread and does not wait for the thread to complete and it moves to the next line of code i.e loops to the next item and it returns to same BackgroundWorker1.runWorkerAsync line and throws exception that it is already running.
Tried
1.
Private Sub fnStartEvent(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnStart.click
Dim inputFolder = Directory.GetFiles(textboxSourceFolder.text)
Dim currentNumberOfFile As Integer=1
[code]....
But this does not updates the Ui thread used to denote progress.
2.Put the whole process inside the DoWork thread and loop for each file in there itself, but that to returns the cross thread error in progress bar updation.what is the standard procedure in executing a loop for the backgroundworker to wait for finishing as well as update the UI without blocking it.
How do I save the information from each activation of the code inside the loop. I decided to try this a different way. I also need to know how to create colums in a label?
For countInteger As Integer = 0 To 3
seatsSoldInteger = ticketDetail(countInteger).seatsSoldInteger
costDecimal = ticketDetail(countInteger).costDecimal
totalTicketSalesDecimal = ticketDetail(countInteger).totalCostDecimal
[code].....
Dim tbox As Control
Dim oWrite As System.IO.StreamWriter
oWrite = IO.File.CreateText("c:Template.BBT")
[code]......
if I have the following vb code,
for i = 0 to dTable.Rows(i).Count -1
Dim sql As String = ""
Dim strConn As String = ConnString
[Code]....
I need to loop inside listview and its columns Sub Items. I'm currently using this.
For Each item As ListViewItem In ListView1.Items
For Each si As ListViewItem.ListViewSubItem In item.SubItems
Next
Next
But it over loops on the items causing the code to produce incorrect tasks.
I have a backgroundworker that is downloading data from different webpages and process them to a datagridview.I get the Cross-thread operation not valid error on the first For loop.
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
dim i as integer
tot = (numPostnrTo.Value - numPostnrFrom.Value) / 10
[code]....
I have this code the exports datagridview from vb.net to ms excel, There should be a total at the end of the table in the ms excel after exporting it but my problem is I can't merge the cells for "Total".
View 2 Replies