C# - Get A List Of Distinct Items And Their Count?
Jan 6, 2010
I have an object, that has many properties but the only two to worry about are:
myobject.ID which is an int
myobject.Names which is a HashSet
Then I have a List of those objects that looks something similar to this:
List<myobject>
I use Linq to get a some of the data into a repeater, but I'm not sure how to get the list of Names and how often they show up.
Want to use Linq to avoid having to loop through the data.
As my tags should show, this is an ASP.NET solution using C#.
Some clarification:
Lets say I have just three items in my list:
Item 1 has John, Fred, Jack in its names.
Item 2 has John, Fred, Joe in its names.
Item 3 has John in its names.
I am trying to return the following:
John - 3
Fred - 2
Jack - 1
Joe - 1
Also, as a note I am familiar with having to write my own comparer for my object, I'm just missing the 'how to' for the overall solution in my thoughts.
This is something I can easily do in SQL, but I'm pretty new to LINQ and haven't been able to find an answer online.
I need a LINQ query that returns two values; the first a distinct value and the second the count of the first value. This is filtered by a parameter. Here is my table:
I would like to know if there is a way that I can use DISTINCT on one column's values but need to show other columns where the value of the DISTINCT column is equal to another table's column
I would like to select a distinct query based on three fields and display the rest of the fields. For example,
I have firstname, lastname, address, city, state and zip, but I only want to use the distinct on these fields first and last name. However when i use the distinct function I get a distinct on all the selected rows. I just want to distinct firstname and lastname and display the other fields. for example,
Mary Smith New York Mary Smithy New York Mary Smith Maine
I would like the result to be:
Mary Smith New York Mary Smithy New York
I don't care about Mary Smith Maine, because i am only using the distinct for "Mary Smith" firstname and last name and showing the city.
Using Microsoft built-in jquery files, when counting numbers of checked checkbox, the jquery-1.4.2.min.js cannot count the correct result ,however, the version jquery-1.3.2.min.js gives out the correct one, why?
$("#check").click(function () { var nameSports = new Array(); var i = 0; $('input[name=selector]:checked').each(function () { nameSports[i] = jQuery(this).val(); i += 1; }); if (loopCounter != 0) { alert(i); } }); <input type="checkbox" value="1" name="selector"> <input type="checkbox" value="2" name="selector"> <input type="checkbox" value="3" name="selector"> <a id="check">Check Items</a>
I am viewing items returned from a dataset in an Infragistics chart control. My problem is that due to a weak point in the control, I am left looking for a way to manipulate the height of the chart based on the count/number of items returned by the ObjectDataSource(DataSet).
Does anyone one have an existing C# sample they could let me view of accessing the count of records returned within the code-behind of a page that I could then use within a case statement to set the hight of the control?
i have asked myself if there is an easy way to check if a ListBox has a maximum of 5 selected items. There must be at least one and at most 5 items selected.Do i need a CustomValidator with server-side validation?
I am working on a screen where in it has a typical 2 listboxes & 2 buttons(add/remove), so when these buttons are clicked the items have to move from one listbox to another. its all working fine with javascript.but the issue is, I am not able to get the items of the 2nd listbox in the codebehind. I tried with html & asp.net listbox controls. I even tried to access the listbox using Request.Form["ControlName"] - which gives a null value.In the listbox1 the data's are coming from database.The data's choose from listbox1 will be moved to listbox2. And again i have to update this data to one of database table.
I'm designing my own custom control that contains a .NET dropdownlist. What I'm wondering is if it is possible to populate my dropdownlist with listitems placed in a placeholder? For example:
This doesn't work because the DropDownList control only allows ListItems as child controls. But, I want to do something similar to this so when the user includes my control on a page, they can do something like this:
Is it possible to select values from a List, where the items contain in a different list aswell?for example;
[Code]....
What I need are all the items from the first list "Items", where the string contains something from the second list "List".So I need something which returns the first 3 items (which contain the term "Item") from the first list.
I ve a list of string List<string> that have more than 100000 records. Now i want to search a particular string and their occurence it list. Is there is any buit in method that can perform dis job???
List has BinarySearch method but it retrun the index...
can anyone writing efficient algo of searching n counting no Occurrence in List of string
Say I have a table called "Visits", and I want to create a query that counts the visits per day. The way I would accomplish this would be to create a query as such:
SELECT Count(VisitId) as VisitCount, Convert(varchar(32), VisitDateTime, 101) as VisitDate FROM Visits WHERE VisitDateTime BETWEEN '10/1/2010' AND '10/5/2010' GROUP BY VisitDate
The problem I am trying to overcome is that if there were no visits in a given day, that day does not show in my list. For example, if there were 3 visits on the 1st, 2 on the 2nd, none on the 3rd, and 5 on the 4th, my result set would look like:
3, 10/1/2010 2, 10/2/2010 4, 10/4/2010
How can I create my query so that I get all days in the date range listed in the result set regardless of whether the VisitCount is zero?