I have two Lists of custom objects:
List1: Year, Month, ValueA
List2: Year, Month, ValueB
I want to get a third List with a merge between the two:
List3: Year, Month, ValueA, ValueB
Is there any elegant way to perform that in LINQ VB.Net?
Example:
List1:
2010 - 6 - 2
2010 - 7 - 5
[Code].....
I have a program that takes some data from a Dictionary object, runs a batch process on it and then puts the output into a second Dictionary. The issue that I'm having is that the batch process can only handle 1000 records at a time and sometimes the list is larger than that. Right now, I'm looping through the Dictionary, taking records 1 to 1000 and putting them into a Dictionaryof the same type to process, running the batch, looping through the results to add them to the second Dictionaryand then starting the loops again at record 1001.
Is there a more efficient way to do this to pull out the first 1000 records into another Dictionaryand then batch insert the results into the output Dictionary? It seems like the kind of thing there'd be a function for, but I'm not sure how to do it.
Suppose that I have more than one List (L1,L2,L3,L4) of instances of a class [code]Now I want to querry the 4 lists with one call like Dim L= (from P as MyClass in (L1,L2,L3,L4) where p.Datetime> XXXXX order by p.datetime select p).tolist..is it possible to do something like that? I Know that I could do a FOR NEXT loop with each list but i am looking for a way to do this with a single call
View 2 RepliesI have collections of 2 different types - let's call them Cars and Trucks. Both share base class Vehicle, which has property Passengers.I want to merge them into a single collection ordered by that property. E.g., merge Cars and Trucks and order by Passengers.
View 2 RepliesI'm trying to create a LINQ query (or queries) that count the total number of occurences of a combinations of items in one list that exist in a different list. For example, take the following lists:
CartItems DiscountItems
========= =============
AAA AAA
[code]....
The result of the query operation should be 2 since I can find two combinations of AAA and BBB (from DiscountItems) within the contents of CartItems.My thinking in approaching the query is to join the lists together to shorten CartItems to only include items from DiscountItems. The solution would be to find the CartItem in the resulting query that occurs the least amount of times, thus indicating how many combinations of items exist in CartItems.When CartItems is filtered to only the items in DiscountItems, it can be visually displayed like this:
CartItems that get a discount
=============================
AAA BBB <= This combination is eligible for a discount
AAA BBB <= This combination is eligible for a discount
AAA <= Not eligible
Thus, because there are 2 combinations of the discount in the Cart, the result is 2.Here's the query I already have, but it's not working. query results in an enumeration with 100 items, far more than I expected.
Dim query = From cartItem In Cart.CartItems
Group Join discountItem
In DiscountGroup.DiscountItems
[code]....
I accept both C# and VB.NET suggestion, even though I'm writing an app in VB.NET I have two lists of intergers
List1 {1,2,3,5}
List2 {2,4,6,7}
I want to have new List3 {4,6,7} which is composed of elements of List2 that are not in List1. I know I can write a nice For Each loop for this but I want it done in LINQ I've been looking for such methods at Enumerable Methods, but I can't find it.
This question is very similar to a previous question of mine, Use LINQ to count the number of combinations existing in two lists, except with some further twists.
I have a list of CartItems that can receive a discount based on the items specified in the list of DiscountItems. I need to be able to pull out the items in the Cart that can receive a discount and apply the appropriate discount specfied in the DiscountItem. The discount is only applied for each combination that exists. Here's what the two lists might look like to before the discount is applied[code]...
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
Merging Two PDF files OR Merging Two Binary files
View 2 RepliesI 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):
[Code]...
i want to make a program merge 2 .png images, like the layers in Photoshop, if you know what i mean.. cause i want to create a sprite generator in RMVX.
also i want to use .net framework 2.0.
In .net MDI application the menu of child form automatically is merged to the menu of parent form.Is there a way to do similar thing with the tool bars.The concept is to send the toolbar of active child to the parent toolbar stripe
View 1 RepliesI wrote an application which converts .doc files into .pdf. Now I would like to add one more thing: before converting the .doc file, which is selected by the user, I would like to add the content of an other (default) .doc file, which will not be selected by the user but the directory where the file is will be already in the code, in front of the file selected by the user. So after the two files are merged I will have the merged file converted to PDF.
View 6 RepliesI have a Main Table that contains all the distinct values in a DataTable.DataColumn. also have a Child Table that contains distinct values created by the user.I want to merge the Child Table DataRows that match on the Value column with theMain Table DataRows to create the New Table (shown below).I want to preserve the values in the Selected column of the Child Table.Here is my problem, if I use the DataTable.Merge method the DataRow that contains "888" in the Child Table is added to the New Table, but it doesn't contain a RowState = Added, thus I can't filter for added rows to remove them.
View 4 RepliesI have two folders at different locations but with the same name. A file is generated in one of the folders and it is to be copied to the other folder but without overwriting the existing contents in C#.File.Copy overwrites the contents which makes me lose the previous contents. Is it possible to merge the contents in the folder?
View 1 RepliesI have a PDF template with 1 field on it: Barcode I have a CSV with about 800 records all containing 1 field; Barcode I know how to open de Template and assign a value to a field. And how to write a new PDF with the right barcode on it.But my problem is that I want to create 1 PDF with 800 pages.Thus, not 800 seperate PDFï and then merge them into 1 but I would like to write the content of the memory stream into 1 pdf.
View 1 RepliesI have datagridview and it have 10 columns and 1 row. Here i all the cell values are sameSo I need to merge all cells and the value display in first columns. (Horizandal merging)
View 1 RepliesI want to merge the address feild so that instead of it being on 3 lines (like i have saved it), the form shows all of the data in 1 feild.
AT the moment i am saving it as:
Address 1 = ___
Address 2 = ____
Town = ____
ZipCode = _____
At the moment there in seperate feilds. How would i merge them to look like
Address: _____
_____
_____
_____
etc.
I have 2 DataTables in vb.net. Each is populated from it's own stored procedure. Table A contains a project number in the first column. Table B also contains the project number in the first column. Table A could have many records that have the same project number, but Table B will always have just one record in it per project number. I would like to append the data from Table B to every matching record in Table A. How would I do this?
[Code]...
in that for every selection of a single file in the list-box the content in the file is readed and written to a new word created automatically and saved to the same location.i cant able to move all the items for read and write operation.[code]
View 1 RepliesHow do I merge three datatables?
View 17 RepliesI have an access 2007 Database where I store several different "Jobs" such as repair job, data recovery job etc.
At the min I have a form where the user can view a customer's related jobs either by type, or all jobs related to the customer. I'm trying to do this by adding each job type to it's own DataTable, then merging the DataTables into one.
Private Sub rdoShowAllJobs_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rdoShowAllJobs.CheckedChanged
'####################### Procedure Level Constants and Variables ###########################
' Dim dtDataRecoveryJobs As New DataTable
[Code]....
What I want is for the first column, ID, to contain the primary key from each table, but when the code runs it adds each primary key column from the tables to the end of the AllJobs DataTable! Am I trying to do something impossible here or is there a way around this?
here in the below coding the files are merged , but the resulting format is stored as "encoded text" , i need the format to be ".doc" or ".rtf" files
[Code]...
I have a table with following data Fields:
OID, Product, Condition, QTY DATA:
1, Product A, NEW, 60
2, Product A, B, 60
3, Product A, C, 40
4, Product B, NEW, 30
5, Product B, C, 20
I want to write my procedure so that when I execute it, it will return a table as such.
Product Name, NEW, B, C
Product A, 60, 60, 40
Product B, 30, 0, 20 SELECT PRODUCT,(CASE WHEN CONDITION LIKE 'NEW' THEN QTY END) AS NEW, (CASE WHEN CONDITION LIKE 'B' THEN QTY END) AS B, (CASE WHEN CONDITION LIKE 'C' THEN QTY END) AS C
FROM TEST
I got to the point where it will show different quantities in corresponding column but I was unable to merge them into single row.
is it possible that when i retrieve info out from the database and fill it into the datagridview, if the 'ID' column have similar IDs, those of column 'ID' will be merge together?[code]
View 10 RepliesI have two datasets called ds and ds1 that I want to merge into a grid. I get data from the first dataset to display in the grid but the second dataset where I want to display a count I don't get any data from it. I am trying a ds.Merge(ds1). here is the code i have for the sub. What am I doing incorrectly?
[Code]...
I have two one-dimensional arrays filled with dates. I want to join them into one array.
View 3 Repliesi have a number of pitcures im merging together to make one picture.but the problem i have is the background color, the back color is black but i need it tobe white.
Dim Image1 As New Bitmap(PictureBox2.Image)
Dim Image2 As New Bitmap(PictureBox3.Image)
Dim Image3 As New Bitmap(PictureBox5.Image)
[code].....
I lost the code to a program I made quite a while back so I was wondering if any one could help.I have a list box which has file locations loaded into it by the user..After they are loaded they click the merge button and it joins all the files loaded into the listbox into 1 exe..I have this code I upgraded from vb6. I think it is joining the files but only the first one in the list is opening when i run the new exe that is made when they are merged..[code]
View 6 RepliesI want to do several simple tasks. Doing each separately is easy but when I put them together I don't know what to do. For one thing to work all the code must be changed and everything else doesn't work. I want to:
1. Plot a graph of data from a DAQ. I can do this by using a Timer1_tick method and displaying the data on the linegraph as long as the timer is turned on. I've decided to stick with this method of acquisition. I want to acquire data for long periods of time (perhaps 3 hours) so a timer is pretty good. No problems here.
2. Apply a filter to remove noise from the plot dynamically as the data comes in so that I get a smooth curve instead of a jagged graph. I know I can do this with for loops if I'm using an array. But how do I do it since I'm using a timer? Here the problem begins.
3. Log every piece of the filtered data that the timer is getting to be exported to a CSV file. I learned how to do this with do loops but not with a timer or array. But I really need to use the timer this time.
4. Acquire statistics for the data like maximum value, minimum value, and average value dynamically as the data changes. I know how to do this with an array of data after all the data is acquired. But How do I do this with a timer while the data is still being collected?
5. Monitor the data coming in to execute an alarm (Or event, like stopping the acquisition) when the data coming in has plateaued and is constant (eg: The voltage I'm monitoring starts to become constant and becomes one constant value) - Ok I don't know anything about this.
6. Execute a mathematical operation on the data that has been acquired (post acquisition) like finding gradients and such. Basically this means "How do I now manipulate the data I have and where is this data stored?"
7. Know any good free linegraphs with autoscaling?
Here's my starting code that gathers data with a timer. How do I work from here?:
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As
System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Timer1.Enabled = False
[Code].....
