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
I finally got my printer to print and how i want give or take i have an issue.I wish to limit how many charactors can be in a string. the string MUST = this number.lets assume the limit is 15 charactors..so if the string has say 4 charactors in it (which one can get with a len) it needs to add 11 blank spaces to the end of it.or if the string had 10 characters then add 5 blank spaces etc..
View 2 RepliesI 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 RepliesOk 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?
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]...
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.
I am taking in two html files and creating one out of them. To do this I am opening the first html file and not writing out the closing </body> and </html> tag and opening the second file and not writing out the corresponding opening tags, as well as the <style></style>section. I start a streamwriter, and write the lines out to it, and then close the streamwriter. My problem is that the output file is filled with strange characters. I've tried opening the streamwriter with different character sets as the third parm, but all this does is change the characters to different strange characters.It says charset=windows-1252 at the tops of the input files (and the output files for that matter - since I'm just reading stuff in and writing it out - with the exceptions mentioned above).Questions;First, do you think I am properly approaching appending two .htm files together?Second, how can I eliminate these strange characters.
[code]...
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 RepliesI'm having a little trouble deleting multiple lines for a listbox. I know how to remove a single line, which is this: [code]If I change the value for IndexOf to SelectedItems, I get an error stating that -1 is not valid for index.I am guessing this needs to be done using an integer array and a for each but I don't know how to do that. I really never bothered to look much into arrays.
View 1 Repliesi've got this code to remove all selected items in a listview... but i like to know if there is any more simple code to do this ...
My code:
Dim i As Integer
With frmMain.FeedsList
For i = 0 To .Items.Count - 1
[code]....
I am confused with the removing multiple selection from listbox ...been searching over internet .. but still I do not get the right approach or simply say it doesn't work. I tried to loop through the list without removing any of the item from listbox. I printed the item.selected and it showed that only the first one I selected printed true, others were not ...
View 13 RepliesHow do i delete multiple items that matches some words, Like [code]
View 6 RepliesI have the following code in which it supposed to remove rows that have the first column checkboxes checked, but it only removes one row at a time.If you have more than one checkbox checked, you have to click the command button each time to remove the row.It seems that the logic is correct to remove multiple rows if more than one checkbox is checked, but it doesn't work.
Public Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
For Each row As DataGridViewRow In DataGridView1.Rows
[code].....
I want to delete Multiple rows of listbox, I tried this
For teller = 0 To 170 Step 1
ListBox1.Items.Remove(teller)
Next
But that doesn't work. How do I delete the first 170 rows in my listbox? :)
i want to be able to remove multiple listbox items using one button the code i have tis the following: [code] Now this removes one item from a listbox, i changed the selection mode now now i can select multiple listbox items, but how does the code differ to delete all of the items selected? As currently it just deletes the top of all the selected items!
View 4 RepliesI am working on a utility to reformat a text file. Working on language to remove duplicate record entries. However there are desirable ("keeper") duplicates and then those I want to remove. I handled the problem by temporarily assigning a unique number to each @D line, then stripping them off after I've removed duplicates. So far so good, except in removing unwanted duplicates I have an extra of the "keeper" duplicates left that doesn't get removed. See below. I am wondering if there is a way to search for a line in a textbox starting with a certain character, but is also proceeded by 2 blank lines and followed by 1 blank line. CODE IM USING TO REMOVE DUPS yet keep formatting with blank line separators, etc.:
[Code]...
I have the following tables
Public Class Tag
<Key()> _
Public Property TagID As Integer
[Code].....
I implemented the repository pattern.
Now i have a list of Tags which contain the right TagReferences, but the tags may not be deleted, it's the TagReferences.
Variabels = ReferenceValue,ReferenceID
IEnumerable(Of Tag) = TagRepository.GetMany(Function(el) el.Reference = ReferenceValue And el.TagReferences.Any(Function(bl) bl.ReferencedID.Equals(ReferenceID)))
How can i remove all the TagReferences which contain the ReferenceID in one line?
I'm using this script:
http:[url].....To convert some outlook HTML to plain text.It nearly works, the only thing that it leaves behind is the CSS which outlook places in html comment tags <!-- --> in addition to <style> tags (which are removed).This is the original text:
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">[code].....
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]...
I am considering a piece of code that will manage access to a collection object from multiple threads - add, update, remove, clear. OK ... so I have put a sync lock within each method, but what is not clear from the MS documentation is exactly how the sync lock is behaving. Is it locking the piece of code it wraps? Or is it locking the object? And if it is locking the object a private static object should lock out any code locked on the object within all instances of the object? i.e. if an add operation is underway, an update, delete or clear will wait for the lock to be released.
Finally, if I have multiple threads contending for the sync lock, how is the release managed? First come, first serve? random (from my p.o.v)? Is there a chance that two separate threads could blunder into 'locked' code simulataneously?
Where to add this validation, or if there is a more efficient way of doing it and where to put it?
CODE:
How to use MVC Pattern efficient?
View 8 RepliesIs there a more efficient way of doing this code?
For Each row As DataRow In dt.Rows
Dim ts1 As String = row(0).ToString
For index As Integer = 1 To 9[code]....
just wondering which of these two sort methods would be more efficient movies.OrderBy(Function(m As Movie) m.Title)
[Code]...
I need to verify if a certain user exist on my asp.net site.I want to know if which of these two functions is more efficient, faster and better compared to each other and why.
[Code]...
I am working on an application that will need to read tons of records (close to 500,000) from one table and insert them into another set of tables in the same database. I though about using SSIS package for this but our DBAs don't want to use that. Now, I am thinking of a multi-threaded approach. I am thinking that I can have a few thread started that will read say (500) records at a time and insert them, then come back and read more.
Now, say I spawn off 3 threads of this application. The first thread reads 500 rows and starts processing them. Can I lock these rows that were already read so that the next thread does not pick them up? I am trying to find some articles regarding this on the internet, but perhaps I am not searching for the correct terms in Google.
I'd like to sample the data from the Arduino @ roughly 200Hz. Is there a more efficient way to do this than using a timer (which is what I am currently using)? Currently I am using[code]....
View 3 Repliesif there is no need for my variable to store negative values, is it more efficient to use UInteger instead of Integer? both are 4bytes and i've got a feeling unsigned works faster though i'm nt sure about it. note that the range of my variable is 0 to 2147483647, hence i could use a UInt32 or Int32 and both would give me the same result so i'm wondering about optimum performance.
View 7 RepliesI have been reading books trying to learn .net on my own. I am working on an exercise that asks me to create a 1MB file. what i have below does work, but it seems to me there would be a more efficeient way. It seems like what i am doing would cause a lot of overhead. making a 1MB file easier than what i have?[code]...
View 2 RepliesI have a program that must initialize a table that is usually about 10-15 thousand records. I have attempted several means to empty the records from it, but it always takes several minutes to accomplish the task or in some cases like a 'bindingsource.clear' command, doesn't work at all. I currently have it working using a simple loop to go through each record at a time and 'removecurrent'. but this seems extremely inefficient and it is quite slow.The real time consumer seems to come in with the tableadapter.update and tableadapter.fill that happens after the loop.[code]
View 6 Replies
