I need to know how to make a number to number if statement e.g. if min = 20 to 40 then ...
Current code:
If hour = 8 And min = 20 or 21 or 22 or 23 or 24 or 25 or 26 or 27 or 28 or 29 or 30 or 31 or 32 or 33 or 34 or 35 or 36 or 37 or 38 or 39 or 40 Then
TextBox1.Text = "Test"
Else
TextBox1.Text = "Text1"
End If
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 Repliesi want a button to perform a function of checking the last digit number in a field of a table in and add a digit to it and display it in a textbox.
View 1 RepliesI am making a program that chooses the active runway at an airport from the wind data. So far I have a formula that works without out a number range:
Private Sub TextBox1_TextChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If TextBox1.Text = "" Then aarwy.Text = "Run"
[Code].....
Dim MyVal As Integer
Dim MyVal2 As Integer
MyVal = Val(TextBox4.Text)
[code]......
I have some variable that when divided I get this symbol: -1.#IND when you look at the variable in debug. This only happens when I put the equation in the Dim statement.
[Code]...
I don't have a problem. Why when I put the equation up in the declaration area it sets it to -1.#IND (I assume this is infinite or NAN or some such). I'm curious as this is the only time I've had difficulty with this.
I am writing a tabbed webbrower program and i am trying to close the program when all tabs have been closed using ctrl+w. So far i have used the following code but it has errors as tabcount is readonly:If TabControl1.TabCount.Equals(0) then Me.Close() End If
View 15 Replieshow I can get the LIKE statement to work if the user enters a number like 403* ? The sql works if I do not enter an *
strWildCardFound = InStr(TNSearchTextBox.Text,
"*")
TNSearchTextBox.Text = Replace(TNSearchTextBox.Text,
[Code].....
I have an access database that I am writing a SQL query to insert data from my datagrid into a table that I created.I get an error that I have tracked down to field types that I have created as a DOUBLE. Here is my SQL Query for creating the table -
[code]
("CREATE TABLE [SSR Shts_" & FullName & "]([ID] AUTOINCREMENT,[Division] Text(255),[Bid Reference] Text(255)," & _
[code].....
i am using vb/vb.net and the database is visual foxpro 6.0 then i want to create the tables from the application using sql statement.i need to add the number field into the table. i can not add the number field in the tableres.open "CREATE TABLE Customer ( CustName char(50), CustId int(2))",conXavier
View 2 RepliesI have the following insert into statement. What I want to do is insert the values to gprdsql.TblOracleNos if TxtOracleNo is not empty, therefore if a user logs on and fill the textbox the values are saved to the table. However, if the oracle number exists in gprdsql.TblOracleNos (i.e, the values ) it should not insert the values, presently it creates the same record again with same values (when the save button is clicked) and this creates duplication. Instead probably bring a pop up message "Oracle number already exists. [Code]
View 6 RepliesI'm working on my first project using LINQ (in mvc), so there is probably something very simple that I missed. However, a day of searching and experimenting has not turned up anything that works, hence the post.
I'm trying to write a LINQ query (Linq to SQL) that will contain a multiple number of conditions in the where statement separated by an OR or an AND. We don't know how many conditions are going to be in the query until runtime. This is for a search filter control, where the user can select multiple criteria to filter by.
select * from table
where table.col = 1
OR table.col = 2
OR table.col = 7
'number of other conditions
Before I would just construct the SQL query as a string while looping over all conditions. However, it seems like there should be a nice way of doing this in LINQ. I have tried looking using expression trees, but they seem a bit over my head for the moment. Another idea was to execute a lambda function inside the where statement, like so:
For Each value In values matchingRows = matchingRows.Where(Function(row) row.col = value)However, this only works for AND conditions. How do I do ORs?
i have to convert a visual basic 6 program to the visual basic 2008. i used the wizard that is provided to upgrade but that just doesn't work. It comes up with many errors. most of them are End of statement expected and Number of indexes exceeds the number of dimensions of the indexed array. I really don't know what to do with them and i have to fix them in order for it to run.
View 18 RepliesI have an SQL statement which i need to code in vb:
CODE:
Notice the fields prodno1 and prodno2 in the table structure.. this is part of a number of sql statements i need to run and put inside a loop. my problem is i want to automatically use this same code such that on the next loop, this sql statement is going to be:
CODE:
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
And so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
How to write a if else statement to check if the number user enter follow within a range.
View 5 RepliesI have a problem with a sql query. Through the query I am trying to search database for any occurrences of string (can be anything) in a column using the SQL LIKE command. The problem is that it works fine for most of the strings say john, jim, ji"m , but does not work when i include the following characters which are ( ' , { , } , and a single quotation mark). MYSQL query takes care of these special cases by putting them in [] block whenever user enters them .But i am getting the following error when i go to query the database using the GetSelectCommand() in VB.NET
Exception Details: System.ApplicationException: Number of values provided must be equal to the number of placeholders in query.I have checked the query over and over again .. but its fine .My database server is Sql Server 2008.So my application throws the exception in this command:
Using reader As MustDisposeDataReader = _
pmSystem.DatabaseManager.GetSelectCommand(selectStatementBuilder.ToString(), New Object() {})
Where MustDisposeDataReader is an instance of a class in an internally developed library, which inherits from System.Object. pmSystem is an instance of the class PlanManagerSystem which implements the commandlayer. GetSelectCommand() takes the select command
I got most part correctly but the only part isnt working right is when the last 5th digit match the sum number at the last number.
Private Sub btnVerify_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnVerify.Click
Dim strCardNum As String
Dim strSumNum As String
[CODE]...
I am trying to filter a dataset using a number different inputs, selected by a number of check boxes. I have all the text base rowfilters working, but I can not make the date filter work unless I hard code the datetime into the code. The database is MS Access and I am using VB2008 to show the data. I would like to be able to use a DateTimePicker to set the filter date (without the time part) Also I would need to remove the time section of the datEnterDate. I cannot change the structure of the database fields. Also the datEnterDate is MM/dd/yyyy, because I'm in England I would like to use the format of dd/MM/yyyy if possible
[Code]...
I have a txtbox(for barcode).. if i input a item number in that txtbox and if that number will match in your database, the other information(shall we say, product type, item ID, etc..) will display in my other txtboxes..
View 5 RepliesIn VB if you prompt the user for a number between 1-20, then a word, how do you get a text box to show the word the same number of time as the number selected using loops?... Ex: please select a number: 4 / select a word: cat....the text box should display ::: catcatcatcat ........
I am doing this for a class and my brain has locked up. Prob. just over thinking it though. Thanks in advance for any help!
I am attempting to create a game in Visual Studio 2008 that allows a user 10 attempts to guess a random number between 1 and 50. I have a label box in which I would like to display the remaining guesses as they decrement. The code so far appears below.
My two (I am sure very basic) questions are:
1. How would I pass the random integer generated through the Generate Integer function to the AmIRight button's click function? I was trying to decrement the counter each time the "Am I Right " button is pressed.
2. I would also like to evaluate each "guess" when the "Am I right button is pressed. Is it possible to nest a Select Case statement in a For Next Loop?
vb.net Option Explicit OnOption Strict OnOption Infer Off Public Class frmMain Private Sub btnExit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExit.Click Me.Close() End Sub Private Sub txtGuess_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles
[CODE]...
i wanted to create a random number generator that iterates through a series of number between an upper and lower bound. say between 1 and 100. Basically I want the number generator to pick the numbers randomly and then display them until all 100 numbers are picked without any duplicates. so thats easy I can code that. But what I don't know is how to show those numbers in the order they are generated on a windows form. So i have basically a variable that I will let be changed 100 times (or however many times I want, I don't want their to be a size constraint just using 100 as an example) and each time the number is generated I want it displayed on screen (in a list or something not sure what. Hopefully some type of scrollable list) and each successive number also to be displayed in same format beneath it so that I can see the list in its entirety. What type of form control do i use for that? I could do messagebox.show for each iteration but then user is required to hit ok after each iteration and that would obviously be a bad idea if user selected a large number to work through. Anyways, code isn't exactly necessary just point me in the right direction, i.e.what control (if any) to use.how to format the change in data?
View 7 RepliesI need to write a program that requests a high number and a low number from the user, then the program searches the array and finds all elements within the two numbers. The program is used to search for past presidents, so if I type 43 for low number and 44 for high number, the program will display:
George Walker Bush
Barack Hussein Obama
I think I have an idea of how to search up to a certain point, but not to stop at a certain point....Here is the code that I have for that particular sub procedure:
Quote:
Private Sub btnDisplayRqst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplayRqst.Click
Dim sr As IO.StreamReader = IO.File.OpenText("PRESIDENTS.TXT")
[CODE]...
I am trying to make a basic ATM system, iv got all the interface done and I have made the link to my SQL database etc. the part i'm stuck on is how I can run a check to see if a bank card number matches up to the users PIN number. To simulate the user putting a card into the machine I've used a combo box, and that lists all the cards, that haven't been flagged as confiscated (there's a column in my ATMCards table that I can set to true or false) then after the user has selected a relevant card there's another text box where they can enter in their PIN number.
Now what I want to do is, if they chose the card number 1234567890123456 in the combo box and they enter in the PIN 1234 into the text box, then, after clicking the check PIN Button if the pin is correct they need to be taken to another from where they can check their balance etc., and if its wrong they got three attempts after which point i want to flag that card as confiscated.
Trying to upload a picture file from an online source and store it in a byte array but am having the error: "Number of Indices is less than the number of dimensions in the indexed array".
Dim Bytes() as Byte
Dim Inet1 as System.Net.Webrequest
I want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
converting the number of frames (in a video) to a number/time format. For instance, say a video has 110,212 frames at 23.976 fps, it works out to 01:16:36 (hh:mm:ss) with 18 frames remaining. I would like to format the result in a Textbox like the following:
[Code]...
how do i count the number of rows that are affected when I updated a table, and display the number of affected rows in a message box ??
here is my code for updating the table ...
For Each row As DataGridViewRow In DataGridView1.Rows
req = row.Cells(Column1.Name).Value
If row.Cells("Column1").Value = True Then
[Code].....
I am trying to draw textboxes when the user enters the amount of textboxes to be drawn on one form and the textboxes get displayed on the another form. I have found these codes online but it works with inbuilt codes I guess. That is, the number is already hard coded in the form.
[Code]...
I created a listbox using VB.NET. When the user select an item (it is a string format) in the listbox and click on a button, there will be a number beside the string and the number will increment which time the button is clicked. Anyone know how to do it...?Below is the coding I'd done, but I don't know how to do the increment part. Anyone know what coding I need to add?
Dim no As Integer = 0
listBox.Items.Add(listBox.SelectedItem & no)