How To Compare A Control Using If Statement
Feb 8, 2009please help me to correct the error "TextBox is a type and cannot be used as an expression" for the following statements..[code]
View 1 Replies
ADVERTISEMENT
Compare A Value With The Whole Array In One Statement?
Jun 23, 2009I have the following problem:
Dim MyArray (2) , MyValue as integer
Dim R as New Random
For i = 0 to 9
MyArray (i) = r.next(20)
Next i
Suppose:
[Code]...
VS 2008 Simple Compare Statement?
May 27, 2010I'm pretty new to VB.NET and I'm looking for a comparison to do this:
For Each c As Control In Me.Controls
If TypeOf (c) Is ComboBox Then
If c in (combo1, combo2, combo3, combo4) then
' do some crazy stuff
else
'do other things
[Code]...
Compare The Current Date To A Control Field And Perform A Function?
Oct 8, 2010I know nothing of VB.NET, but if I were you
View 2 RepliesDatabase - Compare Two Fields In An SQL SELECT Statement To Then Select Other Fields Based On This Result?
Apr 8, 2012I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
Compare Date - Compare Textbox1 And Textbox2 Text
Mar 3, 2010I have two textbox in my application.
Textbox1.Text="19-Jan-2010"
Textbox2.Text="Jan 2010"
May I know how can I compare that Textbox1 and Textbox2 text is within same month and same year?
If Statement With A Numericupdown Control
Dec 5, 2010I have done some code so that when you choose a number from the numeriupdown it will look at the if statement and put the age into a category. the thing is the number in the updown doesn't go into the right category for me can you see what the problem is? [Code]
View 2 RepliesUsing If Statement With A Numericupdown Control?
Dec 5, 2010I have done some code so that when you choose a number from the numeriupdown it will look at the if statement and put the age into a category. the thing is the number in the updown doesnt go into the right category?
'Assigning Textboxes and Combo Boxes To Memory
lblUsername.Text = Username
strCustomerName = txtCustomerName.Text
intCustomerAge = Val(NumericUpDownAge.Value)
[code]....
Different Behavior Of If Statement In Timer Control?
Jun 28, 2011Private Sub TimerSaveonemessage_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TimerSaveonemessage.Tick
Dim Checkifsended As String = ""
If Checkifsended <> FixNummber(MessageToTextBox.Text) Then
[code]....
How To Have More Than One SQL Statement That Will Control Data Flow
May 12, 2010I am wondering how to have more than one SQL select statement inside my window formapplication that will control the data flow, as i am a newbie in visual basic.net 2005. This is because I am working on a Alarm Application Notifier which will alert the guard on duty as well as inform him the alarm location. The guard's computer screen will be showing the premises and the button will blink at that location where the alarm is. So if the alarm is at block A for example, the guard screen will show block A button blinking.I have already done the first part but i am STUCK at the rest as to how am i going to seperate the conditions for the 3rd to 4th building .The bottom is for the first building code. The data is from the sql database.
Imports System.Data.SqlClient
Imports System.data
Imports System.Drawing.Image
[code].....
One SQL Statement That Will Control Data Flow?
Aug 10, 2009I am wondering how to have more than one SQL select statement inside my window form application that will control the data flow, as i am a newbie in visual basic.net 2005. This is because I am working on a Alarm Application Notifier which will alert the guard on duty as well as inform him the alarm location. The guard's computer screen will be showing the premises and the button will blink at that location where the alarm is.So if the alarm is at block A for example, the guard screen will show block A button blinking.
I have already done the first part but i am STUCK at the rest as to how am i going to seperate the conditions for the 3rd to 4th building The bottom is for the first building code. The data is from the sql database.
[Code]...
Statement Can Be Created To Activate A Butt Non Control?
Aug 2, 2011Is there a way in which a case statement can be constructed to call, activate or triger a button control? If not, is there a way any statement can be created to activate a butt non control?
View 2 RepliesVS 2008 Using Output Of Calendar Control In SQL Statement?
May 13, 2009 trying to write a simple app that queries an access DB based on date .. the SQL looks like this and works fine with a date hard wired into the select:
SELECT Terminal_ID, SUM(Transaction_Quantity) AS Total
FROM tblTransaction
WHERE (TransactionType_ID = 3) AND (Transaction_DateTime > #1/1/2009#)
GROUP BY Terminal_ID
On the main form I have a monthcalendar control named 'FromDate' and a DataGridView control that shows the SQL results.
How do I get the user's selected date incorporated into the SQL statement that returns the results in the datagrid?
Something like:
WHERE (TransactionType_ID = 3) AND (Transaction_DateTime > Fromdate)
...but obviously there's much more to it.
WebBrowser Control - Searching For Website Using For Statement
Feb 13, 2011I have made an app that will check to see if a website is on the 1st, 2nd, 3rd, 4th, and 5th page of google, the websites are in a datagridview. I am using five webbrowser controls but it begins to get slower and slower? As it searches for each website using a for statement. How to improve this code to make it run quicker, or even a better way to go about it.
View 8 RepliesAsp.net - .NET Button Control, OnClick Event: (Try, Catch Statement)?
Oct 31, 2011I 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.
Forms :: Use Inputted Data From The NumericUpDown Control In A Statement?
May 13, 2009I have a NumericUpDown control with a range of 10-50 and I want to have the selected number be multiplied by an amount of money to create yearly cost. I dont know, however, how to use inputted data from the NumericUpDown control in a statement because I cannot convert it to Integer and I also dont know how to call in the data even if a number is selected.
View 3 RepliesMake A Statement That Sets The Focus To The TxtPassword Control?
Sep 29, 2010how do you make a statement that sets the focus to the txtPassword control?
View 1 RepliesQuery Date Range Statement - Bind An Access Database To A MSChart Control
Jun 10, 2011I am trying to bind an Access database to a MSChart control in VB Net 2008. I have a test database populated with four fields SAMPLE-DateTime, Values-Number, MAX-Number and MIN-Number. I'd like to only display the rows that fall within a specific date range but I'm running into a problem when i try to execute the following command:
[Code]...
Compare Version Between Host And Client Download The File If Compare Version Not Same In .net?
May 20, 2011they need to make some compare version between host version and client version.. and each 1 version different will download the file to the client..[URL]..with both example, how can i make a program in VB.NET just like i said just now?
View 15 RepliesSQL Statement Doesn't Work - INSERT Statement Works Fine In The Form Load But Not In The Button Click Event?
Oct 14, 2009See
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?
If <expression> Then <statement [:statement]> Else [statements] In Concrete Form?
Jan 1, 2010I 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?
Making A Next Statement Into A Loop Statement In Visual Basic?
Jun 8, 2009y 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
Sql - Perform An Inline Select Statement In A LINQ Statement?
Jun 24, 2011I 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?
Change The Exit Statement To A Continue Statement?
Feb 23, 2009add 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]...
ElseIf Statement Into A Select Case Statement?
Jun 23, 2010A 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
SQL Statement :: Nearly Working Just Cant Get Form Values In Statement?
Aug 4, 2010I 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]....
Return Statement Which Is True In An If Statement?
May 24, 2012Return statement which is true in an if statement
View 3 RepliesBreak Up The Code In A Method Body Into Statement By Statement Symbols/"tokens"?
Apr 22, 2011I'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 RepliesExceptions - Can The "Throw" Statement Exist In A Block With No Try/catch Statement
Oct 5, 2009how 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?
Make A 'like' Statement Or Use Some Kind Of Wildcard To Make The Statement Not Case Sensitive?
Jul 11, 2010I'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].....