WHILE LOOP Displaying Wrong Result When Counter Is Incremented?
Feb 23, 2011
Im writing a program and its pulling data from a .MDB to put in a .DAT file.
Here is my while loop:
vb
database_connection()
sql = "SELECT * FROM tlalist"
[Code].....
In my database there are currently 6 rows. and only 1 row has the TLA_DAY column equal to 1, but for some reason when I look at the .DAT file it creates it outputs the result twice rather than only once.
Once JTLA_count increments it becomes "2", but the while loop still outputs as if its still equal to "1". Ive used breakpoints and the counter is incrementing fine.
View 3 Replies
ADVERTISEMENT
Jul 21, 2011
I have a function in VB.NET that loops through values and attempts to convert it to a decimal if IsNumeric is True,
Dim Value As String
If IsNumeric(Value) = True Then
Rate = CType(Value, Decimal) <--- bombing here
End If
I've found that when the function receives the value 603E43 IsNumeric evaluates to True for some reason and then bombs on the conversion. Why would IsNumeric be true in this case?
View 1 Replies
Jul 24, 2009
I have the following...
Dim a as long
Dim b as long
Dim c as long
[code].....
The result is different comparing i calculate it using a calculator or Excel....I tried setting variables type of Integer the result is still wrong....
View 4 Replies
Dec 12, 2009
I'm attempting the following code to calculate how many quarters, dimes, nickels and pennies a user should get as change, and display them in four labels, when buying an item from a machine. The user inserts the amount paid and the cost of the item in two textboxes.My code is as follows:
Code:
Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click
[code].....
View 6 Replies
Mar 19, 2009
i wanted to know how to create a for...loop...and specify the counter for the loop to control the animation time. I want the for..loop to increase the speed of the moving object (button) and move it 5 times...
the code i started with is
Private Sub ForNextButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles xForNextButton.Click
For Counter = 0 To 1000
'do somtething----the something i want to do is repeat the moving process 4 times and at a fast speed---how do i write that
Next
[code]....
View 15 Replies
Dec 17, 2008
Anyone else have an issue using read, It appears when I use read it gives me the correct buys but returns the wrong integer value So I use it and it fills the Array i make with &h10, &h6 but read reutnrs number of bytes returned to 1. if there a better way to go with Vb.net with RS232 I mean really my projet dosent have anything out of the Normal
Friend WithEvents CashValidator As System.IO.Ports.SerialPort = New System.IO.Ports.SerialPort("COM1", 9600, IO.Ports.Parity.Even, 8, IO.Ports.StopBits.One)
CashValidator.Read(MyResponce, MyResponceLen, 4)
View 2 Replies
Aug 24, 2010
I'm trying to include a user control in an aspx page, it works fine, but my control does position itself where I want it and always appears at the very top of the page. Could it have something to do with the masterpage? I've tried registering the user control in the master page, but I don't know how to reference it in the content page.[code]
View 1 Replies
May 3, 2010
I have written a function that gets the alexa ranking of a given url, now this function works perfectly but I want to loop through a ListView of urls and grab the alexa rank of each item (url) with my function.The code works great if I put a MessageBox in the loop to test that the function is returning a value but when I remove the MessageBox the loop does not work.I need it to loop through adding each result without a MessageBox stop in each loop.
vb
For Each Item In ListView1.Items
Dim result As Integer
result = GetAlexaRank(Item.Text)
[code].....
View 12 Replies
Jun 6, 2009
I have a sub which requires multiple counter variables. Is there a more efficient way of doing this. My example is simple. Image if I had 20 separate counters I was trying to manage. I would have to create 20 separate variables and then increment each in the desired place in the code.
Dim Counter1 as Double
Dim Counter2 as Double
Dim Counter3 as Double
[Code].....
View 7 Replies
Jun 5, 2012
I'm trying to load a file where this file has, like, 10 lines. And I want to load each line (0 to 9) to each TextBox in my app (TextBox1 until TextBox10). So, there's a way to do this with a counter?
Like this mine code (that doesn't works):
If (System.IO.File.Exists("configs.ini")) Then
Dim configs As String() = System.IO.File.ReadAllText("configs.ini").Split(vbNewLine)
Const Max As Integer = 9
Dim TextBoxes(Max) As TextBox
For i = 0 To Max
TextBoxes(i + 1).Text = configs(i)
Next
End If
View 4 Replies
Feb 23, 2010
I have a for loop which goes like this -
for i = 0 as integer to 100
result &= "Name" & sqldr("name")
result &= "Lastname" & sqldr("lastname")
result &= "dob" & sqldr("dob")
next
The sqldr is the sql datareader (not important here)
I want my end result to be
Name1 = Sam
Lastname1 = Davis
dob1 = 01/01/1966
Name2 =
...
Name3 =
And so on depending on how manyrecords are in database. How do I make this happen in this for loop?
View 3 Replies
Nov 26, 2011
The program is to take an entered string then search for a subset of letters entered through and input box.In my subprocedure Sub btnSearch_Click I am using a loop to move through the entire length of an entered string to search for a set of letters entered through an input box. I can find the set of letters to search for but instead of increasing my counter "Found" for every instance of a match it returns the length of the string instead. I just don't know why the IF doesn't prevent the counter from increasing for every element in the string. I want the counter to increase only when the match is found. I just put 2 message boxes in there to make sure it found the right letter and then display the counter.
Here's the entire
' Name: Count Project
' Purpose: Displays the number of times a sequence of characters
' appears in a string.
[code]....
View 5 Replies
Jun 18, 2009
I want to write an Excel macro to set print formats in all worksheets in a workbook. I don't think you can do this by grouping; it appears you have to do it in each individual worksheet. I want to be able to run a macro in any workbook to loop through all worksheets in the workbook and then select the first worksheet.
How do you have the macro determine how many worksheets there are and set the loop counter equal to that number?
View 5 Replies
Jan 11, 2010
We have a project that needs to gather survey data. On one particular page of the website, there are 21 questions each with a scale of 1-5 where the user selects one radio button for each question in the table. The survey is being coded in VB.NET. The data submits to an SQL database. All the radio buttons are similarly named, so only the number changes for the question [Code]
View 2 Replies
Apr 13, 2011
I am trying to print out a triangle of stars with the longest side on the top. I have tried adding removing step, changing value of step, changing order of 5 to 1, 1 to 5 but I can't get it to reverse. I thought that is what step does? [code]
View 9 Replies
Apr 13, 2011
I hav copied my whole cde in form 1 to give a better insight of my question.what I want is to search for a string example title of a song then display my result to a richtextbox but the result should include the title the location and number.[code]
View 2 Replies
Oct 3, 2011
I created a small databse program, when I created the search field I wanted to display the results in "listbox" which I found some code that work perfectly
For each row in ds.tables("Tablename").rows
me.listbox1.items.add(row(1).tostring())
Next
but I also need to display "row 2" ACCORDING to the selected item from listbox in a textbox.
since the listbox is displaying the result of a search, it's been hard to find, how to do this?
View 7 Replies
Mar 23, 2010
I am currently writing a code that prompts a user if they want to convert F to C or C to F, two functions with the calculations. My problem is my loop, it exits one time through and doesn't prompt again. And also doesn't display the final result.
' VB Script Document
option explicit
const menuBar = "Temperature Conversion"
Dim userPrompt, prompt, Temperature, toCelcius, toFahrenheit
prompt = vbOk
Do While prompt <> ""
[Code] .....
View 2 Replies
Jun 2, 2009
I am building a scientific calculator.
1. After I clicked the Sine button, I get the result in a textbox.. When the result is there, for example: 1 radians Sine = 0.8414.... I can still put numbers at the end of this result.. like button 5 will be 0.84145, so how can I disable that?
2. After I get the result from a calculation, the textbox should be cleared when I insert a new number.
View 7 Replies
Jun 10, 2011
using a for loop i want to be able to pause it, display string in text box for 60 secondsthen move to the next loop,change content of the string and display it again for 60 econds.this should go on till end of count.i am currently using a timer in do while loop to pause, but instead of displaying the string contents in each loop,it adds up all contents in all the loops and displays them at the end of count,not what i want. i tried using 'sleep'funtion but its behaving the same.below is the code:
For i = 1 To count Step 3
'empty string
disall = ""
[code]......
View 1 Replies
May 12, 2012
I want to ask about looping
if i have big looping, and i want to print it result real time, how can i do it?(it look like when we scanning with antivirus, then the label that contain location that scanning change real time)[code]...
View 4 Replies
Dec 16, 2011
I have a MySQL database with a table called "Locations" which looks a bit like this
id | name | other parameters
1 | shop1 | blah
2 | shop2 | blah
[Code]....
This works, but it is inefficient calling the database through the loop, how do I avoid this?
View 6 Replies
Apr 29, 2012
I am trying to display payment details for each loan, but I am having problems displaying on the form.
Public Class MortgageDetailsCalculatorForm
Private Sub CalculateButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CalculateButton.Click
[Code]......
View 2 Replies
Dec 10, 2010
i have a loop that does a simple math function and i need all the values to show up in a single message box. I've got it to when i get individual values minus the start value to show up in separate message boxes but i cant figure out how to consolidate can someone ?
View 1 Replies
Jun 20, 2012
I'm having a serious brain fart over this but I need a looping statement that will display all prime number from 6 to 10000.
View 3 Replies
Jan 12, 2010
I've got a DataGridview I want to remove columns from as it greatly increases performance when I format the DGV. The first time I remove columns in a loop (using the removeat) property, everythings fine. But when I try to remove more columns in another loop, it appears to remove the wrong columns and displays the wrong data. In other words, it displays the wrong data and headers; and the columns it does show has headers and cells that don't match.
[Code]...
View 2 Replies
Aug 27, 2009
I have a listbox displaying sql results in a loop. Let's say I want to select one of those results and click a delete button. I have the button and box setup displaying the results just fine, I just do not have the functionality. How would I do that?
View 18 Replies
Aug 13, 2010
I'm trying to lern VS 2010 from VB 6 and one of the things i'm hawing a problem whid is control array.In vb 6 if you create a text box it's named "Text1" and if you yust copy it and paste it it renames to "Text1(0)" and the new one's name is "Text1(0)" and the code would lock like this
[code]...
then it would print for each loop the random result in one of the text boxes corresponding to i.
How do i do this in VS 2010?
View 39 Replies
May 20, 2010
I have this code sample from a book I'm reading which looks to be incorrect:
Imports System.Diagnostics
Sub Main
Dim pc As New PerformanceCounter("PerfApp", "Clicks", False) 'excepiton here
pc.Increment()
counterLabel.Content = pc.NextValue().ToString()
End Sub
There excepion message I get is: The requested Performance Counter is not a custom counter, it has to be initialized as ReadOnly. I looked for a property to see if I can set it but couldn't find one.
View 3 Replies
Jun 13, 2011
know the title seems a little bit confusing, let me explain.Let say i have 10 properties of bindingsource.The names are: bindingsource1, bindingsource2, bindingsource3, ....., bindingsource10i want to develop a code using loop for these properties..
For i = 1 to 10
//bla bla bla
Next i
[code].....
View 3 Replies
