VS 2008 Sorting And Searching (most Efficient)?
Aug 25, 2011
Ok so I have this program that shows data in a treeview and that data is from a datatable.I'm basically looping through the datatable row by row and adding nodes.The data looks something like the following:
[code]...
I have a thread that is hitting the Database (where these records are stored) every 5 seconds to see if the list is smaller,bigger or changed.If so, I was just recalling the load_form sub but this was taking too long as the lists could potentially be very large. Also, there is a lot of logic that comes into play depending on what user is displaying the records in the treeview.I was wanting to know what would be the fastest way to compare the datatable that was previously used to initially create the nodes in the treeview to a tempdatatable that has the currently updated/added/removed rows and update the treeview accordingly?The only thing I could come up with was basically looping through the tempdatatable and comparing each row to the rows in the original datatable and plucking out the ones that had no match.Then recursively looping through the nodes in the treeview to find the spot that the new node should be added (based on that datarow's values).Or is there a better way to do this and I should scrap this?
View 1 Replies
ADVERTISEMENT
Jul 25, 2009
In the past, I have learned by reading three or four other people's coding and once I gained understanding of how it worked, I could easily write my coding. I've got I will say this is a school project, so I don't expect anyone to just throw coding at me. I'd like to actually learn this stuff! Also, I HAVE read my book (over and over) and also requested help from the instructor, but as I'd like to meet the deadline on this project, I'm having problems waiting on his availability or lack thereof.
[Code]...
View 8 Replies
Jan 8, 2011
I was wondering what was the best way to search a database. Is it possible to perform bubble sort etc or any sort of binary search to the database instead of doing a linear search. If so how would I go about doing this through an Sql statement.
View 6 Replies
Nov 8, 2011
Just wondering what the most efficient way to remove multiple characters that are next to each other is.so that running would become runing - notice letters can appear in there multiple times - the n in this case.[code]
View 1 Replies
Oct 29, 2009
The code below shows me (I think) that the "for each" loop is about 10% faster than the "i to n" loop, but the "for each" loop creates 567k in new memory? Is this right? Which way is generally most efficient with regards to speed and memory usage? If you want to run this code in VB just add a button and 2 labels to a form.
[Code]...
View 1 Replies
Oct 29, 2011
I am looking for some guidance with the most optimal or efficient way to export a dataset to an excel file. I have searched the forums and found a number of methods to do this. However, the code I am currently using is very inefficient as it is itterating through the rows and columns to create the excel file. The app I am working on needs to be able to create 50 or so excel files each with 500+ rows and 40-50 columns. This method seems to inefficient for my use.
I have seen some code out there to use an ODBC call to excel to create the file. I am wondering if someone can verify that this is the most efficient way to meet my goal. It should also be noted that after the export I will want to do some basic formatting of the sheet. Adding bold column headers, autofilters, and autofit all columns.
View 2 Replies
Dec 19, 2011
I have to provide an Excel file as an output. I have to color some of lines and make them bold.The input is based on a dynamic list (in memory) and it also could be based on CSV file that I'm already provide today (based on the same dynamic list).I'm wondering what would be the most efficient way (in terms of performance) in order to provide the colored Excel output?Should I export directly from dynamic list into Excel - or - Should I export from CSV into Excel ?
View 7 Replies
Mar 12, 2012
I'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]...
View 1 Replies
Aug 20, 2011
I 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?
View 1 Replies
Aug 25, 2009
win app where user loads files from win explorer into a datatable bound to a datagridview. After loading the files, each filename is parsed and split into different fields and finally sorted w.r.t. to two its columns. One column is filled with error codes and depending on these, the cells that contain errors will be marked redIt's a three-step process where I just described step one.In step 2, the user will edit the data and hopefully correct the errors, cell by cell, according to some rules and here it's where my problems start. Since I sort the table in step one, sorting is activated and each time the user changes a value in one of the sorting columns the table will do a resort, messing up some of the editing done by the program (cell background color etc.) confusing the user.I have tried to use several of the datagridview events (mainly the cell and the row events) and also to turn-off the sorting by setting its dataview.sort="". Neither of my attempts has been complete successful so far.
View 2 Replies
Nov 2, 2009
I need to have "press" grouped (all jobs for press #1 then #2 then #3). Then have the grouped press jobs sorted by date ascending (all Mondays jobs together, Tuesdays jobs, etc.)When I change: Me.~my~BindingSource.Sort = "print date" to Me.~my~BindingSource.Sort = "print date, press"My datagridview groups the press rows together and lists everything in ascending order according to todays date just fine, except it won't show the first job with today's date at the top of grid. It will start somewhere within the today's date entries. I then have to scroll up 4 or 5 rows to see the first job with today's date.
But if I change my PC's calender/clock to any other day (past or future) it works perfect, first job at the top, all presses grouped together. Set clock back to current day and time and again it will start somewhere within the today's date entries.
Me.~my~TableAdapter.Fill(Me.~my~DataSet.~my data~)
'---Sort by "Print Date"---
Me.~my~BindingSource.Sort = "print date"
[code].....
View 5 Replies
Feb 3, 2010
I`m developing an appication which works with a mssql server database.At this stage I don`t have a problem connectiong to a database, because it`s on my computer.But the release version will be installed on few computers, when after installation user will have to choose the correct database to use with the application. I know how to find a working instances of MS SQL server in LAN, but after choosing an instance how to choose the correct database?
1. How to show databases availabale in th instance?
2. How to separate database designed for my application from all other databases in chosen instance?
View 3 Replies
Jun 11, 2009
how to add and remove entries from a database and now I need to know how to search it. I'm going to be scanning a directory and subdirectories and adding all files found to the database. I need to check if the file has already been entered into the database before adding it.
I though it'd be simple and would just require looping though each entry and checking the item for each entry. I played around with a while loop a bit and ran into some problems. Like when the database is empty.
I don't want to half-ass some code that seems to work, since that'd probably be slow and inefficient.
Also what are the technical terms for a column and row in a database. I'd to use the proper terms in the future.
View 1 Replies
Apr 13, 2010
Now that we have that part out of the way lets start with the question.I am attempting to create a small application which will use data form CSV or TXT file and display it in a DataGridView.But what I am interested in is if I would be able to use SQL commands to search through the imported file. Commands like (SELECT, FROM, WITH etc.) and then poplute the DataGridView with the results.
View 9 Replies
Nov 4, 2010
It seems that when using With blocks in VB.NET, the resulting MSIL larger than w/o. So this leads me to ask, are With Blocks really more efficient? MSIL is what gets JITed into native machine code, so smaller code size should imply more efficient code, right?
[Code]...
View 5 Replies
Dec 28, 2009
how we can sort a listview on column wise in a simple way?
View 2 Replies
May 4, 2009
Ok so I know that you can sort by using a bunch of different sorting algorithms but I just am not sure how to start this off. I have written this code and just want to know if you can even sort this.
The program takes the users information in from text boxes from another part of the program and writes the information into a text file. So when the user clicks on this button it will display all the people that have entered in their names. I want to sort their last names alphabetticaly.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnListCustomers.Click
[Code]...
View 6 Replies
Jan 19, 2010
I have been learning how to sort a list using lambda functions
excessPop.Sort(Function(f1, f2) f1.ID.CompareTo(f2.ID))
I am however struggling to sort a list using 2 parameters within a lambda function. The properties within my list that i need to sort by are Category and then by Cost. how to do this?
View 5 Replies
Jun 4, 2010
I have two rich text box, and a button. I want it so that, if I click on the button, everything on first text box, would be on 2nd text box. BUT, if there's a similar line. It would only show one line, except it would have "x#" where # is the amount of times it's duplicated.
So:
Potato
Dinosaurs
Dinosaurs
Bus
Would be:
Potato
Dinosaurs x2
Bus
View 4 Replies
May 15, 2010
What i am doing is to enable a user to specify in a combobox on a form a threshold (integer). On a button click the code steps through a datatable until the cumilative value of a field in the records row are equal or dont exceed the figure specified. It then selects these rows and presents them in a datgridview in another form. This all works just fine.
What i am struggling with is undertaking a sort on another field before it starts the filter part. It appears to revert to the default order. Here is my
If ComboBox1.Text = "Co2 saving in tonnes" Then
Dim table As New DataTable
Dim limit As Integer = ComboBox2.Text ' Your threshold
[Code].....
View 7 Replies
Jan 17, 2012
How can i sort the following
2 Module for Drawing
6 Module for Typing
5 Module for Maths
[code].....
View 12 Replies
Oct 17, 2010
The following code retrieves all USB hubs on a PC and adds them to a treeview:Dim USBHubsearcher As New ManagementObjectSearcher("SELECT * FROM Win32_USBHub")For Each queryObj As ManagementObject In USBHubsearcher.Get() SystemTree.Nodes(0).Nodes("USBHUB").Nodes.Add(queryObj("Description"), queryObj("Description"), 4, 4)Next What I want to do is to sort the results by "Description" so that they are listed in alphabetical order. ORDER BY does not work as it is not part of WQL.
View 2 Replies
Jun 15, 2011
I am working on high Frequency data. I have a matrix with their values as zero or non-zero. I have generated Matrix using Data Tables and Displayed in DataGridView.
Now, my Column Headers are as follows 5000, 5100, 5200, 5300, 5400....6000
similarly my Row Headers are same as column headers 5000, 5100, 5200....6000
I am looping for each row and than each column and want to store value of each cell with their column header in an Array.
Than, I want to sort array based on values in descending order.
Now Problem is - When values are same(duplicate) for more than one cell in same Row.
So, I want to store column Header with values in an array. If, there is a duplicate value than sort on column header.
In this way, I can avoid conflict in sorting and can easily retrieve value of Column Header
how to assign values and column header value to 2 dimensional array
View 3 Replies
Mar 19, 2009
currently I was able to Sort GridView and it is having several page. what my brilliant boss want is to SORT the records per page... as in per page... (ex. page 3 of the gridview contains 50 records of data (G-J), she want to sort the 3rd page for the records to become (J-G) just for the 3rd page...)
View 2 Replies
Feb 7, 2009
One displays a list of contributors for a charity and the amount given in a text box.However iv created another button but i need this to sort the list of names to just display the names and in alphabetical order.
[Code]...
View 19 Replies
Jan 20, 2011
I'm currently in the middle of attempting to create a query that will be used so that the application user will be able to search the a customers id number. I'm completely new to adding queries using the query builder so I've become slightly stuck on trying to get this to work currently. I have a database which is set up and in this case the table is called 'cid' which defines the customers id column in the database, this is a primary key and the column has a data type 'AutoNumber'. I've become stuck as I'm not sure what I would have to put into the filter to make this query work.
View 7 Replies
Apr 27, 2009
this is what I've got so far:
Dim find As String
Dim search
find = InputBox("Enter Search Text")
search = MyRichTextBoxEx1.Find(find)
[code].....
But how can i search for the next occurrence of the search?
View 2 Replies
Feb 17, 2010
I'm searching through an html page and I want to put all of the Regex matches into an array? How would I go about doing this? I see the Regex.Matches but I can't quite understand how to use it an MSDN sucks when it comes to explaining it.
View 4 Replies
Jun 27, 2009
I haven't programmed for some time, so I'm a little rusty Basically I'm storing HTML within a variable, and I need to count the amount of times a specific element appears e.g. <h3 class=r> for now.
I thought of using a for each loop, and passing the string above into the parentheses of the loop (using a variable ofc) however for many reason's, I don't think this has a chance of working (won't bother explaining why, as I assume you can guess). Then thought of using the .Contains method of the string class, but I simply can't think of how to use it with what I'm trying to do.
View 2 Replies
May 2, 2010
I'm trying to get a program running that loads a sequential file such as "records.txt" into a two dimmensional array and searches the "records.txt" for the data that the user enters into a text box. Not quite sure how to go about doing this.
View 1 Replies
