I need to summarize data from an arraylist in vb. For example, I have a list of dates with different times. I want to summarize the dates and be able to display the times when I click on each date.I am new to vb, and I am struggling with this. I am able to read the file(ofd) with this info but I can't get it summarize, instead I am showing the date multiple times.
View 3 Replies
I've got a datatable not attached to the database. It contains essentially raw data. I want to take that raw data and then process it more by running a select statement that includes a couple of sums and group by phrase.However, I can't figure out how to run a select statement on a datatable that is already in RAM. I created Table 1 and massaged it by adding some more columns after pulling the original data. There will be more in the final SQL Statement but I can't get this to work.
Table 1 (works fine)
Customer, InvDate, Amount
Contains multiple records for the same customer.[code].....
This table should only be one record per customer showing total amount of all invoices.I've been searching the internet for a couple of days but no luck so far.
Let say I have an array of data. In this array, It has 4 Columns, represented as:
Column 1 = Customer #
Column 2 = Customer Name
Column 3 = Past Order #
Column 4 = Past Order Amount
Each Row in the Array represents a past order, so the array has no known upper limit. End result is that I need to report in my VB app, the number of Unique Customers, and by that Customer, summarize the number of orders, and the total amount of those orders.
I am looking to produce an Excel report from an Access database table. The data contains numerous records with fields for Site, Country, Region, Type and a Resolution Time. My problem is that each month the Sites change so I need to be able to write VB code within Access to read the database table and output 'Site' records for that month, grouped together along with the incident details for that site, e.g. The report would have the following headings:
'SITE' 'COUNTRY' 'REGION' 'TYPE' 'TOTAL' 'RESOLVED<3DAYS' 'RESOLVED>3DAYS' 'NOT RESOLVED'
MEL AUS APAC TECHNICAL 78 40 31 7
MEL AUS APAC HARDWARE 49 40 8 1
LON GBR EURO HARDWARE 90 40 40 10
As I will have over 30 different sites and these may change each month how do I loop through the data identifying each site and its associated field values? I have used the following code to open the data and loop through records printing to excel, but am stuck at grouping by site:
Set rst = db.OpenRecordset(sqlStat)
row=10.......
..... Do While Not rst.EOF
.cells(row, 1).Value = rst.Fields(0)
.cells(row, 1).Value = rst.Fields(1)
.cells(row, 1).Value = rst.Fields(2)...
I have a bound datagridview in my code. I want to create a column to the right of each row that displays the sum of the values in the row.I've searched the net dilligently and have found nothing! Summarizing the columns is there, but not a row.
Oct Nov Dec Total
100 100 100 300
150 150 100 400
Etc....
Been trying to figure out how to do this for a while, but I can't seem to find anything that exactly covers what I'm trying to do. I'm really a novice when it comes to vb .net, so this might be staring me in the face and I wouldn't know it.I've got a Motorola MC3090 mobile barcode scanner running Windows CE 5.0 at work. I wrote a small program (in .net 3.5) that allows me to scan barcodes and then get counts for specific barcodes when I type all or part of the barcode into an textbox. That works pretty well for receiving, but I need something that works better for the reverse process (shipping things out).
I have an textbox which accepts the barcodes. When the scanner emulates an enter key press, it adds the code to a listbox and clears the input field. This process loops as many times as my quantity field specifies. There's another textbox which I use to input partial barcodes that I want counts for. It looks for strings in the listbox that match, dumps them into a second hidden listbox, and counts those.
If you're the tl;dr type, here's the short of what I want to do with all of the above. I want to take the contents of the visible listbox, summarize by listing each unique barcode, and have a count of how many of each unique barcode appears in the listbox.
What I am doing is iterating through all the groups that belong to the top group (Generic reports). Then I take advantage of the GroupPrincipal.GetMembers(True) which will recurse through a given group name. I test to see if the user exits under that group and if true I put the group name in an arraylist.
I use the for each principal in GroupPrincipal.GetMembers to loop through each returned user to see if they exist.
Is there a way to put all the returned users Principal.Name from a given group in GroupPrincipal.GetMembers into an ArrayList? This would allow me to to use Arraylist1.IndexOf to search for user. Which would be much faster then iterating through a returned list using the for each construct.
Sub RetAllMbrs(strUser As String)
Dim oPC As PrincipalContext = GetPrincipalContext() '<- this is function somewhere else in the code
[Code].....
I have a problem in Treading.I have a code like this;[code].....
I want to change ListBox1 with ArrayList. But I couldn't find how to use adding a string to ArrayList in tread.
I want to summarize this code because it is too long:
[code]...
I have an integer array with 4 indexes. What is the easiest way to get the sum of all integers in the array.
View 5 Repliesi am a student i have an assignment in a class in which i am totally lost PLEASE HELP
1) Code the necessary instructions for the ADD button which is instantiating an object and adding to a collectioni
2) Code the necessary instrutions for the DEL button
3) Code the rest of the SAVE button to allow us to continue to edit and save the customers.[code]
How can I read data from a .csv file I have opened into a variable for later use (i.e. plotting with zedgraph)? My csv file contains 100+ columns and 12000+ rows of data, with each column a different variable.
I've searched around a ton on this subject, and combined many methods I found on the net to my project but none actually do what I am required to do.
I am trying to retrieve the correct value from an ArrayList of objects (.NET 1.1 Framework):I have the following defined:
Public AlList As New ArrayList
Public Class ItemInfo
Public ItemNo As Int16
[code].....
i'm trying to retrieve data from a nested arraylist and am unsuccessful.
View 2 RepliesIn my datatable I have a single column containing a series of integer values. eg:-
1
2
3
1
2
2
2, etc
I am looking to do an equivalent of the following SQL statement :-
Select Value, Count(Value) as Total
From DataTable
Group By Value
Order by Value ASC
I'm looking to return the following from the above example :-
Value Total
1 2
2 4
3 1
I have an arraylist (arrFirstArry) which I use to populate another arraylist (arrNoDuplicates) preventing any duplicates from being added. This works fine. What I would also like my code to do is prevent adding any partial values which may exist from being added. i.e. my array is like this
[Code]...
I have two structures Public Structure myResearchData
Public batchName As String
Public arraylistRData As ArrayList
End Structure
Public Structure myResearchSubData
Public researchDescription As String
[Code]...
Cleared MyResearchData.arraylistRData for new data to be put in but it also clears the arraylist inside MyResearchDataAList and didn't old the contents of the arraylist
What I need to do is read an ArrayList in My.Settings and add another ArrayList to it. The first think I'm trying to do is load My.Settings.Records into myArrayList. I'm not quite sure on the proper way to do this. I've tried things such as Dim myArrayList As ArrayList = My.Settings.Records, I'm not sure if I need New and I'm not sure if I need .Clone or .CopyTo.
Then I have another ArrayList myArrayList2. To get this into myArrayList I've done: [Code] Then to save it back to My.Settings I've done. My.Settings.Records = myArrayList. The problem is I keep on getting Object reference not set to an instance of an object error on the AddRange line. My.Settings.Records is definitely an ArrayList and it will sometimes = Nothing. The objects will only ever be strings.
I have following data in the arraylist..
HTML
ID Type Size
1 Car 1 1000
2 Car 2 1100
3 Car 3 1200
[Code]...
Is it possible to transfer all row data stored in datatable to arraylist without using a loop ?
View 12 RepliesI am struggling with a simple datatable issue. The following takes a data table that is on the form and adds an arraylist to it as the data source. The data that shows up in the datatable is the length of the value of the element in the arrayList.
test.Add("cjdsnthegtrk")
test.Add("cjdsk")
test.Add("cjdsk")[code]....
How do I control what is displayed in the columns? What I am ultimately trying to do is have a datatable that the operator can edit and the changes reflect in the underlying data structure.
[code] I'm trying to load a textfile with (formatted, mostly tab delimited) data, into an arrayList.To manipulate and extract certain data I was able to search through the arrayList and retrieve the needed data.This is what's not working: If I have found my needed data in certain places from the arrayList, I would like to split this to read the needed values. Trying to do this I constantly get string cannot be converted to 1-dimensional array of string errors. [code]
View 4 RepliesI want to have multiple threads input data into the same arraylist, so they would need to share it. If this is possible how can I do this task?
View 1 RepliesMy application reuses the same data returned from the database throughout the application. For example, a list of airport codes retrieved from the dataabase could be used on 5 different forms. In VB6 I placed the information into a Public Array. I'm looking for the best way to load and make available without hitting the database 5 times. After researching I found arraylist might be the way to go. My problem...I'm not sure I'm doing this correctly and not sure how to make the call to get the data out of the list.
[Code]...
I am trying to split an array into a jagged array for easy manipulation, but I am having a bit of trouble with the Copy method of Array.This is what I have:
Dim masterData()() As String = New String(splitCounter.Count - 1)() {}
For i As Integer = splitCounter(0) To splitCounter.LastIndexOf(splitCounter)
Array.Copy(ServerResponse, splitCounter(i), masterData(i) = New String(), i, splitCounter(i
[code]....
I want to create an array of an array (or arraylist of an arraylist) to hold strings.I want to fill an array1 with string values Then add this array to array2. - but only taking up 1 row in array2 e.g something like array2(index)=array1 Then clear array1 then loop through this again with different data, and add it to the array2.so will end up with something like
array2(0)... contains a collection of array1 data
array2(1)... contains a collection of different array1 data
.. and so on
i think i need to make new instances of array1 each loop, but not sure.I dont mind if it uses arrays, or arraylists, or lists, or structure of arrayslists?
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
s there a difference between the arraylist in visual basic and arraylist in C#? I had to convert some C# code to VB and there is a call I make in a third party api that requires me to pass in an arraylist. When I do this in C# it works just fine, but when I do this in VB, I just get back a vaque exception from the api.
[Code]...
The exception I get is very vague and comes from the API. All i get is, "ARException Occured".
I am trying to make a little program for fun and I don't know OOP that well. Since this part of the program is going to be large in comparison to everything else, I want to make sure I don't half ass it.
I need,
50 states
each state having multiple schools
each school having multiple players
and each school having 1-4 coaches who may or may not have awards
I only posted a couple classes since I should be able to figure the rest out off of these two. The award class properties will be changed later. How do I make a new coach that has x awards? I am confused with this part. If I did not explain something clearly please let me know, I want to make sure I get this program started off the right way.
Public Class Coach
Public Sub Main()
Dim coach As ArrayList = New ArrayList
' coach.Add(New Coach(1, "Billy", "Bob", 0, 50, ???))
End Sub
[CODE]...
I'm having some trouble adding an object to an arraylist.
Basically the object has two properties (file id/name), but I can't figure out how to assign those properties. During runtime it errors out with public member on the object not found.
Private QueueList As New ArrayList
Public Sub Queue(ByVal FileName As String, ByVal FileID As Integer)
Dim QueueObj As New Object
[Code]....
I'd also like to know how I can do a loop on the arraylist and access the two properites on each record.
