I have the following script where a user fills out a form and the data is passed to update a row in an existing excel document. Everything works fine, but its excruciatingly slow. how to speed this up?
Dim oEx As Excel.Application
Dim oWk As Excel.Workbook
Dim oWt As Excel.Worksheet
[code]....
How do I speed up the process of keeping the data to the database from DataGridView to database access
View 3 RepliesI wrote a VB.net console program to process CSV record that come in a text file. I'm using FileHelpers library
along with MSFT Enterprise library 4. To read the record one at the time and insert into the database.
It took about 3 - 4 hours to process 5+ million records on the text file.Is there anyway to speed up the process? Has anyone deal with such large amount of records before and how would you update such records if there is new data to be update?
edit: Can someone recommend a profiler? prefer Open source or free.
how to speed up or slow down a process.
I found out that I should use timegettime, gettickcount, queryperformancecounter.
I have found some info here: h[URL]
I've gotten to the part where I copy and paste the whole code. But, I want to only change the speed of a process.
I need code for speed up any process?
View 10 RepliesI have written a windows service that is meant to launch a notepad when a specific action happens. The problem i have is that even though the service launches notepad, the actual notepad it self is NOT visible. I know that it has been launced because i can see the process in the task manager. By the way the process is listed as a SYSTEM process rather than a process under my user name (i believe that is because my process is a "LocalSystem" one).
View 4 Repliesi have some code in visual basic and i wrote some classes in c++ and i want make it dll but i don't know that when you use dlls it decreases the speed of process or not.
View 2 RepliesI have an issue using Process.MainWindowTitle,Process.MainWindowHandle on some older VB6 applications. After Process.Start I use Process.MainWindowTitle to display in a listbox. The MainWindowTitle returned is not the Window Title but in fact the Project name of the VB6 exe.? I also store the MainWindowHandle to use the ShowWindow and SetForeGroundWindow API's. It would appear that the ShowWindow API does not work, but the SetForegroundWindow does. ie: if the VB6 app is minimized, showwindow does not restore, if it is NOT minimized setforewgroundwindow sets it to the foreground. The exact same code does work correctly for any other .net exe or notepad, only on these vb6 programs I am having a problem.
View 9 Repliesmy problem is the speed of the compiled vb.net program on VPN..after working 4-8 hours (without closing the software) the compiled program taking too slow. in reading the records or even modifying it..I installed it in VPN and the backend database is MS Access..
View 3 RepliesHow do i exactly check internet connection speed.I have searched around google and found out a method w/c will Download a file like 1mb size, then it will calculate the speed.
View 1 Replieshow do i check the bandwidth (download speed and possible upload speed) of a user in vb.net or php that uses my app or visits my site resp?
View 1 RepliesI have a codes that calculates DownLoad speed and UpLoad speed kb/s. I would like to implement this kind. I also want to put such kind of graph. Any article or links where can I start building my own like that.
View 2 Repliesi want to monitor the speed at which my system is currently Downloading and uploading. I dont have any idea how will it can be done.
View 6 RepliesWhen I load my solution and compile it after first starting the IDE, everything works as expected. After changing source and recompiling, I get the following compile error:
Error 11 Unable to copy file "objDebugCAMDRS.Library.dll" to "binCAMDRS.Library.dll". The process cannot access the file 'binCAMDRS.Library.dll' because it is being used by another process. CAMDRS.Library.
After closing Visual Studio 2005 and reopening the solution I can compile again successfully. This is an old solution that has been fine for a long time. I just recently changed computers and reinstalled everything.I am running win XP Pro sp2, Visual Studio 2005 sp1.
i want to check for the lan speed and put this speed value in a progress bar.
for example:
[==== ] the lan speed now is 23 KB/s
and there is another problem is if there are a LAN and a WiFi adapter in the same time how do i check for the speed for both adapters
To explain this, I can only use example. Let's say, I choose Index.doc on my openFileDialog. However, as you know, on the Processes tab under Windows Task Manager, it will display WINWORD.EXE. So how can I get WINWORD.EXE to display on a label / textbox / any readable tool after opening Index.doc? Perhaps this code snippet can get you a clearer understanding of my current code.
[Code]....
It is possible to know what process is running a svchost.exe in vb .net?
View 5 Replieshow would i go about getting the of a fan of a computer that my program is running on in rps(revolutions per second) using vb.net?
View 4 RepliesI'm trying to delete a file, which prompts the error: "can not delete File in use by another process". I've been researching this for the last couple of days, and have tried every possible suggestion, I've come across, but still keep getting the error. I'm hoping someone might have a suggestion on what I need to change or rearrange in my code to get around this.
The program loads a group of files into a listbox, user selects which files to process, Each file is sent through the sub (process files) to be renamed, and then processed through external programs then removed from the listbox. Each file in the list HAS to be renamed the same in order for the external program to process it. This is where I'm getting the error message, as I need to delete the previous file before renaming the new one. Parts of my code may seem redundant, but its where I was trying every possible scenario of closing the process and or stream that's leaving the file open. [Code]
how can I get the CPU usage in % of a server not for each process but for the server itself?
View 7 RepliesI want to get the current directory of any process. As I have seen in Process Explorer tool that it is possible, but don't know how??
View 7 RepliesLets just say I had something like this:
System.IO.File.Create("C:.txt")
Dim SaveF As New System.IO.StreamWriter("C:.txt")
Under each other. It gives me a error saying:
The process cannot access the file "C:.txt" because it is being used by another process.
I'm using VB to create Excel templates and everything appeared to be working fine until I was stepping though some code today with my Task Manager open. I noticed that I had numerous instances of Excel open that should not be. This is the code that is being called to close the process:
[Code]...
When stepping through this code I am hitting the exception after the execution of the GC but the message box does not appear so the the using thinks that everything is fine. When I close my applicataion all of the Excel processes shown by the Task Manager close as well.
check how long a process has been running? I'm using the below code to check whether these programs are running.
Is there a way to see how long they've been running?
Private Sub tmrKillJoy_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tmrKillJoy.Tick
Dim local As Process() = Process.GetProcesses
[Code].....
i am trying to write a code who find a window and draw line or string on it but nothing found yet,the process can aslo be a game so did it required to use 'Direct3dx' i try something like this but not woking...
[Code]...
I need to write a windows app (vb 2005) that does following:
1. Imports a .csv file
2. Selects certain rows from the .csv file
3. Splits the .csv file into fields based on delimiter
4. Populate a db2/400 table with only some of the fields.[code]
I receive status emails from a service automatically. I want to open the mesages and read the text and extract some parts. Currently, I have a rule set up in my local email account to transfer these messages to a specific folder. I want to open each message and read its contents and do a pattern match etc. How do I go about looping through each message in this folder?
View 2 Repliesin my programm I'm executing a batch file in a process that doing a few xcopy [code]If I do this I'm getting the xcopy command line but the xcopy doesn't run.
View 1 RepliesMy application checks to see if Outlook is running - if not, it should launch Outlook. I used the
[Code]....
In VBScript, to create a new process on a remote machine, you could use this
[Code]...
I would like to do the same thing in .net using WMI, and I tried to do this on my own, but my code is not working properly. If I specify my logon credentials, the process will execute on the remote machine and the code works fine, but I want the program to send the WMI query by using impersonation. I believed this was supposed to send the user credentials of the user using the program to the remote WMI provider on the remote machine. Here is the code I am using:
[Code]...