Count - Dictionary Obtain Keys Grouped
Jun 9, 2012
I have this dictionary..
Dim Rooms As New Dictionary(Of Integer, Of Integer)
Rooms(1) = 101, 102, 109, 110
Rooms(2) = 103, 104, 105
Rooms(3) = 106, 107
I want to know if I can obtain how many keys are in the dictionary. For example, in this dictionary i have 3 keys, and if I use Rooms.Count it returns me 9 that's each pair of keys-values, but I want to obtain 3, each different value as key. Syntax error. I cant use now because I have to use in a webservice filtered by IP, but VS2010 if I use count on the dictionary, tells me that will contain the number of the keys/value pairs.
View 3 Replies
ADVERTISEMENT
Aug 3, 2009
I have this dictionary..
Dim Rooms As New Dictionary(Of Integer, Of Integer)
Rooms(1) = 101, 102, 109, 110
Rooms(2) = 103, 104, 105
Rooms(3) = 106, 107
I want to know if i can obtain how many keys are in the dictionary For example, in this dictionary i have 3 keys, and if i use Rooms.Count it returns me 9 thats each pair of keys-values, but i want to obtain 3, each diferent value as key.
EDIT: Sintax error P.D: I cant use now because i have to use in a webservice filtered by IP, but VS2010 if i use count on the dictionary, tells me that will contain the number of the keys/value pairs.
View 1 Replies
Nov 10, 2010
I have the following dictionary:
Dim idQueuedJobs As IDictionary(Of Int32, KeyValuePair(Of String, Int32)) = New Dictionary(Of Int32, KeyValuePair(Of String, Int32))
Why duplicate KeyValue pair? This is because the first Int32 is just a normal index, and the String followed by another Int32 contains systemnames and the priority of the qued job in idQueuedJobs
I want to calculate the total number of systemnames in idQueuedJobs, how can i obtain this count by using the groupby method?
Something like this maybe?
numberOfSystems As Int32 = idQueuedJobs.Values.GroupBy(...)
View 1 Replies
Sep 22, 2010
Very easy today, I think. In C#, its:
Dictionary<String, String> dict = new Dictionary<string, string>() { { "", "" } };
But in vb, the following doesn't work.
Public dict As Dictionary(Of String, String) = New Dictionary(Of String, String) (("",""))
I'm pretty sure there's a way to add them at declaration, but I'm not sure how. And yes, I want to add them at declaration, not any other time. :)
I've also tried:
Public dict As Dictionary(Of String, String) = New Dictionary(Of String, String) ({"",""})
And...
Public dict As Dictionary(Of String, String) = New Dictionary(Of String, String) {("","")}
And...
Public dict As Dictionary(Of String, String) = New Dictionary(Of String, String) {{"",""}}
View 3 Replies
May 31, 2011
I have a dictionary(of someType, someOtherType) (the types are immaterial). With a given value, I need to find all the keys that have that value in the dictionary. What I am currently doing is this:
Dim foundList as New List(of someType)
For each key as someType in myDictionary.Keys
If myDictionary(key) = givenValue Then
[code]....
View 10 Replies
Oct 7, 2010
I have a dictionary with the keys being integer and the values being string. I was wondering how can I sort the dictionary in DESCENDING order using its keys.
View 6 Replies
May 31, 2012
I have a case insensitive dictionary in asp.net/vb.net like this:
Dim caseInsensitiveDictionary = New Dictionary(Of String, Single)(StringComparer.OrdinalIgnoreCase)
it holds values like this
[code].....
View 2 Replies
Apr 2, 2010
Is there any reason to favor one of these approaches over the other when inserting into a generic dictionary with the possibility of a key conflict? I'm building an in-memory version of a static collection so in the case of a conflict it doesn't matter whether the old or new value is used.
If Not mySettings.ContainsKey(key) Then
mySettings.Add(key, Value)
End If
[code].....
View 4 Replies
Apr 25, 2009
I have a VB.NET project where I am able to iterate through the keys and values collections of a dictionary object using an index:
MyDictionary.Keys(idx)
MyDictionary.Values(idx)
When this code is taken from the test project and placed into the real project I get the following error:
'System.Collections.Generic.Dictionary(Of Double, String).KeyCollection' cannot be indexed because it has no default property.[code]...
In the line in sub search that says "dtf.Keys(idx) = 0" place your cursor after the right parenthesis and backspace you should get a tooltip that says, "<Extension> ElementAtOrDefault(index as Integer) as Double - index: the zero based element of the index to retrieve.
View 3 Replies
Nov 18, 2009
I have a generic dictonary which is templated in the following manner:
[code...]
If I wanted to omit certain list items against arbitrary keys (that is the items that are in the list contained within the value part of each of the key value pairs making up the dictionary) given some arbitrary condition (lets say omitting list items where a list item contained the string "abc")
I would expect to able to create/project into a new dictionary which would contain entries which contained lists WITHOUT those items whose name contained "abc"
How do I achieve this using a Lambda expression?
I was trying something like this:
[code..]
View 2 Replies
Feb 24, 2012
How can i count keys pressed within ex. 1 min? Or how do i count a spesific key?
View 1 Replies
Nov 10, 2009
Im making an key counter and ive got the program to count all keys at the time, i just can't count mouse buttons, i would really like to have help with this, if any of you wanna help im online at my own IRC chat. [URL]..
View 2 Replies
Oct 21, 2008
I have a problem detecting whether one of the arrow keys is pressed, all the other keys seem to be detected apart from the arrow keys??? I have set key preview to True........ It detects the arrrow keys BUT ONLY if I have NO other controls on the form??? example..
Me.Text = e.keycode
It works, but then if I add a button for example, it stops.
View 3 Replies
Jan 25, 2010
I want to group items from a linq query under a header, so that for each header I have a list of objects that match the header title. I assumed the solution would be to use ToDictionary to convert the objects, but this allows only one object per "group" (or dictionary key). I assumed I could create the dictionary of type (String, List Of()), but I can't figure out how to write it. As an example I have written a simplified version below.
[Code]...
View 2 Replies
Apr 27, 2009
I have created a class with a function in it. I have a collection of data I want to pass back. I tried an arraylist first. Now I am trying to use a dictionary. My problem is that it creates the dictionary ok, but I am only get the last row of data from my
Function GetWeldAuditInfo(ByVal ResourceId
As
String,
ByVal VendorId
[CODE].........................
View 2 Replies
Apr 16, 2012
I have the following object:
countDictionary As Dictionary(of Category, Dictionary(of Date, Integer))
The Class has a Enumeration Property. For the purposes of demonstration, I'll call it MasterCategory.I have been trying to get out an object that looks like the following:
groupedCountDictionary As Dictionary(of MasterCategory, Dictionary(of Date, Integer)
The best result I could get was:
Lookup(of MasterCategory, Dictionary(of Date, Integer))
From:
countDictionary.ToLookup(Function(o) o.Key.MasterCategory, Function(o) o.Value)
Which results in a IEnumerable (Of Dictionary(of Date, Integer)) for each MasterCategory value.However, I need that IEnumerable of Dictionary flattened to one dictionary with all the integers summed (total counts) for each date. I then tried to use various selects and group bys (from numerous stackoverflow posts) to "flatten" it, but my efforts have fallen short.
Current Code
[Category Class]
- MasterCategory As Enum
- Name As String etc
[code]....
View 1 Replies
Dec 16, 2011
I have a list of postcodes in a query (ThisInstructorsPostcodes) and another query that pulls back sales referrals (LastWeeksReferrals)I am using the below syntax to perform the linq equivalent of LEFT OUTER JOIN so I always get a postcode back, even if there were no referrals for it.
dim final = from tip in ThisInstructorsPostcodes _
group join lwr in LastWeeksReferrals on tip.PostcodeID equals lwr.PostcodeID Into lwrgrp = group _
from lwrgrpq in lwrgrp.DefaultIfEmpty _[code].....
The results I am getting are so close to what I need, but I am getting a bunch of InstructorReferrals objects in the lwrgrpq column and what I want to do is simple sum of the all the 'Referrals' integers in those InstructorReferrals objects.I thought this would work:
dim final = from tip in ThisInstructorsPostcodes _
group join lwr in LastWeeksReferrals on tip.PostcodeID equals lwr.PostcodeID Into lwrgrp = group _
from lwrgrpq in lwrgrp.DefaultIfEmpty _
select new with {tip.AreaDistrict, lwrgrpq.Sum(function(x) x.Referrals) }
...but it doesn't - fails with the error: Anonymous type member name can be inferred only from a simple or qualified name with no arguments.I have only used this linq query structure in order to mimic the outer join behaviour of sql, does anyone know how I can fix this so that my grouped items are not anonymous types?
View 1 Replies
Jul 7, 2010
I have created a Dictionary class (MyDictionary for the example). I am currently trying to pass MyDictionary into a function, filter it into a new instance of MyDictionary and pass this new instance into another method. When I am attempting to create the second instance from the filtered first instance of MyDictionary via Lambda Expressions and the ToDictionary Method, I am getting the following error:
Unable to cast object of type 'System.Collections.Generic.Dictionary`2[System.Int32,System.String]' to type 'MyDictionary'. I have simplified the example and recreated it in LINQPad and am getting the same error.
Here's the simplified version of my code:
[Code]...
View 2 Replies
Sep 23, 2009
I have a simple VB.NET 2008 app that users to edit fields in the database. Simple enough as a first "real" project in .NET, right?For one table, I am currently using a DataGridView so it can be edited straight up. However, instead of offering the user the entire table, I'd like to group the data by the 'CompanyNumber' column and use a navigator to page through. In other words, I'd like the DataGridView to show me all the lines related to one company, then click the "next" arrow to show the next company, etc.
View 2 Replies
Apr 19, 2010
I'm having trouble with a LINQ to SQL query getting the min value using Visual Basic. Here's the SQL:
SELECT RC.AssetID, MIN(RC.RecCode) AS RecCode, JA.EngineerNote from JobAssetRecCode RC
JOIN JobAssets JA ON JA.AssetID = RC.AssetID AND JA.JobID = RC.JobID
WHERE RC.InspState = 2 AND RC.RecCode > 0
[code]....
View 1 Replies
Feb 23, 2012
I'm trying to create a program that displays a calculation based on which radio buttons a user clicks on. I'm not getting any errors during writing or run-time, however only one particular calculation ever gets displayed. I'm not sure why, but it's as if I've gotten the program stuck on the section below. The Calories Label only displays the number 12 regardless of anything else being enabled.
weight = Val(WeightTextBox.Text)
activemale = weight * 15
inactivemale = weight * 13
[Code].....
View 2 Replies
Jan 6, 2011
I use VS2005 and I have just started working with the dictionary in particular the Dictionary.ContainsKey method. At the bottom of the page in the msdn library it says the following in the community content How to make sure that Contains functions properly.
View 3 Replies
Jun 25, 2011
just wondering how i could give my auto typer hot keys, for example they press f1 to start the typer f2 to stop it.
[Code]...
View 4 Replies
Mar 25, 2011
I'm trying to create a shortcut which expands or collapses my treeview using the ctrl+alt+up-arrow or ctrl+alt+down-arrow:
If Keys.ControlKey And e.KeyCode = Keys.Alt And e.KeyCode = Keys.Down Then
mytreeview.ExpandAll()
End If
[code].....
View 2 Replies
Nov 13, 2010
I have 2 tables Markers and Clients. Within the Marketers table i have Team Leaders as well. I want to print a report that will display a Team Leader and the Marketer with all the Clients for that particular Marketer, and then do that for all the Marketers under that Team Leader.
[Code]...
View 2 Replies
Oct 11, 2011
I need to sort my records by date (month & year) as displayed on my asp.net page; This is the code I currently have
<table width="40%" border="0" style="margin-left:auto; margin-right:auto;">
<tr><td><asp:Label ID="lblGridHeader" CssClass="TextFont" Text="" runat="server"></asp:Label></td></tr>
<tr>
[code]....
View 2 Replies
Apr 16, 2012
Given a simple DTO (AccountExpiry) with properties of 'AccountNo' and 'ExpiryDate' and a List of same created thus:
New AccountExpiry(123, New Date(2012, 4, 1))
New AccountExpiry(123, New Date(2012, 4, 2))
New AccountExpiry(123, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 2))
New AccountExpiry(124, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 4))
How do I use LINQ to retrieve the most recent entry per account. I have a feeling this will involve GroupBy and FirstOrDefault. It seems like...
From Item In Source Group By Item.AccountNo Into Group
Should return all of the data grouped appropriately, but It is unclear how I might apply .FirstOrDefault to each group.
View 1 Replies
Mar 29, 2010
I'm trying to do the following LINQ grouping, which works in the debugger (the results are populated in the GroupedOrders object. But VS 2008 gives me the following error at design time...
Name 'x' is not declared
Dim GroupedOrders = (From m In thisConsultant.orders _
Group m By Key = m.commCode Into Group _
[code]....
View 3 Replies
Jan 25, 2012
I found out how to keep track of the currently expanded grouped rows by using 2 events:
- gridview.GroupRowExpanded
- gridview.GroupRowCollapsed
Where I increase or decrement an integer that keeps track of how many group rows are currently expanded. I am now tackling the problem of what to do if the user expands or collapses all of the group rows. I currently know when this is done by checking the e.RowHandle. Any way to find the total number of groups rows currently in the GridView (something like rowcount for normal rows) so I know how many to set the tracking integer to.
For Example: If my current count is 2 and the total number of groups are 15 then when the Expand All is fired the current count is set to 15 rather than 3.
View 1 Replies
Jan 13, 2011
How could I loop through a list of the keys that are available in the 'Keys' enumeration? It seems like it should be something easy to do, but I'm not having any luck finding a collection that I can loop through.
View 6 Replies
