I want to remove duplicates from this list:
List<Dictionary<string, object>> val = new List<Dictionary<string, object>>();
It does not work if I apply Distinct() in this way:
List<Dictionary<string, object>> result = val.Distinct().ToList<Dictionary<string, object>>()
Update: Problem is now solved. I used the MySQL union command to read table from the database.
I have a Method that returns 4 records like this.
Name: Test1
Year: 2010
Value: $1000
Name: Test2
Year: 2010
Value: $1000
Name: Test3
Year: 2011
Value: $2000
Name: Test4
Year: 2011
Value: $1000
I need a way to get the unique years just ( 2010, 2011) rather than all 4 years, rest of the data could be duplicates.
Here is the method:
public List<TestCosts> GetTestvalues(string testid)
{
List<TestCosts> testlist = Testscores.List(testid);
return testlist;
}
Most of the examples of removing duplicates I saw have a list of one item only but in my case I have 3 items per record and I need to loop through each record, find the duplicate years, remove them and then return the distinct list of years along with the other data.
i have list<player> with duplicates.
i need to create another list<player> from the first list <player> with out any duplicates.
i have these values in my generic list:
Product Name ItemCount Additional Info
Brioche & Jam 2
Almond Croissant 4
Mixed Salad(v) 20 No Onions
Mixed Salad(v) 5
What i am trying to do is group the duplicates so now the list would look like this:
Product Name ItemCount Additional Info
Brioche & Jam 2
Almond Croissant 4
Mixed Salad(v) 25 No onions
I have query that returns a line that looks like this belowA NEWYORK PROGRAM AA NEWYORK PROGRAM Bnow, the NEWYORK is inputted into a dropdownlist and the program A and program B is inputted into a dropdownlist as wellI am using utility.ControlTools.SetListControl for my dropdownlist. I would like a situation where my dropdownlist only contains one NEWYORK instead of two and my dropdownlist for programs to contain Program A and program B. Can this be done.
View 2 RepliesI know the employee's ID and would like to remove it from my List<Employee> listOfEmployees.
The listOfEmployees.Remove seems to require index of the item to be removed.
Im Using asp .net with Vb Coding.
I have to remove the list of selected items from listbox .
Dim i As Integer
For i = 0 To listbox1.Items.Count - 1
listbox1.Items.Remove(listbox1.SelectedValue.ToString())
Next
My doubt is If i run the page again the listbox shows the items which i deleted already.
I have a class name Holder. I create a List of Holder, then add Holder to it.
holder = new Holder();
holder.Id = id;
holder.Distance = distance;
holderList.Add(holder);
its cool at this point. But now i want to delete a holder from holderList and I do following in another method.
holder = new Holder();
holder.Id=id;
if(holderList.Count > 0)
holderList.Remove(holder); //Error here it does not remove that spacific item.
I have a List in which I select users from db each time a sql query runs with certain value and selects one user in the time thus I cannot limit identical users in sql.
I have list with:
list[0] = "jerry"
list[1] = "tom"
list[2] = "jerry"
I want any (first or last doesn't matter in my case) to be removed from the list.
i crate a list box by database but select is show how to remove this using jquery<td><select name="ListBox1" multiple="multiple" size="8" id="ListBox1">
<option value="">Select</option>
<option value="1001">1001.Ashok</option>
<option value="1002">1002.Rajiv</option>
<option value="1003">1003.Garima</option>
<option value="1012">1012.Akhil</option>
<option value="1011">1011.Nasir</option>
<option value="1006">1006.Ashish</option>
<option value="1004">1004.Tazeen</option>
<option value="1005">1005.Raghav</option>
<option value="1014">1014.Sonal</option>
<option value="1013">1013.Praveen</option>
<option value="1007">1007.Kumud</option>
<option value="1009">1009.Gouda</option>
<option value="1019">1019.Pradeep</option></select>
I have a generic list which contains a class called Parameter. Parameter contains 2 integers, ParamType and ParamValue. A generic list is built containing a small number of values List<Parameter> myList I have created a function which passes in 2 parameters. These are passed individually but are used to create a new Parameter within the function. The Parameter is tested against myList, and if it is found removed. In order to do this I have used the remove function, the syntax being:
myList.Remove(new Parameter(ParamType, ParamValue));
The remove isn't working and at present I'm using LINQ to do it.
For my site, I have a list of users and a list of events. I will be assigning users to each event. I have a table named EventUsers to hold this data:
EventUsers
EventID | UserID
1 | 123
1 | 456
2 | 789
On my page, I want to be able to add and remove users for a certain event. I could have a dropdown populated with users and an "Add" button next to it, then when I want to add a user, I pick one and click "Add". There would be a grid below it displaying all the users for the event, with "Delete" buttons for each one. The downside to this is that a database call is made for every Add and Delete.
Another option is to have two listboxes on the page - one on the left containing all users in the database, and another on the right which will contain users for the given event, and I can just add or remove from the list on the right. Then when I'm done, I click save, and it makes one database call. The only issue is that if I'm removing and adding, I'll have to delete every record in my EventUsers table for that event, and then add the changes. I've run into this before, and I've always gone with the dropdown method. What's the preferred method here?
Given:
string removeRows = "";
int i = 0;
foreach (var row in userStats)
{
if (row.OrderRow.RegistrationType == "Want Removed")
{
removeRows = removeRows + i.ToString() + ",";
}
i++;
}
what's the Lambda syntax to execute the removal?
I have a linq statement that retrieves several rows from a stored procedure and maps them to a custom class. The rows returned could contain mulitple instances of the same ID
eg
id date total
1 01/01/2011 3
2 01/02/2011 2
3 02/03/2011 5
1 01/01/2011 3
the stored procedure perfoms some complex calculations to return the data How can I remove the duplicate rows in the list ive returned? Ive tried distinct but it doesnt work I want to process the RETURNED list (as there are only 4 rows here, i want to end up with 3) and just have 1 instance of ID 1.
I m working on MOSS 2007. My project requirment is to fetch the data from list to gridview with check boxes in front of all rows. when we click the checkbox infront of rows then that rows will be move to another gridview & remove from first gridview. Then I have to search the rows by location. following is my code it fetches the list in gridview & move rows from one gridview to anothe
1. how to remove selected rows from gridview & list?
how to search by location.
[code]....
I have many controls on my form, but in particular, I have 2 dropdownlists. 1 dropdown list has 2 values, and each value controls what the second dropdownlist displays. This is an edititemtemplate and both dropdowns have the selecteditem set via '<%# Bind("fieldname") #>' on page load.
THe problem is, if I change the value of the first dropdown, it errors out because the second dropdwon has a bound value that is no longer acceptable.
Can I cancel the bind of the second control, if the the first one is changed? I would like to cancel the bind, and update the values by using a different datasource depending on the value of the first dropdown or hardcode the new values.
If Dropdown1 has a value of "A" for example Dropdown 2 Shows Values "1", "2", "3"
If Dropdown 1 has a value of "B" , Dropdown2 Shows Values "4", "5", "6".
It binds fine initially, but if I change Dropdown1 from A to B, I want Dropdown2 to show the new values, maybe with a default of "Select an Item" and not error out b/c it's attempts to bind a value of 1, 2, or 3.
U are caching a list of items, then Add or update or delete method called. Approach 1)
A- Do the data change at the database. If success do B, C
B- Remove the entire list from the Cache.
C- Re-Cache the list on first read.
Approach 2)
A- Do the data change at the database, If success do B
B- Do the same change at the cached items, and save more time.
Approach(2) probably will cause nasty difficult to spot bugs, because the data come from BLL and placed directly into cache, One can't assume no bugs will happen at the sproc, I am not worry about database runtime errors, runtime errors will show up, but I am worry about invalid data, or miss calculation. Can I proceed with approach (2) with caution? Is there a "best practice" principle which suggest not doing approach(2)?
I have a series of dropdown lists on a page. The first list triggers the next and so on. I am using the PromptText = "Select Something..." property to display a default value. What I would like to do is select one of the items in the drop list by default. I see that there is a SelectedValue = "DynamicLandingPage" property, but it doesn't seem to take when the "PrompText" property is set. If i remove the "PromptText" the drop list selects the correct value but seems to be set as disabled.
View 1 RepliesThe table cells on the List.aspx all have an inline CSS style that prevents the text from wrapping. Sometimes I want the cells to wrap. How do I prevent the inline CSS from appearing?
[Code]....
My SQL query joins on multiple tables, and because of this it is displaying multiple results. I know about SELECT DISTINCT, but one of the fields ('Account.Name') is occasionally different, so it treats this record as a new row. Here is my SQL:
[code]....
I have a code:
[code]....
i want to avoid duplicate entries from array.....(in c#)
View 2 RepliesI have a simple asp.net web forms page that does an insert to my sql server db. My server was running slow at the time and I pressed Insert button several times because I didn't think it took but it did all 3 times.So I have duplicates from that one interaction. How would I prevent this?
View 2 RepliesI have a table named dups. There are 4 columns in the table.
id, name, path, hash
I want to return only the name, path, hash of each row where the hash field is the same. Example there are 100 rows but only two qualify the return would be.
file1 c: 10909
file4 d: 10909
For some reason this seems to be a more difficult task than I though it would be.
I have a sql query that returns 4 columns CustName CustId CustZip CustPhone
I have a second sql query that returns the following 5 columns
CustName CustId CustZip CustEmail CustAddress
Both queries, query different data tables in the database, but return columns that are common to
both.
How do I union the two queries(Assuming a union is needed)
Which will result in no duplicates and an end result being the following output:
CustName CustId CustZip CustPhone CustEmail CustAddress
As you can see we want to not have duplicate values on output. So something like the following
is not acceptable:
Jeff Stamper 2222234 81224 498-300-2222
Jeff Stamper 2222234 81224 498-300-2222 js@jj.com 122 Mars Blvd
Karen Bops 3322234 81666 498-300-2222
Karen Bops 3322234 81666 498-300-2222 kb@lpo.com 322 Jamer Road