.net - Sorting And Getting Uniques?
Dec 30, 2009i have a string that looks like this "apples,fish,oranges,bananas,fish" i want to be able to sort this list and get only the uniques. how do i do it in vb.net? please provide code
View 3 Replies
ADVERTISEMENT
Excel Sorting Is Only Sorting One Column Not Multiple?
Mar 12, 2012I'm having my program sort an excel sheet by a few columns. However, it is only sorting by the first column not the rest that I specify.ere is my sort code below:
myRange.Sort(Key1:=myRange.Range("A:A"), Order1:=XlSortOrder.xlAscending, Key2:=myRange.Range("G:G"), Order2:=XlSortOrder.xlAscending, Header:=XlYesNoGuess.xlYes, Orientation:=XlSortOrientation.xlSortColumns)
[code]...
Wpf - Sorting Observable Collection Incorrectly Sorting?
Aug 20, 2011I have a WPF ObservableCollection which is bound to a ListBox and I have a Sort() method which when called will convert the ObservableCollection to a List(Of T), and undertakes a sort based on a date/time column within the collection.
The data is sorted, even when new items are added to the ObservableCollection, however the date/time isn't being correctly sorted. The data is sorting based on the date however it is very much random when it comes to the time portion. The following is an example of the outcomes I am experiencing:
[Code]...
Is there anything that I am doing incorrectly in this method that would cause the time portion not be included in the sort? Is there a better way of doing a sort?
Asp.net - Sorting A Dictionary By Value?
Apr 19, 2010I have a dictionary in the form of: { "honda" : 4, "toyota": 7, "ford" : 3, "chevy": 10 }
I want to sort it by the second column aka (the value) descending.
Desired output:
"chevy", 10
"toyota", 7
"honda", 4
"ford", 3
File Sorting Using VB?
Jan 23, 2012how to sort the files in the directory ?i'll have more than 500 no of files in the below format.
prod_orders_XXX_<TimeStamp>.dat
XXX = symbol of the product and the length may varies between 3-6.
<TimeStamp> = date and time
Multiple files for the same XXX are possible with different time stamps.Here are some examples:
prod_orders_abc_20122001083000.dat
prod_orders_abc_20122001083111.dat
prod_orders_xyz_20122001093157.dat
[code]....
SortedList Not Sorting On Key?
Mar 24, 2009I have a the need for key value pair that I wish to sort so I decided to use a SortedList instead of a HashTable.I am adding the data in the order below to my SortedList which is the order I need it in
Key | Value
--------------------------------
1 "700-800" | List(Of Object)
2 "900-1000" | List(Of Object)
[code]....
The key is a string and the value is a List of objects. The key is representing a time slot that has been concatenated from two integer values and delimited by "-". "700" as a string was 0700 initially an integer.e.g.
Dim key As String = slotTimeStart.ToString() & "-" & slotTimeEnd.ToString()
But once these key value pairs are added to the SortedList they appear in the order
3 "1100-1200" | List(Of Object)
4 "1700-1800" | List(Of Object)
[code]....
Unfortunately I recieve the times slots as two integer values which cannot be changed.Is there any way to force a sort on a SortedList? or is this problem because of the way I am storing my key? Is there a better way to store it?
Sorting A CSV File From Within An App
Mar 25, 2009I have a VB.Net 2005 application in which I access a SQL Server DB to pull data into a Dataset. Within my app, this dataset is read sequentially. Then, a cross reference file is read against the dataset record. If there is a match (based on 2 fields from the dataset record), a field value from the cross reference file is used to replace a certain value in the dataset record. Once a dataset record has been read and processed...it is written to a new CSV file. This CSV file contains 5 columns.
I've been requested to now sort this new CSV file using 3 of the 5 columns as the "Sort Key". What would be the fastest way to do this?
I know one way would be to create a new dataset and insert the finished record into this new dataset in the order of the 3 fields (which I'm not sure how to setup).
Sorting A DataView?
Mar 9, 2011I have an XML that looks like this:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="library.xslt"?>
<Library>
[code].....
Sorting A Recordset In Vb?
Feb 11, 2009How to sort a recordset using vb 6.0 coding?
View 2 RepliesSorting Arrays In .net?
Aug 10, 2009I need to know if there is any simple way to sort an array in visual Basic.net. I have been trying for some time without any real reliable results or wierd results. Here is the code this is the sort routine which transfers a csv text file read earlier into an array.
Private Sub btnSort_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSort.Click
Dim i As Integer = 2 'inner loop
Dim j As Integer 'outer loop
Dim tempstore As String = String.Empty
ProgressSort.Minimum = 0
[Code]...
The data seems to be read into the array but the sorting takes a very long time and I am not sure if it is working or not. I have read from other forums that it is easier to sort the array read from csv before splitting it. This record I am trying to sort is 250 records long. I have no idea how long that should take. Not even sure if the algorithm I chose is correct.
Sorting In Datagridview
Jun 11, 2009I have a problem with sorting in datagridview. I load an xml file in a datagridview and I sort the collums for check. when I try to sort it according to it's number the sorting goes like this:
[Code]...
Sorting In Datagridview?
Jan 14, 2010I have two columns in a datagridview, one is a year and the other is a month. These two form a date, but unfortunately the structure in the database I'm forced to use is that of two integers. I need to sort the rows by date, using these two integers. I tried creating an unbound column with a date, but sorting this way seem quite difficult. So, I thought I could do a multicolum sorting by year first and then by month using two columns
View 1 RepliesSorting Of 2 Strings?
Jun 7, 2009I have 2 strings one index: 4, 2, 5, 3 and second one times: 205, 153, 320, 300. I need to sort second string ascending, but to change also positions of elements for the first string and maintain position which corresponding with position for second string:For example initial i have:
index: 4 2 5 3 2 4 3 5
time: 205 153 320 300 after sorting 153 205 300 320
Way To Disable DGV Sorting
Aug 31, 2010How do I disable datagridview sorting?
View 1 RepliesWpf - Sorting XML Data In .NET?
Jul 1, 2010I have this hierarchy of XML
<Chapters>
<Chapter @num="">
<Section @letter="">
[Code]....
There has got to be a simple way of doing this....
.net - Natural Sorting A CheckedListbox?
Apr 18, 2012I've written the following class to create CheckedListboxes that use a Natural Sort algorithm. The overridden Sort() method, however, is not getting fired.(The code within that method is from the MSDN example on how to implement your own sort algorithm on a regular Listbox.)
[Code]...
A CheckedListbox derives from a Listbox, so I figured the Sort() override would work, but I'm stuck as to why it doesn't.I am setting the instance's .Sorted = True, but it's just sorting items using the default algorithm, and not the Natural Sort algorithm (which has been tested and shown to work as expected elsewhere).
.net - SortedDictionary - Comparer Only For Sorting
Oct 31, 2010I have a list of keys and values that I would like sorted by key via a custom Comparer(Of T). I tried using a SortedDictionary, but kept getting incorrect results because it used the comparer to see if the items were the same. For example calling SortedDictionary.ContainsKey() would return false, even though it did contain the key.
When I stepped through the code after calling ContainsKey(), it would go to the comparer.Compare(x, y) function. It would then only compare against a few of the keys in the dicionary, and somehow skip the matching item (which I ensured did exist). I take it that this is some sort of optimization, where some items are skipped depending on what is returned by the comparer.Compare() function? Is it possible to have a dictionary that only uses the comparer for sorting? EDIT: I am using a Type object for the dictionary's key
[Code]....
.net - Sorting A Dictionary By Value With Linq?
Mar 23, 2012I'm trying to sort a dictionary by value with LINQ but I can't figure how the ToDictionary() method works.
All the examples I can find are in c#.
here's my code
Dim f As Dictionary(Of String, String) = (From value In projectDescriptions.Values
Order By value Ascending
Select value).ToDictionary(???)
[Code].....
2 Dimensions Array Sorting In .net?
Mar 12, 2011I am trouble in sorting 2 dimensions array in vb.net. One row has 5 columns. Original array have 3000 rows.How can I get the effective sorting with pdtId. I tried to find googling, cannot get the right answer to me.
(0, 0) = pdtId "string"
(0, 1) = brand name
(0, 2) = category Id
(0, 3) = url
(0, 4) = date
[Code]...
Asp.net - GridView AutoGenerateColumns And Sorting?
Aug 31, 2009gridview sorting in VB.NET: I have a gridview with autogenerate columns = true
<asp:GridView ID="GridView1" FooterStyle-BackColor="Aquamarine"
AutoGenerateColumns="true" AllowSorting="true" OnSorting="Gridview1_Sorting"
AllowPaging="True" PageSize="12" OnRowCreated="GridView1_RowCreated"[code].....
I've declared the sort event handler (OnSorting="Gridview1_Sorting" ), and it works fine.However, then I change the column title (headers as they are in the dataset which I get from the database)
GridView1.HeaderRow.Cells(0).Text = "Document" ' "PROC_UID"
GridView1.HeaderRow.Cells(1).Text = "Process Step" ' "PROC_DOC_UID"
When I set the HeaderRow text, I can no longer click on the title to sort (it also is no longer underlined).How do I correct that?
Bubble Sorting An Array?
Jun 3, 2011I'm trying to bubble sort an array then display it in a list box. When I click the button the program crashes.
Here is my code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If Not TextBox1.Text = "" Then
ListBox1.Items.Add(TextBox1.Text)
[code]....
And the compiler gives me this error: A first chance exception of type 'System.IndexOutOfRangeException' occurred in WindowsApplication1.exe
C# - Implement Your Own Sorting Algorithm?
Apr 29, 2011Forgive me if this is a silly question....but I think back to my Comp. Sci. classes and I distinctly remember learning/being quizzed on several sorting algorithms and the corresponding 'Big O' notation.
Outside of the classroom though, I've never actually written code to sort. When I get results from a database, I use 'Order By'. Otherwise, I use a collection class that implements a sort. I have implemented IComparable to allow sorting; but I've never gone beyond that.Was sorting always just an academic pursuit for those of us who don't implement languages/frameworks? Or is it just that modern languages running on modern hardware make it a trivial detail to worry about?
Finally, when I call .Sort on a List(Of String), for example, what sort algorithm is being used under the hood?
Cleaning And Sorting Out Game
Nov 21, 2011I've been making a game using a Console Application as the main window, for the it. The game requires you to make the right choices in a mini Hacking adventure, but I'm rather stuck in an area where the player is required to enter the name of the file they would send and the program does not recognize the right one, also I was wondering how I could tidy up my code as It seems to be growing at a unnecessary rate.[code]
View 6 RepliesCustom Row Sorting In A DataGridView?
Jun 5, 2011I have a DataGridView that is being populated via SQL with one table and is being filtered by Stock Code. I need to sort the view of one Stock Code by Nutrient names, but the sequence number is in anther SQL table. it would be easy if i could put the sequence in one table but that's not possible
View 2 RepliesDapper ORM Paging And Sorting?
May 7, 2011I am giving the Dapper ORM a try. I am able to query data from a table using the code below:
Dim comments As List(Of Comment)
Using conn = New SqlConnection(ConnectionString)
conn.Open()
[Code]....
how to do paging/sorting using Dapper. EF has "skip" and "take" to help with this. I understand that a micro ORM does not have this built in but would like to know the best way to accomplish this.
DataGrid Sorting By One Column Then Another
Mar 13, 2012Is there a way to sort a datagrid by one coloumn and then by another? For example by column 1 then by column 2. I have managed to sort it by a single column, however this doesnt give consistent results.
View 12 RepliesDataGridView - Selecting Row After Sorting
Sep 29, 2011I have a datagridview that is bound to a dataview. I use a textbox to sort the list of data in the datagridview. Once the list is sorted I want to click on a row to populate the textboxes in order to update the data. Problem is once I sort the data I click on say row 3 and it pulls up the orginal data before the data was sorted in the datagrid view. For instance:
Before Sort:
1. betsy
2. james
3. john
After sort:
1. john
2. james
3. betsy
If I double click row 1 it will pull betsy info into my textboxes instead of john. I currently refresh my datagridview after every letter is entered into my textbox. I also reload my dataview and rebind the dataview with the datagridview.
DB/Reporting :: Multiple Sorting In CR .NET
Apr 1, 2008I plan to do a multiple sorting in crystal report programmatically... but i encounter some error... prehaps someone can guide me through
Dim crfd4sort As FieldDefinition
strSort = "ITEMNO_PRT, INSNO_PRT, VALUE_PRT, DATE_PRT"
[CODE]...
Deactivate Sorting In DataGridView?
Jul 8, 2010How do i deactivate sorting in my dgv after a certain button is clicked?
View 1 RepliesDirectoryinfo Sorting By Filename
Feb 23, 2009I'm looping trhough some files in a folder, is there any way to arrange them by filename alphabetically?[code]
View 6 Replies