ADO.NET, Datareaders And VB.NET Speed?
Feb 28, 2008
currently writing a standard 3-tier (gui/business layer/data layer) winforms application in Visual Studio 2008.I have a form which has to load around 20 different sets of un-related data when it opens. My data layer returns seperate data readers to the business layer and each routine uses seperate sql connections (it opens them, gets a data reader, and then closes it).Now the problem i have is the speed the data is being retrieved. For a relativly small amount of data (around 100 rows of data combined) it's taking say 10 seconds to retrieve, parse into seperate collections and then paint to screen.My form is using controls from Infragistics and Component One and is quite heavy anyway
View 2 Replies
ADVERTISEMENT
Apr 3, 2012
I'm working with a database that includes a table called MenuItems. The table is hierarchical, so an item can have child items under it. A record's ParentID corresponds to the ID of the parent record, or the ParentID can be 0 if the item is on the top level.What I'm trying to do is create a VB.Net application to populate a TreeView with the records in my MenuItems table, using the recursive function ListSubMenus in the code below:
Code:
Private Sub ListSubMenus(ByVal ptvnParent As TreeNode, ByVal plngParentID As Long)
Dim strSQL As String
[code].....
View 5 Replies
Jul 14, 2009
I am using datareader to retrieve data. I want to use multiple datareader at a time with same connections. WHen i used it, it gives an error as connection should be closed before using it next time.
View 23 Replies
Jun 27, 2010
I have been studying about the DataReader in the msdn from a couple of hours and i habe seen that they are using this term:Read only Forward only a lot of times for the DataReader but i cant understand why?Why are DataReaders Read only Forward only?
View 12 Replies
Feb 21, 2012
How 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 Replies
Dec 31, 2010
how 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 Replies
Nov 30, 2010
I 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 Replies
Jul 29, 2009
i 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 Replies
Jan 4, 2012
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
View 1 Replies
May 5, 2009
how 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 Replies
Jan 12, 2011
Is there an easy way to get the CPU name and Speed? Also for Memory to display in MHz?
Heres a pic of my app and its
Was bored and wanted to make a "Mac" like app (About This Mac). I have some experience with Xcode. Never really did programing on windows before. Also, is there any way to call up a control panel through VB.Net? (Windows Update)
View 2 Replies
Jul 20, 2009
Given a distance (50km) as integer: 50
And a time as string in the following format:00:02:04.05
hh:mm:ss.ms
How would I calculate the avg speed in km/h?
View 4 Replies
Jul 11, 2008
is it possible to change the fan speed using vb, i am creating an overclock application and this would be very usefull.(in vb 2008)
View 12 Replies
Nov 24, 2009
I have a download manager in my browser that i downloaded from this link :[URL]but i have 2 questions. 1) How do i get the download speed? someone posted this currentspeed = iTotalBytesRead / (sTimer.ElapsedMilliseconds / 1000) but i dont know what that person hade dim ITotalBytesRead?
_Downloader_AmountDownloadedChanged:
lastSize = cSize
If Timer1.Enabled = False Then Timer1.Enabled = True
View 4 Replies
Feb 11, 2012
I'm trying to get the upload speed of a ftp stream with vb.net unsuccessfully.I'm not sure if the maths are ok, I googled for a while trying to find the equation for upload and i found it in some code examples but for download.[code]
View 1 Replies
Feb 28, 2010
Is it possible to speed up VB.express on an older laptop? For example, is it possible to disable the announcements window for speed. It appears that the announcement window is just another webpage embedded in the program that would slow it down. Any other tricks to get vb.express up to speed on an older machine?
View 3 Replies
May 4, 2012
How do I speed up the process of keeping the data to the database from DataGridView to database access
View 3 Replies
Jun 12, 2011
What ways do people know how to speed up vb browser?
View 1 Replies
Aug 7, 2011
I have this program, which prints a sine wave but it's too fast, how can I slow down the console's line printing speed?
[code...]
View 2 Replies
Dec 3, 2002
Does anyone know of anyway that it would be possible to speed up the process of loading forms.With VB6, forms (simple ones) was extremely fast but with VB.net, the initial loading of a form (even the simplest one) takes very long. Although it gets better once it's loaded once and the reloaded the next time (almost instanttaneous), but the first time loading gives a bad impression to any user that .net is actually much slower.
View 7 Replies
Sep 5, 2011
How do I best speed up running of my program?Once I have simplified code as much as possible, made it smaller. By using loops were appropriate etc.
View 7 Replies
Sep 5, 2011
How do I best speed up running of my prog?Once I have simplified code as much as possible, made it smaller. By using loops were appropriate etc.
View 1 Replies
Jul 4, 2008
im wish to get the cpu temperature and cpu fan using wmi.. in my bios, i can read my fan speed and cpu temperature.. i tried to use wmi to get the data but it doesnt function..for the wmi, i downloaded the wmi creator from microsoft website.. n it work perfectly to find other information like bios infomtion. however, it is not working with cpu temperature and fan speed..from internet, i found a program called SPEEDFAN and this program can list out all the computer temperature... do anyone know how this program function? i wish to get the information of temperature using vb.net.
View 11 Replies
Aug 22, 2010
Well I made this application [URL] and I need to be able to change the speed which the CD Plays at?
View 1 Replies
Nov 19, 2009
I just did a little test, comparing speed between a function and the same thing but using a byref value instead.
Public Sub New()
Dim timespanFunction As TimeSpan
Dim timespanByRef As TimeSpan[code]....
So using byref is more then a second quicker in this case. So why does function actually exist? Is it just to make programming more easy and your code look nicer? The most important things of a application are Usability and Speed right? So why trade speed for nicer looking code?
View 5 Replies
Jun 13, 2012
I have noticed that when iterating DataGridViewColumns, the speed is greatly reduced if the columns are visible.
For Each col As DataGridViewColumn In cData.DataGridView.Columns
col.Visible = visible
Next
If visible is set to false (and all columns are all currently visible), iterating 264 columns takes around 0.35s, however, if visible is set to true (and all columns are currently invisible), the same process takes around 30s.Does anyone know what would be causing the extra time?Could it something internal to the DataGridView Control?
View 5 Replies
Apr 20, 2012
How do you detect the RAM speed and type?
E.g. DDR3, PC3 10600, 1333Mhz
I already know how to detect slots, total ram etc...
View 1 Replies
Dec 27, 2009
I am making a program that works with my hometrainer so i can now have my speed and distanse on my screen but now when i start byking i would like to play a video on my screen also when i am biking slow the video has to play slow when i am biking fast the video has to play fast is there any one how can tell my how todo this whith a sample
View 3 Replies
May 23, 2010
I wonder if its possible to fade or set the speed of the form when i give it a new size?
The form will have to different sizes (maybe not a god idea) and when i change this i want the form to do this slow.
View 1 Replies
Apr 4, 2009
You know in windows, it says your connection speed down in the toolbar. How can I find this programmaticaly in vb.net?
Here is my code to get internet connectivity
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]......
View 7 Replies
