VS 2010 - Query For Even And Odd Numbers
Dec 1, 2011"Select * from Table WHERE ItemNum=2 OR ItemNum=4 OR ItemNum=6"
I use the code above to select ItemNum w/ even number.. but the problem is how about 8 and above? The same with odd number?
"Select * from Table WHERE ItemNum=2 OR ItemNum=4 OR ItemNum=6"
I use the code above to select ItemNum w/ even number.. but the problem is how about 8 and above? The same with odd number?
I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from another table (tblMain) linked in this table (tblPrem) where it is the primary key, and just repeatedly generated after the clicking save button. Here is my current code which saves the data but does not do anything on the textbox1 + textbox2, and has an error message "At most one record can be returned by this subquery":
sqlQrySave = "UPDATE tblPrem SET premamt = " & textbox1 & " + " & textbox2 & " WHERE premno=(SELECT MAX(premno) FROM tblPrem GROUP BY contno);"
What I expect to happen is like this:
contno | premno | premamt
1................1.............45
1................2.............45
[Code].....
I am creating a process part of which returns a delimited string containing security group numbers, a few examples:
'3|5|6|9|7|4|8'
'5|6|299|27|4|8
'5'
I'm looking for help in fathoming an algorithm for splitting this string into the numbers so that I use each number as an argument within a separate query.Since there maybe only one number, or dozens I cannot work out the logic to make this happen correctly each time.
I'm again got stuck in a simple problem, i'm learning it by myself. I didn't able to do it as i've tried many times. I'm making calculator. Please tell me what I'm doing wrong?
VB.Net
Dim total, num As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = Label1.Text &
[code]....
I just got a textfile with a couple of numbers (1 number in one row), how would I sum these numbers? I thought it would be easy, but thing is it's turning out to be not so easy.
View 3 RepliesI am trying to write a console application that adds and undetermined amount of numbers together and then averages them and does some other calculations with them, but I cannot for the life of me figure out how to add many numbers together. I am doing this in a console application and using input boxes and message boxes to Receive and display the data. So the question is, How do I add many numbers together (an undetermined amount, maybe 5 numbers maybe 25 numbers) and then add them.
View 8 RepliesIn the TextBox1 I have the following numbers:5 4.1 6.23 0 0 7 7.924
Possible to calculate all the numbers in this way?
like replace all the "space" in "+" and get the answer or something?
every time i press the Roll Dice button the turn1roll1, turn1roll2, or turn2roll1, turn2roll2(depending on turn variable) it shows system.random in ASCII Chart i used the label names so no confusion.[code]
View 5 RepliesOnly now, I'm facing this kind of problem, i have a application that until now worked with two different cultures ENG and PT, i always knew this, and i manage to solve all problems related to parsing the numbers, but now i have to change the code, and "protect" the code to handle with others cultures. So i need tips/best way to handle different cultures, and different database culture settings.I think that i shouldn't limit the user, by setting the decimal, the grouping digit, the date time format, etc. . The application should accept the numbers in the user current culture. But this path forces me to putting everywhere the parse/tryparse method.
View 1 RepliesI have code to save records to my mysql database.But first I want to read what is the last number of record and add 1000 on that? What is the proper way to query that first. I want to make the result at unique ID of my clients. Here is my chunks of codes.
Private Sub addClient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As MySqlConnection
conn = New MySqlConnection
With conn
[code]....
i need a simple way to get a random number from 2 numbers. This means that for example if my 2 numbers are 3 and 7, i don't need a random number between 3 and 7 that would be like 3,4,5,6,7 but only a random that is either 3 or 7. Meaning not all the numbers between x and y, but either x or y.
View 7 RepliesI have this
[Code]...
All that is happening above is two players are being compared by scores and a winner is then decided. The calculation works fine and places the winner in the correct spot (txtWinner1.Text) as long as the numbers are positive. So if txtU1D.Text has 13 and txtU2D.Text has 14...txtU2 is the winner. Works with no problems. However, if txtU1 has -1 and txtU2 has -2...it says txtU2 is the winner. The negative scores are common in the game being played so the situation often happens, but may be one player only. It seems to work if one is positive and one is negative, but if both are negative it thinks the higher negative number is the winner for some reason. So it will give the win to someone who has -9 over someone who is -4.
I am making a calculator that accepts large number (represented as strings) and performs basic math functions on them. So far I have Add and Multiply figured out.
Here is addition
Private Function Add(ByVal Number1 As String, ByVal Number2 As String) As String
Dim num1, num2, r, total As New Integer
Dim sum As String = ""
[Code].....
I saw something like this in the code bank but the examples there were from VB6(?) and were hugely inefficient (compared his Add and Multiply examples to mine, his having way more code and loops.)
How do I add, for example, all the numbers in the textbox (they are separated by spaces)? I tried a couple of methods but no luck so far. So for example, this is what the user will input in the textbox:
View 7 Replies[code].....
View 2 RepliesI have an application in which a streamwriter is used to save values to a file. It all works fine, except I'm curious as to why the values in the file would be rounded. They are rounded with enough accuracy that it doesn't really matter to the app, but I'd like to know why this is happening. My line of code that writes the line is.
View 14 RepliesI figured there would be some simple way to set up some textboxes to allow ONLY numbers or ONLY characters, however I haven't found an easy way yet.
Is there a simple trick to setting something like this up? And if so, how would I do it?
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
I need to convert numbers to words, (ex: 123 to one hundred twenty three/ 123.5 to one hundred twenty three point five.I use visual basic express 2010. I intend to create a textbox for the input and use a label to show the result. If I call the textbox "textbox1" and the label "label1", what will the code be?
View 3 RepliesI've created a program that allows a user to input numbers and then outputs the highest and lowest number when the user is done (the user indicates this by using a sentinel value of -99). My only problem is that it keeps putting out the numbers reversed (largest as smallest and vice versa).
The code is below.
Module Module1
Sub Main()
'Declare Variables
Dim number, smallestNumber, largestNumber As Integer
'Get numbers from user
[Code] .....
Is it a no-no to have a module within a module like I do there? So far there is no mention of such in the book but I can't find an example of it happening yet either? The instructor wants modules to perform the input and return of information and the only way I could figure out it doing both of those things (rather than using the main module for user input) was to call the module that figures hi/lo within the module that asks for the numbers. I'm really unsure on this part.
I'm new to the forums and VB programming in general, so I only have a very basic understanding of VB commands, but I still have a good grasp on logic and the like. I'm doing this for a school assignment, and I am in a bit of a pickle.I am trying to generate an array of 6 random numbers from 1 to 30, making sure there are no duplicates.I think I'm pretty close to cracking it, but it still doesn't work.Here's what I have at the moment:[code]......
View 2 RepliesIn the code window near the line numbers which are set to show, a vertical band of green exists with a short band of yellow which seems to be near the part where I am entering code.
What is the significance and usefuleness of this?
I have some trouble to combine text and numbers from a cell in my excel sheet.C
FilePath = "V:DatasheetPDF-COA & Sheets("Ark3").Cells(4,10).Value & *.*"
So I have an assignment dealing with arrays for school but first I will start it off with the simple question as to where I am stuck now. I was wondering what the simplest way is to declare all the numbers in an array without going down the list one by one ( ArrayA(1) = 1, ArrayA(2) = 3 and so on.) I was wondering if the simplest way to do this is just by putting: ArrayA = ArrayA += 1 or what the simplest way to do this is.
View 6 RepliesWe have exactly 120 employees entered in "EmpMaster" table, "EmpId" number field set for 'Auto number' start from 1-121. Now my problem is HR Department instructed me to continue EmpId number start from 1121 for new employees. So I want to continue new records in the same Table.I'm using the code to INSERT record is : EmpMasterTableAdaptor.InsertQry on windows form. Operating - Visual Studio 2010Prof and SQL Server 2008 for database.
View 2 RepliesI have 5 numbers, each ranging from 0 to 100. Each number changes from time to time. I have to sort them as highest first and smallest last. How would i do it?
View 3 RepliesHow do I use line numbers? For example, I'm reading a text file and I'll need to get the line number of the line "=====LINE=====" somewhere in the text file, and I'll need to get the text of the next line (+1 of the previous line, but I'm not sure how to do readline(line number)).
View 12 RepliesFor example, to calculate this:(22 ^ 29) Mod 57Supposedly there is a way to get around overflows and do these calculations, but I can't find much online. Now, the person who said this was doing VBA in Excel and said that there was about 4 lines of code which could handle the overflow so it wouldn't happen.
View 4 RepliesI reproduced the following code to update a database and I get the error" Operation must use a updateable query"
[Code]...
First off, I'm not sure if this is the right forum, please move it if it isn't. I am only just beginning with visual basic and I am trying to write a basic program to calculate the prime numbers from 1 to 100. This is what I have so far:Dim flag As Integer Dim ar(101) As Integer
[Code]...