I am trying to write an if statement for a button something like:If Button1 Clicked then do thisIf Button1 notClicked then do thatI couldn't find anything. All code are for radio button of check boxes.
View 6 RepliesSee
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?
I want to make an if statement inside a button. So basically its this Private sub Button1_Click ....
If Button2.click then
blah blah blah
else if button3.click then
'blah blah blah
End If.
How would I do this because I can't seem to solve it with any code of mine, i searced through all the allowed values that vb offers and nothing ...
Is it possible to replace the calculate button with a statement so that the percent complete automatically calculates when a box is checked or the text box is modified?
I have not been able to find anything except a 'do loop' that even comes close.
Public Class Form1
Dim C1, C2, C3, C4, Tb, Tb1 As Decimal
Dim PctCmp As Decimal = C1 + C2 + C3 + C4 + Tb
[Code].....
I need to perform a calculation based on the idea that the user will select the operation, which is in this label lblOperation. The two numbers, num1 and num2, come from lblNum1 and lblNum 2, which are randomly generated. How can I change the statement to say lblCorrect.Text = the value of num1 and num2 where the operation performed is whatever operation the user chooses from lblOperation.Text? This is what I have so far:
'btnSubmit instructions
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
[Code]....
Instead of always adding the num1 and num2 I want the operation to be between the two numbers and the answer to be printed in lblCorrect.
Im writing an if then statement and i want it to say something like this:
If intx = 1 and btn.click = true then
'the rest of code
end if
But obviously "btn.click" isnt a real command.
I am currently having a problem in my SQL Statement . I am creating a back and next button and about the Next Button it works just fine. But in previous button its kinda ok...but the problem it goes at the first row not the previous of the selected row.
Here is my SQL STATEMENT...
"SELECT t1.* FROM (SELECT RecordID FROM tbl_assessment WHERE StudentNo LIKE '%" & txtstudentno.Text & "%')t2 CROSS APPLY (SELECT TOP 1 * FROM tbl_assessment WHERE RecordID < t2.RecordID ORDER BY RecordID ASC) t1"
I have a button on a web page that I just need a little help with some extra code. I think I need a TRY, CATCH statement?, this is what I have so far: I have a simple web page that has a button which at the moment when pressed enables the user to add data to a DB table via a stored procedure.Once this button is pressed a pop up message box is displayed to let the user know the data has been passed. The user then needs to press the 'OK' button within this message box which then directs them to the home page of the site. This works fine.
The code for this is here:
Protected Sub btnAddRawData_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAddRawData.Click
'database conn, this is linked to the web config file .AppSettings
Using dbconnection As New SqlConnection(ConfigurationManager.AppSettings("dbconnection"))
[code]....
As I don't want the user to enter duplicate records in the database (This could be done by the user navigating back to the page where the btnAddRawData_Click is located and pressing it again.), I have created a UNIQUE INDEX named 'DupRecords' to stop the user from commiting this data more than once that day.When I run the web page now I get the following message in my browser:
Cannot insert duplicate key row in object 'dbo.GasRawData' with unique index 'DupRecords'.The statement has been terminated.The solution I think, is to add a TRY, CATCH statement into the btnAddRawData_Click code.
i have a class where are code the methode that i have to use in my form. i want to display on a button with a if statement a text value depending of the requirement are met. i put the code of the class here:
[Code]...
I have a project in which I have to display a picture box based on:
Which radio box is checked
and
if a checkbox to make the picture box visible is checked. As someone who values clean, good code this is my code and it horrifies me. My question, is there some way to condense the following using cases or some other construct I don't know in VB.net?
If CheckBox1.Checked = False Then
BooksPictureBox.Visible = False
MusicPictureBox.Visible = False
[Code]....
Note- all the images stack on one another, and all of them start without being visible.
Dim i As Integer
If Label1.Text = "" Then
i = BPORes_csvDataGridView.CurrentRow.Index
Label1.Text = BPORes_csvDataGridView.Item(0, i).Value
[CODE]...
I have this code in the click event for a button I want to be able to select a row in my datagridview then Hit the ok button and have it populate to text box1 if textbox1 is already filled then i want to go to textbox2 and so on, (total of 6) So far if extbox1 is empty "" and i click ok button it populates, when i click ok button again to textbox2 does not populate.
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]...
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?
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
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?
I am doing a bar cash register and I want to use a if statement to see if fosters button and number 1 on the number pad are both pressed then multiply constant by quantity number
View 1 Repliesadd 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]...
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
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]....
getting Error in VB 2010 = " Syntax error in INSERT INTO statement" when clicking on save button
View 17 RepliesReturn statement which is true in an if statement
View 3 RepliesI'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 Replieshow 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?
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].....
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]....
Using 2 forms how would I click one button, from another form? ie In VB 4,5,6, I would used to do it as:-
Form 1:
private sub Command1_Click()
msgbox "Say Hello"
End Sub[code].....
If I clicked the button in form2, it would automaticlly, click the button in form1. Do I, do it the same way in VB Express or has it changed?
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"
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 RepliesWhere 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 RepliesI am creating a VBA application using Excel 2007 and would like to make virtually all of the standard Office and Excel menus invisible to the user and present to the user only my custom menu controls. I have been successful in doing this for all objects on the Ribbon as well as those on the Microsoft Office Button Menu, with the exception of the "recently opened files list" box, that also has the "Excel Options" and "Exit Excel" buttons on it. Can anyone tell me the name of the object for this control so that I can make it invisible?
Here is the relevant snipit of XML code that is in my CustomUI.xml file:
[Code]...