I am new to using VB2010 (and coding in general). Also brand new to these forums . Okay so I am making a program that: allows the user enter the number of customers served for each of 12 months into an array. The application should calculate and display the following statistics: total number of customers for the year, the average monthly number of customers, and the months with the highest and lowest numbers of customers. Use inputBox to get user input. Do not accept non-numeric or negative numbers.
The problem that I am having is that I do not know how to display which was the best and worst month. I imagine I need something that targets the highest/lowest number and finds the text in the corresponding index but I'm not sure how to do this.
I need a way to detect which one is the largest, and which is the smallest, and assign them to a variable.If SideA is the largest, then it is variable C, and SideB is the smallest, so its variable A, leaving SideC as variable B
label10 displays which is the highest number label12 displays which is the lowest number label14 displays which is the number that is duplicated
My codes don't run 100% correct.:'( Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label6.Text = Val(TextBox1.Text) Label7.Text = Val(TextBox2.Text) Label8.Text = Val(TextBox3.Text) [Code] .....
I got a problem with dataview that get data from datatabel (Col1 : ID,Col2: Time) and I'm sorting by Time in desc ... when the values for example {40.21,80.21,70.25,25.2} the dataview sorting them as I need but when one of values goes above 100 for example {40.21,80.21,100.25,25.2} the dataview always sort the highest number is the buttom, I don't know why ..
This is a sample code
Dim dt As New DataTable dt.Columns.Add("ID") dt.Columns.Add("Time") [CODE]...
The application I'm doing requires me to "enter the size of an array in a TEXTBOX, then click a button, a list of random number would show up, then re-arrange from Lowest to Highest".For ex, i enter "5" in the TextBox, then an array or list of 5 random number will show up vertically on the ListBox. I already got this part done. Now the thing is, I have to make a For...Next statement to rearrange them from Lowest to Highest.
Now This Array is populated with decimal values and i just want to get the index values of the highest and lowest scores.i.e. if the [[scores(3) = 90]] and [[scores(7) = 90]] are equal and highest scores, i want 3 and 7 as integers in return..and same for the lowest scores..I retrieved data from a text file and stored it in Classes.. now i want to relate the above Array and these Classes..
Dim Student1 As New Student
There are total 20 of these classes.. Student2.vName, Student3,vName.. etc etc
For example, After i get the highest score indexes from scores(19) array i would like to get the name of the related person from Student*.vName Class (If i get 3 and 7 index i the related names would be Student4.vName and Student7.vName consequently)?
I have a chart in visual studio (winforms) with sql serverr2 as the database, how do I rank the "Rate" from highest to lowest? Like, conn.Open() Dim sqlProducts As String = "Select ID, rate fromAdvancedQuizModule1" Dim da As New SqlDataAdapter(sqlProducts, conn) Dim ds As New DataSet() da.Fill(ds, "AdvancedQuizModule1") Chart1.Series("Advanced").XValueMember = "ID" [Code] .....
I have this values tablename: AdvancedQuizModule1 ID Rate 1 43 2 5 3 87 4 23 When I plot the points (rate) it will just shows the order of the table from ID(1-4). How do I plot it in the chart that when the values displayed it was ranked from highest to lowest.
Entered an 5 elements of an array so is has 4 index? I need to find the lowest and highest element of an array and their index position Example: I enter 1 2 3 4 5 The output should be like this The lowest is 1 and position of index is 0 The highest is 5 and position of index = 4
I need to find next highest no in a field that is a stick ref it has chars at front and 0 padded How so I strip off front chars and 0's to get actual highest no number in the table field?Am using LINQ against entity framework?
I have a text and numeric data in a column of excel. data is 1,2,3,A,B,C,D,10,11,12. I want to do sort these by SQL. and i want get data in below order 1,2,3,10,11,12,A,B,C,D.
is there any way to get a numberupdown text to show the value "+" so if the value is a positive number then it adds the plus sign in front of the digits.
example:
2.00 would become +2.00 3.25 would be +3.25
as when its negative its
-2.00 -3.25
It already adds the negative value when its negative of course.
I am taking a VB2008 class and I have the entire program figured out except for one thing. I've checked our text I've scoured the internet and I've tried tons of things.
What this section of code does is access a data file, calculate the average from it... done.. that works, calculates the highest number in it... done that works... and calculate the lowest number from the file... nope... not working. I've tried tons of things and what i have in there now keeps giving me an output of 0, when it should be a 2.
Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click 'Calculates average, minimum, and maximum temperatures from data file Dim month As String
I have a table named as table1 with IDNo column and the ID numbers starts with HL, EL, EE, HE plus the year and a four digits. [code]On form load, the user will select from radio button which category he/she would like to work on, whether HL, EL, EE, HE. Let's say that the user selected HL, I would like to get the highest number in table1 and extract the last 4 digits truncating any zero digit starting from the left side and update table2's sequence column with the extracted value.
How can I find a listbox average removing the 2 lowest number? I tried DimintSmall AsInteger intSmall = lstGrades.Items.Item(0) ForEachItem AsIntegerInlstGrades.Items IfItem < intSmall Then intSmall = Item EndIf Next lstGrades.SelectedItem = intSmall I cant select or remove it
I created a code that inserts a number into a row every time someone submits a form.I am able to read the data back to the form using a loop.My confusion is I would like to get the highest number from the data field(column)Lets say the Field(column) has five numbers from 1 to 5.How do I get the highest number?I was looking at using a loop to go through the field and bring out the highest number, but should I use an array?
What is the right way to find Highest decimal number out of 10 different numbers(or more)? I made this code below, and surprisingly it doesn�t work every time! All numbers are declared as decimals but some times 0.02 is a higher number then 0.11!
If n2 > (n3 And n4 And n5 And n6 And n7 And n8 And n9) Then TextBox11.Text = n2 End If
I have a file which has numeric values like [code]What would be the best way to display the highest number in a textbox +1?I have the following coding but to be honest it just keeps showing random numbers in the textbox.[code]Also what would you be the best way to append to the file? I have the following coding to append to the last line.[code]
I know how to get Total, Average, Highest and Lower number from using input boxes and so on, but how do you get them from within a listbox?I kno the format of the code, I'm just lost in how to get them from a listbox...I just need a few hints.
I don't know if I worded this properly, but I have a mdb query that I display in a Datagrid on my form. The first column is TransactionNumber, which is the primary key and a running total (ex. RackingTransactionKey=RackingTransactionKey + 1). What I need to do is when the form is opened, find the highest (last) TransactionNumber from the query or Datagrid and assign it to a variable (RackingTransactionKey), so I can can update it (+1), therefore generating a unique number so I can add data to the query.