How To Write An If Else Statement
Mar 2, 2010
i have a question about how to write an if else statement. I was experimenting with vb 2008 and wrote a program that adds few numbers together and displays the result in textboxes. for example i input the following 4 number in 4 different textboxes
14 3 1 5
and the result i get is 15 8. I was trying to simulate adding times together(eg 14:03 + 1:05 = 15:05). Everything seems to be working fine but how can i place "0" if the output for the minutes is less that 10? eg instead of having 8 in the textbox i would like to have 08.
View 2 Replies
ADVERTISEMENT
Feb 25, 2010
I need to write an sql statement that has an IF condition in it
This is my current statment:
"SELECT * From History Where DelNoteNum = " & delNote & " ORDER BY StockLoc"
What I need to do though is if the StockLoc > 4000 then group by ProductCode. I definatly only need to do this if the stock location is greater than 4000 though.
View 9 Replies
Mar 29, 2009
How do i programmatically execute a SQL statement using datasets?
View 6 Replies
Apr 29, 2009
I need help with a month calendar. I want to write an If statement in a button_click event. I need an If statement that says if one date is selected then a label becomes visible. I cannot figure it out.
View 1 Replies
Jan 29, 2010
Write the pseudo-code for an If..Then statement that determines the apropriate tax rate for a given annual income level using the guide below:
Under $20,000 = 2% income tax
$20,000 - $50,000 = 5%
$50,001 - $75,000 = 10%
This is what i wrote:
If Annual Income is < $20,000 Then
income tax = 2%
If Annual Income is $20,000<= $50,000 Then
[code]....
View 2 Replies
Nov 17, 2011
If I have the following structure:[code]How can I select it in a conditional like this? [code]I know that myUsers.Contains(.ID = "1") is totally wrong, but I am curious how to do something like that?Is it possible? Is this a job for LINQ?
View 3 Replies
Oct 7, 2011
Im trying to figure how to use the IF, ELSE statements OR the Select Case statement to write this program.I'm using Visual Studio 2010. The program is suppose to allow the user to input their weight in a text box and from group box 1 the select whether theyre male or female using the radios and they select inactive or active from group box two and the calculate but will determine how many calories they should intake based on the criteria below.
[Code]...
View 14 Replies
Mar 11, 2010
Table 1 has fields: A, B, C, Table 2, there are fields: D, E, F, Table 3 has fields: G, H, I
Connect the condition that A = D and F = I
provide a look at Table A left join B, C of the SQL statement
View 1 Replies
Aug 25, 2009
How to write a if else statement to check if the number user enter follow within a range.
View 5 Replies
Feb 3, 2010
Basically, I am trying to write a LINQ to Objects statement where the relationship is a grandparent, parent, child relationship. (You could also call it a Master Detail relationship.)
Dim coverages As New List(Of Coverage)
Dim coverage As Coverage
For Each rl In oClaimsPolicy.RiskLocations
[code].....
View 1 Replies
Nov 24, 2009
I have an asp.net web form that uploads files. Part of the code seems messy to me, but I can't figure out another way to write it.
Here it is:
CODE:
Is there a better way to write this without all the "Or" s ?
View 2 Replies
Aug 26, 2010
[Code]....
Apparently, filetype refers to the extension of the program. But I do not want it to read .exe and .lnk programs. So how can I include this "If Else" statement into the one stated above?
View 3 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
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
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
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
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
Dec 27, 2011
I have a trouble making this code work. When executed, it just creates a correct (with the correct name) file with the extension .txt but the the actual text inside .
Imports System.IO
Public Class Form1
Public mytext As String
[code]...
The strange thing is that while debugging, h, t string variables have the correct values, but somehow mystream.write(t) doesnt work (it doesent write anything to my h.txt text file...
View 5 Replies
Jun 29, 2009
Ok i saw this guy on youtube that made a achievement generator for his computer. For example, he goes to notepad and write something and saves it and gets the xbox 360 achievement pop up saying "Gotta write this down" and all that. Cud this have been coded thru VB.NET or something?
View 1 Replies
May 23, 2012
i have a notification j-query plugin .. i taste it in my page (working 100%)but when i want to use it in a event SqlDataSource1_Deleted with the response.write method it does not work
Protected Sub SqlDataSource1_Deleted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Deleted
Response.Write("<script type='text/javascript'> showNotification({message: 'This is a
[code].....
View 1 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
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
Sep 14, 2010
I want to write a program to write in an xml file in this format:
<?xml version="1.0" encoding="utf-8" ?>
- <Orders>
<Item id="1" SKU="998123" Description="Super Widget" Quantity="100" />
[Code]....
View 2 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
Nov 3, 2010
I'm trying to write a sub that will write to a file. here is what i have:
Public Sub LogMe(ByVal MyType As String, ByVal MyMessage As String)
Dim LogStream As FileStream 'should be at a level with enough scope for your logging
[Code]....
The problem is that this will just overwrite what is already there. I would like to have it append the EHomeLog.log every time it is called.
View 2 Replies
