VS 2005 Dealing With Large Amount Of Records?
May 21, 2009
I am making an inventory program in which there's an ItemMaster and Sales Form. Currently there are 15000 records of items(increasing daily). I want to display all the items in the sales form so that the user can select an item from the list for billing, and also in the itemmaster so that if the user wants to edit any item then he can select it from the list.
I can make a common list form for both sales and master, but i have to load the data from the database into the list every time the list is displayed(which is taking lot of time), so is there an better way to do it.
View 8 Replies
ADVERTISEMENT
Nov 24, 2009
The code below put in the DB 0 in a few fields...Normally the query sort a large amount of records and off course the code take a little time to do the job...My question is simple...This is another way to get more fast this job?
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim sql As String
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & drive & IDempresa
con.Open()
[Code] .....
View 8 Replies
Sep 20, 2010
I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc.One table will have data representing 47k reps that currently have credit for a transaction. The other table will be a mirror copy of the 1st table with 47k reps that were supposed to get credit for a transaction. This application is going to take credit from one rep. and give the credit to the other rep record in the 2 mirrored datasets. It's taking 30 seconds for the data adapter fill method to return records to my application. I would like to reduce the amount of time it takes for this request to process.
[Code]...
View 8 Replies
Apr 19, 2012
So I am making a file crypter so that I can encrypt my VB.NET Application that I am making so that people can't decompile it. I had made this in C# and am transfering it to VB.NET, Everything worked fine in C# but once I had re-written the code in VB.NET i get this error inside of my RC4 Encryption method:
'Arithmetic operation resulted in an overflow.'
The error is occuring here:
Dim t As Int64 = (s(i) + s(j)) Mod 256
This is the same code above in c#:
int t = (s[i] + s[j]) % 256;
Is there anyway to make that calculation with it erroring? And why does it work in C# but not VB.NET?
View 2 Replies
Mar 12, 2012
I want a method of dealing with very, very, very big numbers (potentially a million digits). It is very cumbersome to deal with very big numbers in VB, would another language perhaps be better for that?
View 10 Replies
Jan 21, 2010
i have a datagridview binded with the datatable via its datasource property....now i want to add the Amount column of the dgv and display the total amount in the textbox,if the amount is greater than a certain value then i want the cell to coloured red so i did this code and it worked great:
Dim i, j As Integer
For i = 0 To DataGridView1.RowCount - 1
j += Me.DataGridView1.Rows(i).Cells("Amount").Value
Next
[code]....
but my problem is that i want the red colour of the cell to blinkafter every 2 seconds....how to do this?i need to handle the timer tick event for this but i am not able to do this.....
View 2 Replies
Aug 6, 2009
I'm searching the same title "Large amount of data in ComboBox" last 1 and half years but I could not get what I'm expecting! Here is my case, I have 20 thousand unique products, I just fill into dataset & bind only two columns in the combobox for searching & validating the product if it is exist in the product list or not.
1) I read about dataset but all articles are described "Dataset only for few records because it is sitting in-memory". If I fill few records (100 or 1000 products) into the dataset, how can I search & validate REMAINING (NOT FILLED) products?
2) Is there anyother way without filling into dataset and bind to combobox? Can anyone suggest me which is suitable for me?
View 14 Replies
Jun 19, 2010
Just a doubt: if I have large amount of image files for my app, is it ok to store them in the resource file ?
Will those files be saved in a single resource file ? Will that cause any problem to the performance of my app ? When I try to access a image file from the resource using code, will it load that file only into the memory or the entire image contents from the resource file ?
View 4 Replies
Dec 31, 2008
I'm loading an image, then getting size and such info from it, and loading the image into a picture box. Now it works and all, but I noticed it uses a large amount of memory. I'm doing: img = Image.FromFile(file)Where I load the image, 'file' being just a string containing path to an image on the hd. After that, I get the size and frame count (if any), and load it into a picture box: The image I've been testing with, is a 6600x5100 3.5MB JPEG, which can be downloaded from url...Watching task manager, when the app loads the image, it takes up about 104MB of memory. I've tried doing img.Dispose after the above line, but it brings up an error. If I put a button on the form with img.Dispose in it, and click it after app has loaded, it drops down to about 6MB of memory used. Loading the image directly into the picture box using .Load or .LoadAsync, after disposing img beforehand, still ends up with a huge amount of memory used.
So I'm wondering if theres a way to check if the picture box has fully loaded the img, so then I can Dispose the img and free up the memory. Or maybe a better way all together of loading an image into a picture box, and/or getting size & frame count, without having to use up that amount of memory before freeing.
View 2 Replies
Jul 22, 2009
I'm working on a project at the moment, where all the data being loaded is kept in an XML file which until now have been rather clean with structures such as
Code:
<Textures>
<Texture id="1">TerraingrassDirtNW.png</Texture>
[code].....
View 2 Replies
Jan 31, 2011
I tried to follow this advice, but I still run out of memory.
[URL]
Basically, I am reading all the bytes of a 1 gb disk and I want to try and do a md5 hash on it. However, when following this example, my cryptostream gets too large a System out of memory exception.
Is there another way to do the md5 hash over some much data?
I am currently reading it into 10 million bytes arrays at a time. Can I hash the first array, and then use it as a seed for the next array, and so one, like you might do to a CRC32 calculation?
View 2 Replies
Jan 7, 2011
I am trying to show a large amount of data in gridview but the problem is that everytime data increase the gridview row size increase automatically.
View 4 Replies
Nov 22, 2009
How do I display a large amount of fixed text (about 400 words) in a form. I also need to have scroll down bars.[code]...
View 1 Replies
May 23, 2012
There is a very strange problem with a Windows Service I am working on that I would like to understand why it occurs. The service loops every 5 minutes and then within that loop it loops through keys containing webservice URLs that are numbered such as:
<add key="URL.1" value="http://dummy1.com/Service.asmx"/>
<add key="URL.2" value="http://dummy2.com/Service.asmx"/>
<add key="URL.3" value="http://dummy3.com/Service.asmx"/>
The code that does this check is:
If String.IsNullOrEmpty(AppSettings("OM." & intCount & ".Name").ToString) Then
When it hits a key that doesn't exist an exception is thrown and the service stops and waits for 5 minutes until the next loop.This usually works great but every week or two the Windows service will crash on that line without any Exception. The application log has a line from before that line but nothing after, none of the Try Catches are hit (the main one is catching the base "Exception" class).In the Event Log for Windows is the following:
Faulting application name: MyService.exe, version: 1.1.2.0, time stamp: 0x4fa22a24
Faulting module name: KERNELBASE.dll, version: 6.1.7601.17651, time stamp: 0x4e211319
Exception code: 0xe053534f
[code]....
The weird part is that this line of code is executing fine 300 times a day for at least a week which is around 2000 times before that one time it causes a full crash of the application. why this is occurring? I have changed that line of code to not rely on Exceptions and it has been working fine for a week now with no crash so could be something to do with too many Exceptions - maybe causing a stack overflow?
View 1 Replies
Nov 21, 2009
I am trying to develop an app that will export a large amount of zip files all of which have the same single file in them - simply named 'dw' (with no extension). They will all be in the same directory. I want the file 'dw' to be renamed to the zip file name + .tif. (I will actually eventually need for this to use the magic number to determine if the file is a .tif or a .rtf.) I have been able to get it to cycle through, if the file is NOT renamed. I seem to run into issues when I want the file renamed. It just creates the first .tif file and thats it. I think its actually just cycling through but everything is getting that same name. For the record i am not a programmer by trade, just trying to help with something at work - thus I know the code I have peiced together probably isn't 'by the book'
Dim p As New ProcessStartInfo(ByVal unzipit As String, ByVal zipdir As String, ByVal arg As String, ByVal arg2 As String)
Dim di As System.IO.DirectoryInfo
di = New System.IO.DirectoryInfo(zipdir)
For Each diar In di.GetFiles()
[code]....
View 1 Replies
Nov 23, 2010
I need to count a large amount numbers in short time.As a result the CPU jumps to 40-60% on 4-core PC.Which is extremely high.I have any idea that will lock up the thread for some time, but not actually slow or reduce the amount of files that are allowed to be counted per a giving time period.
Vb.net
Application.DoEvents()
Threading.Thread.Sleep(1000)
View 9 Replies
Apr 15, 2012
I am wanting to create a large amount of files all copied from a single original file. I then have a list of names in a listbox that each of of these files will rename to. However I am getting an error saying that the file already exists in the save location even though the files are saving to a totally different folder...
code below.
Dim Counter As Integer = listFileNames.Items.Count
Do Until Counter = 0
System.IO.File.Move(txtOpen.Text, txtSave.Text)
[Code]....
View 1 Replies
Sep 2, 2011
I have a vb.net Windows application that calls a vb.net Web Service function. Both the vb.net application and Web Service have been in use for over 5 years and have worked well. The Windows App builds a text file consisting of a number of inserts into an Oracle table, followed by a call to an Oracle package. The Web Service call uploads the text file to the Web Server, loops through the statements in the text files and executes them. It then does a Select statement to put the resultant data in a string which is passed back to the calling program. We have both people on our local area network as well as external users where the call to the Web Server is over the internet.
The data string returned is the pricing for each of the lines inserted in the text file, separated by asterisks. Normal use of this call has anywhere from 1 to a few dozen lines, and the program works fine for this for both internal and external users.
Our problem right now is one external person is attempting to price a job with 491 individual line items. At first it would not price, whether the job was priced from a computer at the customers site or one of our internal people on the LAN. The problem turned out to be the timeout value was not long enough (it was set at 2 minutes, this job takes 5 minutes) so changing both the Timeout value in the Web Service call as well the httpRuntime executionTimeout value in the web.config file on the web server addressed the problem, but only for our internal users on the LAN. Our external customer wants to be able to price jobs of this size going forward, and I am at a loss as to why it errors on internet connected machines but not locally connected machines. Our customer is in New York, We are in Wisconsin, and I am able to recreate the error condition from my home computer.
The other thing is, if I create a VPN connection to our server from my computer at home, this job will price (again, it takes about 5 minutes) but if I disconnect the VPN connection, it gets an error after approximately 3 minutes, http 404: Not Found.The customer can otherwise price all of his other jobs with no problems, it's only this one, very large job that gets the error.
View 4 Replies
Jan 15, 2011
I am trying to find a way to show a large amount of data that spans across multiple forms and text boxes. I am making a somewhat summery of the input strings.
View 3 Replies
Oct 24, 2009
1. I having a project dealing with MsAccess database.
2. Currently the project connect the db using table adapter/data adapter method.
3. When I called a Me.SubjectCourseTableAdapter.Fill(Me.ProgrammingDataSet.Subject_Course) at frmCourse, it return me error message "System. NullReferenceException was unhandled Message="Object reference not set to an instance of an object.""
4. This line of code is just the same at frmA. Wonder why it will cause error at frmB.Besides, which is the better way to connect access? data adapter or ado.net?
View 3 Replies
Jul 14, 2009
I have the following search code which works fine. However, I have an additional task to do, which is create a count function for the Record found or Record not found. Presently what it does is it searches and if a record is found it displays at the tooltip "Record Found" if not it says "Record Not found". However, sometimes you have 2 or more records. Therefore, the tooltip should say the exact amount of records found.. For example, 3 Records Found or even 5 Records Found. Also if only one record is found it says "Record Found" but if more it should display " 2 Records Found".
Private Sub btnPerformSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPerformSearch.Click
' Declare local variables...
Dim intPosition As Integer
' Determine the appropriate item selected and set the
' Sort property of the DataView object...
[Code] .....
View 5 Replies
Sep 22, 2011
I have to export the data from the database to .txt file, I have the code below that does export it to .txt file but I'm having problems with this code because the data that I'm exporting is about 5 000000 records, it is quite slow and sometimes the pc can't handle it and stops the exporting.
Dim saveFile As New SaveFileDialog
If saveFile.ShowDialog = Windows.Forms.DialogResult.OK Then
command = New SqlCommand
[Code]....
View 5 Replies
May 26, 2010
If you are working on a large record in database. How you manage to use the INSERT,,UPDATE? I mean when selecting a record base on two tables or more and those tables consist of 20 columns it hazard to put all those columns in one query.
[code]...
How to lessen the code without typing all those queries over and over again ?
View 3 Replies
Sep 5, 2011
I want to load 2 crore records in a treeview control with parent child Hierarchy order
for example
- Groupa
- a1
- a2
[Code[....
View 1 Replies
Mar 18, 2011
I just learned some basics of multi threading in VB.net recently as I came across processing a large List of records and inserting them into SQL database one by one.
I have code look like this:
Private Sub btnLoadNow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadNow.Click
Dim autoLoad1 As New Thread(AddressOf AutoLoad)
autoLoad1.Start()
[CODE]...
Itemlists is a global lists i retrieved from database, everything looks fine to me but when i run this program, I found that the threads are inserting one records 9 times into the database(I have 9 threads in total), which makes me think that maybe i need to specifically assign 1/9 of a list to each thread? Is there another way to do it which doesn't require the splitting of the list, if not , how do i split it then assign?
View 1 Replies
May 4, 2010
im trying to make a simple program that calculates the time it takes to cover x amount off nautical miles at x amount off knots, the code i have so far is this :
Code:Public Class Form1 Private Sub Label2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label2.Click
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
[Code]...
so if i say want to cruise 29 miles at 12 knts it gives me an awnser of 2 hours 24.6 mins instead of 2 hours 25. Although i do realise that 2 hrs 24.6 is technicaly right i was wondering if anyone here could help me with getting it into the correct format?
View 4 Replies
Jun 7, 2011
im trying to make a fast food program on which the user will input the amount that he has, then he will check on what he wants, by using check boxes. There are 7 different check boxes with 7 different amounts of money. I have the program somewhat finished (thanks for the people that helped me before) but theres still a couple of things that I still need to get finished but I dont know how to.I need to be able to get how much money the user has (this will be entered threw a text box, I think I accidentally messed this part up, because I cant get it to work right, (theres alreasy a permit amount of money in there and it needs to be what the user enters instead of the permit, 5.59, one) and this will be the maximum amount he can spend, then the user will check on the food he wants (and the program will add the sales tax also) then it will produce an answer saying if you have enough money or if you dont. But what im confused on is how do I get the users amount of money and make it the maximum mount he can spend and make sure it doesnt go over the amount that he has checked.[code]
View 1 Replies
Apr 22, 2009
Is there a quick way of finding a character?? I have this error
Invalid character in the given encoding. Line 1, position 7173.
Eak, I need to know what this is but don't really want to count across 7000+ letters
View 2 Replies
Nov 25, 2009
I am working in a point of sale system in Vb express 2008. I want to convert the Amount in Figures to Words like: How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.
View 2 Replies
Nov 25, 2009
I am working in a point of sale system in Vb express 2008.I want to convert the Amount in Figures to Words like:How to conver the amount of $ 1,550,325.45 to Amount in words as DOLLARS: ONE MILLION, FIVE HUNDRED FIFTY THOUSAND, THREE HUNDRED TWENTY FIVE AND FORTY FIVE CENTS.Please advise how to code for that in Vb express.
View 5 Replies
