I'm performing some statistics on a txt file that has multiple columns using a collection list (vb.net 2008). My files can contain 100,000+ samples per file. How would I code my function to have it perform work on the first 3000 samples and continue the calculations on every 3000 samples thereafter?
Private Sub decimationButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles decimationButton.Click
Dim lines() As String = System.IO.File.ReadAllLines(inputFileName) '("TEXT_FILE")
Dim list As New List(Of Double())
Ever since I started using VB.Net I have been using the Generic List collection List(Of <Type>). Arrays, I haven't used so much. I used them a lot more when I wrote C code years ago.
1.) Are arrays considered a type of collection like Lists, Dictionary, Queue etc are? Or are they in their own category.
2.) Can I iterate over an array with a For Each loop like I can with other collections or do I stick with the normal For loop for arrays?
3.) There are certain methods that return arrays. Can I set a list object to hold this return value instead of an array?
Is there a list or a way to get one of the lists in VB.Net to work like the ones in CDBurnerXP?I shows a small icon at the side, then has a title and a little description under that.Have designed a program around this style of list but now when i have came to .net to write it...
In Key Press Event i have put the logic of search in textbox, when i press enter key it will take the values from textbox and brings the data in DataGrid.In another event of GotFocus there is an logic of autocompletestring collection from Table. If i type a in that textbox it will shows all the suggested string in that.
If i comment the logic of GotFocus Event for textbox for autocomplete suggestion then only then Key Press events work else its not working. I dont know why its happening.
In Key Press Event i have put the logic of search in textbox, when i press enter key it will take the values from textbox and brings the data in DataGrid.In another event of GotFocus there is an logic of autocompletestring collection from Table. If i type a in that textbox it will shows all the suggested string in that.If i comment the logic of GotFocus Event for textbox for autocomplete suggestion then only then Key Press events work else its not working.
Code: Private Sub CustomerName_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles CustomerName.KeyPress If e.KeyChar = Chr(13) Then
I am experimenting with a transition from my application built in VB6 to vb.net. I know, about time. At the same time, i am making changes and improving upon the original. One area that I am working on is within my employee class. very standard class, nothing fancy. One change I want to make though is allow for an employee to be assigned more than one work location. Employee has (is assigned) Stores. In reading about collections, it appears they are different in .net (as they should be), but I don't know what the sytax changes will be to implement my changes.
I have two lists. One list is a list of names, the other list is a list of how many times each name is found in the first list noted in the database
so... Nick John Jim Jack
is the firs tlist
10 13 13 2
is the second list. Nick had 10, john 13 and so on.I want to sort the second list from large to small, but have the index for the first list still linked to the correct amount of calls.i do it this way so I can
for x = 0 to num_of_names string = lst_name(x) & "-" & lst_count(x) next x
I know how to check whether an item exists in a list using (MyList.Contains), But I do not know how to check the whole list. For example (use one button and one richtextbox):
how to display the ranges here is the assinment Your homework assignment will create a project that uses an array to store the sales figures for 20 employees at a computer store. Declare a 20-element one-dimensional array named Sales .
I am creating a program that takes into account pay from a job. I will try to describe the problem I am having using some psuedo code - so dont take syntax too seriously.
I created a structure that has some of the following values: Name as String Amount as Double FrequencyType as MyEnumerator
Now my problem is how do I add the date ranges into my structure?If your pay is weekly or twice a week, then I just need a single date because all other paydays should increment in 1 or 2 week blocks. But if the pay is twice a month I need two dates. It seems like there has got to be a better way then just having two dates in my structure and knowing that you just need the 2nd date if the FrequencyType is = 2 (TwiceAMonth).I was thinking that instead of a Structure I should use a class and then I could create a function that returns the date or dates depending on the enumeration type that you pass into it.What would be the "correct" way of doing this? I think I need a type of enumerator that allows for more then just integer type values.
I am developing a billing application to help out the billing lady who has been doing our billing by hand. I am essentially done�. Except for one class of customer I can�t wrap my head around. Nuts and Bolts:
1.Data comes from a table that shows Storage id, customer id, Billing Start date, Billing end date.
2.I am kicking the data back out to a table and I�ll build her a nice little crystal she can run.
Problem:We rent storage space. If multiple customers use the same storage then they will split the cost of the daily fee. If there is 3 customers they each pay a third etc. This seems simple but If Customer 1 starts on 1/1/12 and ends 1/10/12 she pays 10 days. If Customer 2 comes in 1/3/12-1/9/12 they will split 7 days. If Customer 3 comes in only on 1/9/12 then they will all pay a third on that day. Now imagine this across 600+ storage units and 1000+ customers and each customer using multiple storage at any given time.
My biggest issue is I don�t know how to express how we do that calculation by hand programmatically. By hand process and how I figure I am eating the elephant: Find every Customer that has used the Space in the billing period -Determine the unique storage numbers that were used during the billing cycle kick the results to a storage table on an access database. I am using a table because I figured it would be less of burden for the application then a list or array.
Determine where there is overlap - Use �FOR� to cycle through the orginal data table using the unigue. Here is where I am stuck. How do I compare the dates in a way to determine which customer is using it when compared to the others. Obviously i can determine the difference in dates between the start and end. It is getting the applicaiton to recognize the dates are with in the other dates. here is kind of what I was thinking obviosly this doesn't work I am just using the format so don't crush me too bad because I code like a caveman.
Dim CustomerDifference as time span Dim UniqueStorage as Integer Dim Customer as string
I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel *and* define the Range using numbers.Alright, so I have objects being created depending on the file that the user opens. So there could be 100 objects or there could be none. Now each object has an array of values, and these arrays contain nearly 15000 elements. So here is what I want to do but I can't figure out how to escape using the LetterNumber:LetterNumber combination.
For every object I want a new column to be occupied and for every element in the objects array I want the row to be occupied. I figured the easiest way to do this was using a for loop but, again, I can't use numbers.
For columns = 0 to NumberOfObjects For rows = 0 to NumberInArray Cell(0,0).Value = myObjectsCollection(column).Array(rows) Next Next
I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel and define the Range using numbers.
Alright, so I have objects being created depending on the file that the user opens. So there could be 100 objects or there could be none. Now each object has an array of values, and these arrays contain nearly 15000 elements. So here is what I want to do but I can't figure out how to escape using the LetterNumber:LetterNumber combination.
For every object I want a new column to be occupied and for every element in the objects array I want the row to be occupied. I figured the easiest way to do this was using a for loop but, again, I can't use numbers.
For columns = 0 to NumberOfObjects For rows = 0 to NumberInArray Cell(rows , columns).Value = myObjectsCollection(column).Array(rows) Next Next
What's up guys. Simple question today. How do you specify ranges of values for location? Basically i'm trying to write an if statement that will execute if a location matches a range of values, here is th snippet of my code im having trouble with:
If Player.Location = New Point(0 To 240, 240) Then code here
But that didn't work at all, there was no error, but the code just wouldn't execute when the "player" was in that range!
I am trying to make a program, where a user will input 'ranges' in a richtextbox, and then enter a value, which will be stored/categorized (in an array maybe) according to the 'range'.What I exactly mean is:
User specifies ranges by inputting this line in the richtextbox: <,10,20,30,> First range = < to 10 (no minimum boundary up to 10), second range = 10 to 20 , 3rd = 20 to 30 , 4th = 30 to > (30 to no maximum boundary) Then a user enters a number. For example "-1" would fall in the "< to 10" category, "23" in the "20 to 30" category, "125" in the "30 to >" category. I know there are other ways to do this, but I would like to see a solution (or some guidance) based on these requirements.
How to get the first row index of a named range in excel sheet from vb.net code...for example I set the column 1 of row 2 to column 5 of row 4 a range named it "MYRange" ( it is set from excel sheet )
I'm working on pasting arrays into excel ranges. Suppose I have a range: A1:A5 and an array a = {1,2,3,4,5}. I can set up the problem like this:[code]So, I got curious about the Transpose method, and whether I could construct my array properly so that I didn't need it. I found that Transpose converts my array into a 2d 1-based array (so the first element is (1,1) not (0,0) as usual).Now I'd like to know: Is there a standard VB-way other than the worksheet transpose function that I can use to build a 1-based 2D array the way Transpose does?
The following code is excerpted from a larger procedure (the surrounding code is not relevant). why I am unable to get the second ContainsKey line to return True? Hint: try this on a worksheet with just a few populated cells to reduce looping.
For Each ws As Excel.Worksheet In Wb.Worksheets Dim dic As New Dictionary(Of Excel.Range, String) rngUsed = ws.UsedRange
I have a variable called hour that will be used to display different text in a textbox based on what time it is. Basically, if the time falls between 12am and 3am, hour = 0, if the time is between 3am and 6am, the hour is 1, etc, breaking the day into 8 'hour's. How would I do this in vb?
This is my first program and have absolutely no training in programming Visual Basic Studio 2008 so forgive me if I have missed something obvious.Form3 contains a StartDate(Date Time Picker1)and EndDate(Date Time Picker2) with a button1 which launches a Form4 containing a report( Microsoft Report Veiwer)
I have been able to generate a report but it gives me everything in the database instead of date range selected.I have tried generating queries,stored procedures and writing additional code but nothing seems to work.( Though I may of but them in the wrong place)
I created an e-mail program in VB2008. I have an excel file with a list of all e-mail addresses and attachments to those e-mail addresses. What I want to do is import thethe e-mail addresses and attachments into my program. I want my program to then take each e-mail address (automatically) and insert them with their attachments into their respectable fields in the program. The primary objective is to insert 200 e-mail addresses and attachments. Each attachement is significant to each e-mail address.
Is it good practice to store sub-collections of item X inside a parent collection of item X for caching 'filter-queries' which are performed on the parent collection? (They won't be used together (as in color AND type).) Or is it also ok to just Loop over the collection and return the correct entities in a temporary collection?
I need to calculate the location of intersections between multiple date ranges, and the number of overlapping intersections. Then I need to show which date/time ranges overlap each of those intersecting sections. It is slightly more complicated than that so I'll do my best to explain by providing an example. I am working in VB.Net, but C# examples are acceptable as well as I work in both.
We have several high risk tasks that involve the same system. Below I have three example jobs named HR1/2/3/4 with start and end date/times.
I have to compare two columns in two different Excel sheets and delete the duplicates. I have come up with several strategies that work, but I am searching for the most efficient way to do this. At first, I was sorting the columns and looping through them in the manner of a sequential update and deleting when the cell values were equal. But I discovered here an article by Mike Rosenblum that explained that it is much more efficient to stick the columns into an array and iterate them from there. So I was able to do that. There was a complication in that once I had deleted a row, then the array and the spreadsheet were out of sync. So I had to compensate by incrementing a variable each time a row was deleted, and subtracting this variable from the array index to calculate the row to be deleted in the spreadsheet.
So now I am wondering whether there is a better strategy. I thought that if I could merely hide the rows to be deleted and then find a way to delete all hidden rows at once after the loop was over, then this would eliminate the problem of the array and the spreadsheet getting out of sync and would make the code easier to understand. I thought of putting the row numbers of the duplicates into another array and deleting the rows after the comparing loop. But this creates the same problem of having to compensate the row numbers in the array.
i am a beginner learning vb.net. I have an excercise to create a form and on clicking the totals buttons it should display the number of employees who have earnt a salary within the ranges below. Now this code works, but i want to substitute the Select Case Statement with a more efficient for..next statment to increment my counter. The code is:
