Finding The Lowest Number From A Data File?
Jun 13, 2009
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
[Code]....
View 2 Replies
ADVERTISEMENT
Jan 19, 2010
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
View 5 Replies
Jan 6, 2012
Get lowest number from different TextBoxes?[code]...
Now im looking to get the lowest number in one of the ".checked" TextBoxes and add that number to a new Array.
View 26 Replies
Jun 22, 2010
is there a method check the number of records in data reader? like the count of rows. ?
View 2 Replies
Jul 6, 2011
I have a table named tbluser with fields code and name. I want to check the lowest unused number in code. For example table below:
code name
60688 jane
60689 dina
[Code]....
i have also one textboxt what is the first, second and third number to search
ex.
if
text1.text=6
therefore first number is 6 second and third is 06 and the result should be
60601 since in the code the lowest unused code is 60601.
View 23 Replies
Nov 9, 2010
Dim MyVal As Integer
Dim MyVal2 As Integer
MyVal = Val(TextBox4.Text)
[code]......
View 4 Replies
Jun 7, 2011
I am not an ardent developer in vb.net programming. But off late I am using vb.net to develop a windows application.
The following is what I am trying to do:
I am reading an excel file and storing the string value present in each cell, and trying to match the string in a word file.
The program works fine except that I am having problems in returning the page numbers of the matched string.
The page number value is always returned as one.
The following is a piece of what I had written:
If FindStringInFile(wordfilename, vValues) Then
currentPageNumber = word.ActiveDocument.ActiveWindow.Selection.Range.Information(Microsoft.Office.Interop.Word.WdInformation.wdActiveEndAdjustedPageNumber)
TextBox3.Text = currentPageNumber
End If
wordfilename is my word file and vValues is my excel string data
View 1 Replies
Apr 3, 2012
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
View 7 Replies
Nov 14, 2009
I'd like to know how to sort an array that has entries with numbers after text.
I have a list of four entries:
Book 1
Book 2
Book 11
Book 12
Using Array.Sort(aBooks) returns
Book 1
Book 11
Book 12
Book 2
Is there a way to have it sort lowest to highest like 1 2 11 12 instead of 1 11 12 2?
View 3 Replies
Jun 14, 2012
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.
View 2 Replies
Apr 26, 2009
I have a group of 3 numbers:
-SideA
-SideB
-SideC
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
View 2 Replies
Feb 9, 2010
I have a binary file. If I look at it with a hex editor, the first values are:208, 207, 17, 224, 161, 177, 26, 225, 0, 0, 0, ... etc.It has a length of 330240 bytes I have tried to open it and read it into a string so I can manipulate it and write it back. No matter what I use, I either don't get the correct number of bytes or the values in the string are incorrect. The most common error results in the first values being: 63, 63, 17, 63, 63, 26, 0, 0, 0 .... etc.It is interesting that it appears that any value > 63 becomes 63.
I get the 2nd values by a simple loop:
For lnx = 0 To 99
Debug.Write(Asc(line.Substring(lnx, 1)))
Next
I have tried a whole number of ways to read in the file, including filestream, My.Computer.FileSystem.ReadAllText, File.io.readAllLines, etc.All either give me a string length of about 324000 (not sure why) or, if they do, don't have the correct values. Yes, I have tried various encoding options.
I need to find a string (sort of like: "D" & Chr(0) + "L" & Chr(0) + "S" & Chr(0)... ) so I can then replace that portion of the string with a new value, then write out the file.I use the ".indexOf" to find the data in the string.Why can't I load the file into a string? Or, do you know of an easy way to find some text (similar to above) in a file and then replace the next x number of bytes with a new value and close the file?
View 12 Replies
Jun 15, 2010
How can I sort data in a sorted list using values instead of keys from highest to lowest?[code]...
View 2 Replies
Sep 20, 2009
How would I find the place value of a number?
View 7 Replies
Aug 14, 2009
i'm dave mark.. im new to vb 2008.. i just have to have some question.. the problem is i have to input 10 integer number then after inputting the 10 number .. it will compute the sum, average and the smallest.. i have no problem with sum and average but in smallest number only... how to get the smallest number>>?
View 1 Replies
May 14, 2009
i just started to learn mod and i was having trouble with this. heres my code:
[Code]...
View 9 Replies
Jul 24, 2011
I wonder if it is possible to find a specific row and specific columns in data base file (Access) . You see , I am using a DataGridView control to show only SOME of the columns (fields) of a table from an Access file . For example , lets say that in the DataGridView control I only show the following fields :Field1 , Field2 and Field3 .Now , when the user selects an entry in the DataGridView control , I want to insert the text from Field4 into a text box on the form .
The problem , however , is that I don't know how to get the specific row in the data base file and also I don't know how to get the text in column (field) Field4 of that row .One thing that might be important is that the index of the row in the data base file is not necessarily the same with the index of the current row in the DataGridView control . This is because in the DataGridView control the rows are order by the contents in the ID Field .ol .
View 2 Replies
Nov 6, 2011
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
Dim numberFile As StreamReader
Dim intCount As Integer
Dim decTotal As Decimal
Dim decAvg As Decimal
[code]....
0 value returns for the Lowest number..everything else returns fine...
View 6 Replies
Jan 9, 2010
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.
[Code]...
View 13 Replies
May 10, 2011
Create a program where the user can find the highest number and the smallest number from a list of values It needs to operate as follows: Enter a value (number) in the TextBox and click on a button [Add to list]. Once this is done, the program analyzes if the number is the highest entered or the smallest. To view which is the smallest and largest, a second button [highest and lowest] will populate fields (texboxes) with highest and lowest numbers. I've attached an image of what the program should look like.
View 4 Replies
May 17, 2011
i think i have a similar problem with this post..
[Code]...
View 3 Replies
May 15, 2011
Are there any good free alternatives to DevExpress data grids (WinForms)?I am looking for WinForms Data Grid and Data Editor Controls.
View 1 Replies
May 15, 2009
I will have a directory of files (IFO, BUP, and VOB; DVD files for anyone who cares), I need to find the first one by sorting these like this: Filter out everything that does not have a .VOB in it, then find the one like this VTS_**_1.VOB. It will always have a "1" before the extension, but the two numbers before that change, lastly I need that file returned as a variable.
View 4 Replies
Jun 5, 2009
Is there a better way of finding the path of a file that was opened with the open file dialogue? This is what I did. It works, but it seems like there should be a way to get the path through one of the open dialogue options.
Code:
'm_PicSource = OpenFileDialog1.FileName
'm_PicSource is a global var
Dim strCnt As Integer = m_PicSource.Length - 1
[Code].....
View 6 Replies
Mar 23, 2012
I am having a little trouble with the folowing code. I made it so that it searches column "U" in the excel spreadsheet and for bcode that is input into a text box. The code runs perfectly the first time it runs but if i try to search a second time it gives me this error " Exception from HRESULT: 0x800A01A8"
Here is the
Dim Shape As String
Dim bcode2 As String
Dim Size As String
[code]....
View 2 Replies
Jun 16, 2009
I have a program that allows the user to enter a drive letter into a text box. The program then takes the letter and find the physical drive number (i.e. deviceharddisk3..). It then stripes out everything and leaves me with the number 3.
In VB6 I used mDrive.bas from vbAccelerator.com and it worked perfectly. I have been all over the internet and back and cannot find a solution written in VB.NET.
View 14 Replies
May 9, 2009
[wink]You'll notice i dim'd n as integer = 0...[/wink] hehe I need a bit of advice on how to find the largest number stored as data in an array. For example vote(0) = 6, and vote(3) = 12, and lets assume all the other vote(n) are less. How do I pick out the big one?
[Code]...
View 8 Replies
Oct 15, 2009
I'm connected to an access database using VB 2008.. there is information already located in the tables. But what I am looking to do, is find the "SUM" of all the data in a certain column.
View 35 Replies
Jan 4, 2010
Table Employees has data as follows
sno----name
1------Eric
2------Boris
3------Bill
Whien I enter "B" in text5 and run following codes then it show error message as IndexOutOfRangeException was unhandeledThere is no row at position 0I have two question
1) Why it does not select name begins with "B"
2) If it has no row then why it does not exit sub.
str = "select sno,name from employees "
str &= "where Name Like '" & (TextBox5.Text) & "%'"
cmd2 = New SqlClient.SqlCommand(str, con)
da2 = New SqlClient.SqlDataAdapter(cmd2)
[code].....
View 1 Replies
Feb 27, 2011
how to find the row position/index in a data table, using a value from another table. For example, I use the row position from Linkingtable1 to get my value for CustomerID, but i want to use the CustomerID to search the CustomerTable for its row position, in order to show the Customers Name in a text box, As currently when loading the textbox shows the customerID. I understand the code to get the names from the rows in the datatable, its just finding the row position of the customerID.
View 9 Replies
