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 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.
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 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">
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:
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?
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?
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.
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?
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:
I 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?
I 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.