Change The Exit Statement To A Continue Statement?
Feb 23, 2009
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
View 3 Replies
ADVERTISEMENT
Mar 11, 2010
I would like to terminate a do until ....loop when future value is greater than 1000 without using a Exit or Continue statement.
Do Until inti > intMonths
decFutureValue = (decFutureValue + decMonthlyInvestment) * (1 + decMonthlyInterestRate)
If decFutureValue > 1000 Then
[code]....
View 4 Replies
Dec 9, 2011
Now I have a sub to validate a bunch of textboxes and combo boxes.I previously used many IF statements to validate and pop up different messageboxes and Exit Sub in every IF statement.But I heard that too many Exits will decrease the efficiency and they were not recommended to use. Instead, nested IF is better because it will let the process naturally go to the end.Then I found out that if I use nested IF,it will be hard to read, since messageboxes are all separated from conditions.
View 2 Replies
Oct 12, 2009
How do you continue a select statement on additional line in vb
View 3 Replies
Oct 5, 2011
This is what I have so far for the following scenario: I want to have it so that if a users clicks submit without checking a check box from one section it throws up a dialog box that makes the process loop and give them a chance to check a box. The process wont continue until at least one check box is checked. The same thing above goes for my radio buttons as well. Here's my code:
[Code]...
View 2 Replies
Oct 14, 2009
See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
View 29 Replies
Jan 1, 2010
I was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
View 13 Replies
Jun 8, 2009
y friend and I are re-learning Visual Basic, and we are stumped on this bit of code.
For intAsterisks As Integer = 0 To intLine - 1
lblAsterisks.Text = lblAsterisks.Text + "*"
Next
View 6 Replies
Jun 24, 2011
I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
View 1 Replies
Jun 23, 2010
A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
View 7 Replies
Aug 4, 2010
I cant get this SQL statement to insert any of the values in the form to add to the database
sql
sql = "INSERT INTO prevresults (ExamDate, ExamTime, CorrectAnswers, PassPercentage) VALUES (date.now, time.now, rightanswers, percentage.text)"
[code]....
View 4 Replies
May 24, 2012
Return statement which is true in an if statement
View 3 Replies
Dec 17, 2011
I've got the following that has got multiple values of a particular variable and I don't want to stack up to a lot of IF ELSE statements to handle them, so I'd be grateful if some one could very kindly modify the code by using the SELECT CASE statement. Also, I'd like dgMarksEntry.Item(7, i).Value and dgMarksEntry.Item(8, i).Value to handle RANK and COUNT the number of items entered respectively. [Code]
View 2 Replies
Apr 22, 2011
I'm writing something that will examine a function and rewrite that function in another language so basically if inside my function F1, i have this line of code var x=a.b(1) how do i break up the function body into symbols or "tokens"?I've searched around and thought that stuff in System.Reflection.MethodInfo.GetMethodBody would do the trick however that class doesn't seem to be able to have the capabilities to do what i want..dit 2:basically what I'm trying to do is to write a program in c#/vb and when i hit F5 a serializer function will (use reflection and) take the entire program (all the classes in that program) and serialize it into a single javascript file. of course javascript doesn't have the .net library so basically the C#/VB program will limit its use of classes to the .js library (which is a library written in c#/vb emulating the framework of javascript objects)
View 4 Replies
May 17, 2012
I'm converting a asp.net application from .NET 2.0 to .NET 3.5 I have loads of inline code like so:
Dim Total = 0
for each dr as DataRow in dt.Rows
Total = Total + dr("SumOfAmount")
next
Response.Write(FormatCurrency(Total,2))
Notice that there is no explicit type declaration of the total variable.This code worked fine under .NET 2.0 Under .NET 3.5, the Total variable is defined as an Integer, therefore the total is being rounded to the nearest dollar on every pass.I know one solution is just to change
Dim Total = 0
to either
Dim Total as decimal = 0
or
Dim Total = 0D
However I'd prefer to not have to visit every page in the system looking for this problem.Is there any site wide, or page wide option I can set the change this behavior back to the way it was under .NET 2.0?
View 2 Replies
Jul 19, 2010
Why in the world did the VB team decide to change the format of a for statement for parallel processing to make it look more like a C# statement?Very confusing to VB programmers and it seems to be not needed. Why not just use the current for loop format prepended with the parallel?Certainly the compiler must be smart enough to be able to handle that?
View 2 Replies
Jan 17, 2012
I have an existing stored procedure that need to be used now as inline SQL statement in my VB console application. How do I change it?
Stored Procedure:
:Setvar CUSTOMDBNAME "My_DB"
USE [$(CUSTOMDBNAME)]
GO
[Code]..
View 1 Replies
Oct 5, 2009
how to use them then before, but am still a little confused with a few aspects. Here goes:
1.) Lets say you have a method that checks for a certain condition(s) and if it fails Throws an exception. Does it have to be in a try/catch block? Meaning can the "Throw" statement exist in a block with no try/catch statement?
2.) Now lets say we have a method that has a try catch block and in it there is a throw statement. When the throw statement is executed does it first try to find an appropriate catch block in the same method or does it immediately go back to the calling method without looking at the catch statements in the current method where the exception was thrown?
3.) I created a custom exception class that inherits from ApplicationException. Next I created a method which has a catch block that catches this type of exception and does some action. Is the System(i.e CLR) smart enough to throw an exception of this type, or does it only throw exceptions from SystemException?
4.) I know that some people are more liberal in their use of exceptions and others use it more sparingly when truly strange stuff happen like the DB going down. I am writing code where I am getting some info back from the database, converting it and then storing it. Sometimes there might be data that comes back from the database and other times the field is empty and the Null value comes back. Therefore in the instances where Null comes back from the database I should not convert the value to anything, since I will get an error. What should I do in this situation? Should I let the CLR throw the exception when it goes to convert the Null value or should I check for the Null value and if it exists not convert?
5.) In general when I throw exceptions, is it sensible to only throw exceptions of the type Application Exception or are there instances where the programmer throws exceptions of the type SystemException?
View 2 Replies
Jul 11, 2010
I'm building a listview search feature in my app. (See the code below). It works really well, except if you search "T" then the code removes all items, if you search "t" then it removes every item except for those starting with "t". Is there any way to make a 'like' statement, or use some kind of wildcard to make the statement not case sensitive?
For Each itm As ListViewItem In ListView2.Items
If itm.Text Like TextBox1.Text & "*" Or itm.SubItems.Item(1).Text Like TextBox1.Text & "*" Then
Else
[code].....
View 2 Replies
Oct 14, 2009
the below statment is right 100% but what i need is to change the word mobinil when the user choose another item from the combobox
cmd.CommandText = "select * from warehouse where mobinil ='" + ComboBox2.Text + "'".I thought that i can do the follwoing dim x as string x= here will be the item selected by user- and ofcourse i need it to be put instead of the word Mobinil
cmd.CommandText =
"select * from warehouse where x value ='" + ComboBox2.Text + "'" is that possible ?
View 8 Replies
May 2, 2012
I have a line of code that is working in one statement but not the second statement. I'm not sure what I'm doing wrong, I am learning slowly but surely, and it is by no small margin because of the ave found here =) The error is occuring in the intResult = intSelection x intCount line of the SECOND Do While Loop.
The blue squiggle line is under "intCount" just FYI
Dim intSelection As Integer
Dim intCount As Integer = 0
[code]....
View 1 Replies
Jan 29, 2009
I have the following vb code which works as expected when it's in a code-behind page. I tried to move it to a shared or component page since I will need to use it in multiple pages:
Imports Microsoft.VisualBasic
Public
Class DetTime
'Determine eastern time
[CODE]...
However the "if" statement shows an error " statement cannot appear outside of a method body" and the Microsoft solution is to "move statement into a procedure or subroutine"
View 1 Replies
Oct 31, 2011
I have coded a case statement that changes the background colour of a panel. [code]When the code is run, it works for the case of colour1 that is NOT 1 or 2. However, when the colour1 is 1 or 2, it is supposed to pick a number from set array and run another case statement. Instead, it only picks the last value (for 1, this is 5, and for 2, this is 7).
View 3 Replies
Nov 22, 2011
I want to change a picture in a if statement. The picture is in a picture box. I tried:
if picturebox1.image=myresouces.grass.jpg then
picturebox1.image=myresources.picture.jpg
else
end if
View 3 Replies
Mar 17, 2010
Where should i put the Using statement in Visual Basic 2008 Express Edition? as i put in under general declaration, it said "statement cannot appear outside of a method body"
View 1 Replies
Jan 11, 2012
I have a table named "Admin(a)"And i have a SQL statement:
SELECT *FROM Admin(a);
But (a) gives me a error.How should i express Admin(a) in a sql statement?
View 2 Replies
Mar 20, 2011
Dim x As New Serialization.XmlSerializer( ... )
Using file As New FileStream(myFile, FileMode.Create)
Using writer As XmlWriter = XmlTextWriter.Create(file)
[code]....
I've read that you're only supposed to use a Using block on objects that have a .Dispose() (i.e. implements IDisposable), which is why I'm thinking there shouldn't be a Using on "writer", but instead a writer.Close() at the end. But "file" has both a .Dispose() and a .Close(), so which do I use? The Using or a file.Close()?
Note: I'm using an XmlWriter because I can customize the output. I removed the settings here, though.
View 5 Replies
Aug 14, 2011
I am new to VB8 and I cannot get the IF statement right.I think I am not getting the Dim correct.I have posted before with an IF problem and this program is ok until the last IF.
[Code]...
View 12 Replies
Jun 2, 2011
I am using Visual Studio 2005 and am unable to use the "Using" statement. I have just moved some code over from a .net 4 application, but that does not seem to be the problem as it is still not usable in a new app.
[Code]...
View 2 Replies
Feb 28, 2012
Equivalence of "With...End With" in c#?So i don't know if this question has been asked before and I am not a big fan of vb.net. But one syntax that I am missing in C# is the With syntax.[code]Is there a syntax in C# that I have missed that does the same thing?
View 7 Replies
