I have List (of class). having 1800 of count and each object has 90 properties. When I terate earch with 90 properties taking more and more time. How to resolve this
Dim cellIntStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
cellIntStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("#")
Dim cellDateStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
[Code]....
I'm using VB.NET. I want to build a large List (Of MyClassOrStructure) that becomes static after its initial population.I'm going to have multiple threads that need to iterate through this list to read data (no writing, inserting, or deleting)
Are there any very bad things that I need to keep an eye out for?
I am executing stored procedure using ExcuteReader() command. If I execute Stored Procedure in SQL server it is taking 2 secs. But in code taking around 2 mins. I tried DataAdapter.Fill(). Still the same.
What is wrong in the code?
spString = "usp_graph"
sqlcmd_q.Connection = sqlCnn
sqlcmd_q.CommandText = spString
[Code]....
below code is taking 150 to 200 second to read data (actualy my response data is very large) [code]
View 1 RepliesSetup taking toomuch time for installation
View 5 RepliesI am using vb.net in which I have put the background image to every form. The image size is 1024X768. When I open the form it is taking too much time to open. and screen is fluctuate.
View 1 RepliesI have a backend database in MS access, which is updated using excel as front end. Due to network issues the record updation takes lot of time. Would it be faster if i use VB.net as the front end.
View 1 RepliesI am on one asignment of convering C# to VB.net and stuck up with this problem.C# application has one class having inline two dimensional array initialized with size 168X168. I converted same class to Vb.net. Now whenever I create instance of my this VB.net class, It take almost 3 minute.
To figure out problem, I put break point on sub new() (first line of my constructor), and behaviour is realy strange because it takes 3 minutes to reach at first point of my constructor.Whenever I comment out my large size array initialization code, It works perfect. Now please note that same code is working fine in C#. It is not taking even few millisecond to initialize that class.
I am writing an application for managing mp3 files. I use AXWindowsMediaPlayer1 for playing files and UltraID3 for reading and writing ID3 tags. Every time the user selects to switch to next song, the ID3 tags of the current file need to be updated. My problem is with Media Player taking a long time to release a file for access after doing a "close". Currently I need to add a 6 seconds delay between the "Close" method of the media player and the ID3 tag "Write", otherwise I get the error saying that the file is currently in use. Anything less than 6 seconds does not work...
I attached a short version of my application which focuses on the issue.
I'm writing a database program that will take various information from the user via text boxes, then save them as a *.txt file. I've already figured out the majority of that business. However, I'm having trouble programming a ListBox.
The ListBox needs to accept three pieces of information from 3 Text Boxes, then concantenate them when a button labeled 'Add' is pressed and scoot them to the ListBox (lstshowresults) while clearing the three boxes at the same time.
I am upgrading user control from vb6 to vb.net.In the vb6 application I am loading 3000 labels using a label control array.In vb.net I am doing same but it's taking too much time to load.In vb6 it's taking 1-2 seconds, but in vb.net it's taking 30-40 seconds for same work. Why does it take too much time in vb.net for same work?Code is given below, here Led is the label control array.
For l = 1 To 3000
Led.Load(ledCounter)
ColLed.Add(Led(ledCounter))
[code]....
I'm writing a program to search files.The result is saved in a text file.Everything it's working fine, but when I say to look for files/folders in C:* the process takes long time and in task manager it's displayed as "Not Responding", this is not true because I see that CPU and RAM are working with this process.I've disabled in DEBUG OPTIONS the line "ContextSwitchDeadlock" just to prevent the error message "this operation require long time ... bla bla bla".Is there any way to display a progress bar or something like that that shows the program is running and it isn't "hang"?Here's my code (in red the line where the program hangs):
Code:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cartella, scelta, cosa As String
[code]....
I think that it's like when you type in the command prompt "tree" it doesn't hang... I know... it's not the same thing but...I'm using Visual Basic 2008 Express?
The idea with this form is to add the futures which is calculated when the button is pushed but I need the list to update every time and show the values each time to which the previous value is added to the new calculation, e.g. of what it should look like in listbox:
Year 1: $1,290.93
Year 2: $2,724.32
Year 3: $4,350.76
etc....
I have been working on this a while and I am at a standstill, I was given a function to clear the form everytime it calculates but I don't know how to implement it, I am new to VB. Here is what I have so far:
Public Class frmFutureValue
Private Sub btnCalculate_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnCalculate.Click
[code]....
i am trying to create a list of list in that i would like to work on multiple accounts at the same time. lets say i have 5 accounts. every account has a seperate name. each account has a few fields. so i though of having a list of bookkeeping (with 5 accounts) and a list of accounts (with expense, income, tax, status, etc as fields). [code] and if the idea of using list of list works how do i loop through both lists.
View 6 Repliesi am developing a program in visual basic 2010, it involves a non- linear iteration of one of the two variables with a step of .00 and a match at the .000 (3rd) decimal placethere cannot be an exact match between the 2 variable's values but i need the iteration to stop at the nearest possible value.
View 6 RepliesI just can't seem to understand when i am suppose to put Accept outside the LOOP and when i'm suppose to Accept inside the LOOP at the beginning.
View 4 RepliesIs the warning I am receiving about using the iteration variable in this line a concern.
Dim reportdataforpage = (From reportvar In reportdata Where reportvar.reportpage = pagenum)
how to assign one value to whole array without iteration through it? for example a i have pArray (5000,5000) =1 where all members off array = 1.
View 2 RepliesI 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?
Does a For-Each loop in VB have an iteration count, or would I have to do that myself?
View 5 Replies I've got a for loop. In my loop , I've got a condition , and if that condtion is not met, I need to move on to the next iteration.
So if I have :
For Each txt As Control In tbcell.Controls
if TypeOf (txt) Is CheckBox Then
[code]....
Background: I am working on an ASP.net project that basically fills out a form from user input. The generated form (for reasons which I have no control over) must be a JPEG or TIFF. So the user fills out the web form, which takes all of the input values and meges them into a blank image (jpeg) of the form. Using System.Drawing, it merges all of the text onto the form at designated Points. The points are defined as variables which are modified at runtime to compensate for the resolution of the image (in case it get modified/re-generated at a different dpi). All of this is working fine.
Problem: Currently I have a Sub that determines the dpi of the master image, then adjusts the Points accordingly. However, there are ~50 variables that have to be adjusted. So currently I have the Sub go thru each point variable and manually adjust the X & Y values. I have been working on a Sub that will iterate thru all of the Point variables and do adjustment. Here's a functional sample of what I have working:Imports System.Drawing
Partial Class test Inherits System.Web.UI.Page
[Code]...
This works...sort of. It allows me to grab each variable and modify it, but only in the instance. The original variable in the class is unchanged. Which means that when the program gets to the point where it's drawing text to the image, the points are unmodified. my basic question is: Is it possible to modify the original variable using this sort of process? If not, is the best way to use these modified values to declare the new class instance at a global level, then have the Sub that draws the text use the instance versions of the variables?
I realize that I could define all of the points in an array which would be easy to loop thru and update, but I've named each point variable something meaningful to correspond to the related text to be drawn.
I am building help files for a program using HTML Help Workshop.I have been trying to manually add files to the project file list as I write them, as HHW doesn't do so automatically.But it doesn't seem to matter whether the files are included in the list or not.When I compile, it tells me if any are duplicated, but it doesn't tell me if any are missing.(I have deliberately removed some to see if it makes a difference, so it's not that I haven't left any out.) And, whether they are in the list or not, the compiled help seems to find the files it needs.What is this list of files for?What files need to be included in it - html, css, images, maps? Why doesn't it seem to matter if my files are included in it or not? Is there any way to add files to the list other than one at a time? (e.g specify an entire folder?
View 4 RepliesEvery time I run my code my list city still visible at run time how do i make not to visible when I run my vb code. lstCity.Visible = False
View 1 RepliesI'm flummoxed I'm using VB.Net, Linq, and a DataContext. My DataContext contains a table 'transactions'.
I first declare an IQueryable(Of transaction) and assign it to nothing. I build a predicate in a foreach loop and use a transactions.Where(predicate) to assign the IQueryable a value. If I do an IQueryable.ToList(), I get a number of items in the collection.
However, on the next iteration of the loop, the IQueryable.ToList() gives me 0 items.This is driving me crazy. I tried to use the LINQ to SQL Debug Visualizer with VS2010, (I recompiled the 2008 version with the new reference) but no dice - I can't see the SQl generated or what's inside the IQueryable.
[Code]...
[URL]..Module Module1
[Code]...
It says the result will always be 5 namely the final value of i. How come?
They don't put the iteration variable in the "closure"?
Does anybody know how to count the number of iterations in a for-each loop? I want to have a variable inside the loop, returning the corresponding counter every time the loop iterat
View 5 RepliesI want to create a (3n*7) Matrix in python through Iteration, I did this in VB.Net and it worked but it gives me some challenge in Python as this a new language to me. n can be the number of Iterations to build up the matrix, i.e. ; if u iterated 3 times, the matrix will be a 9*7 matrix. Here is how I did it in VB.Net. :
[Code].....
For Next Iteration To Sum Users Input Numbers
View 2 Repliesi have a for loop that is executing. i want while the loop is executing to be able to define using a variable how many seconds the For loop needs to pause before next iteration.
View 2 Replies