Web Forms :: Remove Duplicates From List Method?
Nov 16, 2010
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.
View 1 Replies
Similar Messages:
May 3, 2010
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.
View 2 Replies
Mar 22, 2011
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 Replies
Dec 16, 2010
i have list<player> with duplicates.
i need to create another list<player> from the first list <player> with out any duplicates.
View 3 Replies
May 25, 2010
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
View 1 Replies
Feb 8, 2010
I want to create a web method that accepts a List of custom objects (passed in via jQuery/JSON). When I run the website locally everything seems to work. jQuery and ASP.NET and everyone is happy. But when I put it on one of our servers it blows up. jQuery gets a 500 error after the ajax request with the response being:
System.InvalidOperationException: EditCustomObjects Web Service method name is not valid.
[WebMethod]
public void EditCustomObjects(int ID, List<CustomObject> CustomObjectList)
[code]...
View 8 Replies
Apr 26, 2010
I have a web app where the user can create dynamic textboxes at run time. When the user clicks SUBMIT, the form sends data to the database and I want remove the dynamic controls.
The controls are created in the following code:
Table tb = new Table();
tb.ID = "tbl";
for (i = 0; i < myCount; i += 1)
{
TableRow tr = new TableRow();
TextBox txtEmplName = new TextBox();
TextBox txtEmplEmail = new TextBox();
TextBox txtEmplPhone = new TextBox();
TextBox txtEmplPosition = new TextBox();
TextBox txtEmplOfficeID = new TextBox();
txtEmplName.ID = "txtEmplName" + i.ToString();
txtEmplEmail.ID = "txtEmplEmail" + i.ToString();
txtEmplPhone.ID = "txtEmplPhone" + i.ToString();
txtEmplPosition.ID = "txtEmplPosition" + i.ToString();
txtEmplOfficeID.ID = "txtEmplOfficeID" + i.ToString();
tr.Cells.Add(tc);
tb.Rows.Add(tr);
}
Panel1.Controls.Add(tb);
The Remove section of the code is:
Table t = (Table)Page.FindControl("Panel1").FindControl("tbl");
foreach (TableRow tr in t.Rows)
{
for (i = 1; i < myCount; i += 1)
{
string txtEmplName = "txtEmplName" + i;
tr.Controls.Remove(t.FindControl(txtEmplName));
string txtEmplEmail = "txtEmplEmail" + i;
tr.Controls.Remove(t.FindControl(txtEmplEmail));
string txtEmplPhone = "txtEmplPhone" + i;
tr.Controls.Remove(t.FindControl(txtEmplPhone));
string txtEmplPosition = "txtEmplPosition" + i;
tr.Controls.Remove(t.FindControl(txtEmplPosition));
string txtEmplOfficeID = "txtEmplOfficeID" + i;
tr.Controls.Remove(t.FindControl(txtEmplOfficeID));
}
}
However, the textboxes are still visible.
View 2 Replies
Nov 23, 2010
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]....
View 1 Replies
Aug 27, 2010
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.
View 8 Replies
Feb 25, 2010
Do i remove the ability to call a method from the class my page is inherited from?
I am trying to build my custom Role Provider and certain method i not want to be accessible.
View 2 Replies
Dec 11, 2010
I have a long string containing the ,<p> </p> and <br>. I want to clean my string from all these tags and spaces. How it can be done with String.Replace() method. I am doing separately right now, it is working but is there a way to do it at once, without replace() method.
String.Replace(" ","").Replace("<p>","").Replace("<br>","")
It is giving me clean code but I am looking for a general solution, means if I am having more tags (10 to 20) to filter then how to do it efficiently.
View 5 Replies
Nov 17, 2010
I 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.
View 5 Replies
Oct 26, 2010
I have a generic List method that returns sales units, retail amount and their totals need to be displayed on a web page. For example here are 3 sales records, comments in the code below is where it needs the totals calculated and returned to the list.
public List<SaleSize> List()
{
List<SaleSize> sz = new List<SaleSize>();[code]....
I am not sure but will I need a foreach to loop through all the records?
View 3 Replies
Apr 11, 2010
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.
View 14 Replies
Dec 7, 2010
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.
View 1 Replies
Oct 4, 2010
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.
View 5 Replies
Sep 21, 2010
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>
View 3 Replies
Feb 9, 2010
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.
View 2 Replies
Sep 13, 2010
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?
View 3 Replies
Feb 5, 2011
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?
View 1 Replies
Mar 4, 2011
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.
View 4 Replies
May 18, 2010
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 Replies
Nov 12, 2010
The 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]....
View 3 Replies
Jan 7, 2010
I have several LINQ-auto-created data classes which are created using dragging and dropping database tables into the Visual Studio LINQ design pane. Also, in my project I have to manually create WCF data-contract classes. Each WCF contract class is for one LINQ-auto-created data classes; one to one. Is there some better way to reduce the efforts to this problem? e.g. inheritance or something else to create WCF datacontract class from existing LINQ-data class.
Example:
[code].....
View 3 Replies
Jan 17, 2010
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)?
View 2 Replies
