Web Forms :: Distinct Arraylist Value Using C#?
Feb 22, 2010how to distinct arraylist value using c#?
View 10 Replieshow to distinct arraylist value using c#?
View 10 RepliesI have the following table structure:
[code]....
The following query returns the default recordset:
[code]....
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.
i want to create a arraylist which will able to store user info like (username,machineIP,port ) for each user in the list & retrive this data when needed . any one tell me how i can do it or any alternative way without database or xml file.
View 6 RepliesI have one table(tableName is getDetails and having three column ID, Name, City)
View 6 Replieshow can i check distinct val in col_1 of datatable and assign seq no to each distinct val of col_1 to col_2?
View 6 Repliesi'm binding data to ddl from database.i'm selecting one column from database table to bind.In that column there may be items with same name.but when selecting in ddl there must be no same values.
View 4 RepliesThis is my last thread [URL] ....
This sp show duplicate row yet, what can i do?
I'm trying to bind a dataset (where the data is coming from a webservice) to a dropdownlist; the problem is that I'm getting duplicates in the list... how can I display distinct values only:
[Code]....
i have table that trace views of my page. every row has the id, date view (dd/mm/yyyy hh/mm/ss) how can i distinct the data into gridview (or something else) and display only the days (01/03/2011, 02/03/2001, 03/03/2011) and to sum the numbers of views (01/03/2011 1,290 views, 02/03/2011 867 views.....)
View 7 RepliesI'm populating a gridview showing all the personal log entries for all users which have entered information into the database.
There's the following columns in the database table:LogID, DisasterID, UserName, DateEntered, and LogEntry.
I can get the gridview to populate with this information just fine depending on the DisasterID.
Right now, it shows the username next to each and every one of their entries.
How would I configure it so that it would list the username once and all their entries, followed by another user and all their entries, etc?
I am trying to retrieve a arraylist frm a session and add in more objects into the arraylist on top of the existing object in the arraylist.But i have encounter problem at the foreach loop where it promted me a error message shown below
Object reference not set to an instance of an object.
below are the sample code.
public void addItemToArraylist(List<LibraryItem> temp) //l temp pass in 5 items each tim
{
ArrayList storeItems = new ArrayList();
storeItems = (ArrayList)Session["storeItems"];
foreach (LibraryItem items in temp)
[Code]....
I have a function and I am getting an error message. I need to convert my DataTable to an array and be able to access each line individually. This is the error message: Operator '-' is not defined for types 'System.Data.DataRowCollection' and 'Integer'.
[Code]....
I have a procedure that is used to look up user permissions in our custom table, There is 1 record for each user and about 20 columns for each of the permissions.
How can i take the column values and place into an array?
All the column are bit type and 1 is int. Is it possible to take the values returned and add to an ArrayList?
And then once the values are in the array, how to loop thru it and go to certain index to check the value.
This is what i have now:
[Code]....
[Code]....
[Code]....
I am working on a VS 2005 based Environment, on .NET 2.0.am trying to Bind a ArrayList to a GridView. The ArrayList consists of Objects of a Specific Class. When i bind it now all the Properties in the class. The catch is I do not want to display all these properties on the GridView.For Example: The objects of this class is held in ArrayList, when i Bind it to GridView it shows all the four Columns, Where as i want to show only 2...
[Code]....
I want to add four values to the arraylist when i click on UP button. and if i click on UP button again i need to add four more values to arraylist.
While getting the values from arraylist i need get four values at a time and so on .
How do you go about removing multiple items from a array list?
I'm using the RemoveAt() method to remove but doing that resets the ArrayList's index which cause me problems if the user selects to remove 1 & 3 out of a 3 list array since once it removes 0 the array list now just has 0 & 1.
i want to show the arrayliust items in the listbox, for that i had stored some data in array list, and now i want that if i gv any id which is in the array list its corresponding details are displayed in listbox. I had two fields ID, Name, and when i give id its corresponding name should be shown in list box.
View 3 RepliesI have a GridView control of 5 columns out of which 2 are actually computed (there cell values comes from column 1, 2 and 3) columns. I want to save all the values of my gridview columns in a 5 dimension ArrayList and then lateron bind that ArrayList with a repeator control.
View 1 RepliesI am doing a leave application in which I want to display working days (dates) apart from holidays and weekends. So first I make sure that it is not a holiday by comparing with my holidaymaster table and not saturday or sunday. My code so far looks like this...
asp.net:
< asp:GridViewID="grdWorkingDays"runat="server"AllowSorting="true"AutoGenerateColumns
="true"></asp:gridview>
c#:
//Check whether it is a holiday(compare with holiday_master) or saturday or sunday
for (DateTime
i = LeaveStartDate; i <= LeaveEndDate; i = i.AddDays(1))
[Code]...
openDB() Dim inList As String Dim getCourses
For k As Integer = 0 To arLcID.Count - 1
If k > 0 Then inList &= ","
End If inList = arLcID(k).ToString
getCourses = "select cID,cCode,cUnit from [university].[Courses_1] where cID ='" & inList & "'"
insertCMD = New Data.SqlClient.SqlCommand
[Code] ....
This code is not returning any value, when the arraylist is removed it returns value.
I've been trying to bound an arraylist to a grdview for display and managed to work out the following:
[Code]....
At the point where rows are added to dt, i'm trying to get arraylist (Tweet) to be read row by row to insert each of it's fields into dt. There is no error but when run in browser, each cell of the gridview shows 'DataExtraction.Tweet'.I'm not sure where to go from here.
I have an arraylist that contains some values. (e.g. playerName). I also queried for values in the database (e.g. playerName, playerSales) and I need to match the playerName in the arraylist to the corresponding ones that I did a query from the database. (match those with the same playerName). From there, I need to create a bar graph with the respective playerName and their sales (playerSales).
A portion of the code is shown below:
[Code]....
The arraylist I mentioned was saved to a session to be used in another page. Is my code right? And how can I create the graph from the values?
how to create a bar chart from the values in the arraylist?
View 3 RepliesI have an ArrayList of strings called 'vins'. I have set DataGrid1's data source set to 'vins'. When I check off create columns automatically at runtime the DataGrid is populated with the correct values from the arraylist, however I'm not sure how to reference them. I'm trying to make it so that a user can click on a link after any VIN number and have that referenced and deleted from the arraylist. bind this ArrayList to the DataGrid and then be able to reference them.
View 4 Replies