Click here to Skip to main content
15,917,610 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VB 6 and HTML Pin
Kehllendros29-Apr-04 5:06
Kehllendros29-Apr-04 5:06 
GeneralRe: VB 6 and HTML Pin
Dave Kreskowiak29-Apr-04 8:23
mveDave Kreskowiak29-Apr-04 8:23 
GeneralScanning image from scanner Pin
gthompson200528-Apr-04 7:00
gthompson200528-Apr-04 7:00 
GeneralRe: Scanning image from scanner Pin
vilhelmm1-May-04 0:59
vilhelmm1-May-04 0:59 
GeneralRe: Scanning image from scanner Pin
gthompson20051-May-04 10:35
gthompson20051-May-04 10:35 
GeneralNT Usergroup Pin
800XL28-Apr-04 5:38
800XL28-Apr-04 5:38 
GeneralRe: NT Usergroup Pin
Syed Abdul Khader28-Apr-04 19:00
Syed Abdul Khader28-Apr-04 19:00 
Generalhelp!! code execution taking to much time. Pin
Anonymous28-Apr-04 4:52
Anonymous28-Apr-04 4:52 
Hello,
I am new to vb.net and i am writing a billing application for a client. The application takes a bunch of raw numbers and does some filtering and calculations and puts time into different tables. The problem is that there are like 400,000 records of raw data. Now i put all the queries and calculations and filters in the onclick when the user hits the generate clean data button. The for is set up like this the user picks the month he wants to clean up by choosing the start date and enddate and then hits clean data button. My question is how can i make it go faster an I doing it wrong? It workes but it takes for ever like 20 mins and sometimes it freezes up. I will try and illistrate how i have it set up.

button_onclick
'first i get the raw data and up it into a new table
testdap.selectcommand.commandtext= "selece * form table"

for i=0 to dataset.table.row.count-1
cleandap.insertcommand.commandtext ="insert into cleantbl
(field1,field2,etc ) where (dataset.table.row(i).item("field1),etc)

I have like 17 of these actions where i get the data and put it in another table or clean it up and sometimes compare it to another table with thousands of records and if any two records match by account i put that row into another table. Well i hope you get the idea. I have all this being done when the user hits the button. Is there a better and fast way to do this, again i am know to .net and any help will be greatly appriciatied.

Thank you,

Santana
GeneralRe: help!! code execution taking to much time. Pin
Dave Kreskowiak28-Apr-04 5:09
mveDave Kreskowiak28-Apr-04 5:09 
GeneralRe: help!! code execution taking to much time. Pin
Serge Lobko-Lobanovsky10-May-04 2:09
Serge Lobko-Lobanovsky10-May-04 2:09 
GeneralJet question by a newbie Pin
Member 102309028-Apr-04 4:21
Member 102309028-Apr-04 4:21 
GeneralRe: Jet question by a newbie Pin
Dave Kreskowiak28-Apr-04 4:27
mveDave Kreskowiak28-Apr-04 4:27 
GeneralRe: Jet question by a newbie Pin
Member 102309028-Apr-04 4:33
Member 102309028-Apr-04 4:33 
GeneralTabbing Hell Pin
Greg Eales28-Apr-04 3:52
Greg Eales28-Apr-04 3:52 
Questioncan anybody give me code of getting RGB value form an image Pin
Member 41696028-Apr-04 2:34
Member 41696028-Apr-04 2:34 
AnswerRe: can anybody give me code of getting RGB value form an image Pin
Dave Kreskowiak28-Apr-04 3:59
mveDave Kreskowiak28-Apr-04 3:59 
GeneralNeed help with Loop and comparing values Pin
ingerXP27-Apr-04 22:49
ingerXP27-Apr-04 22:49 
GeneralRe: Need help with Loop and comparing values Pin
Syed Abdul Khader28-Apr-04 0:43
Syed Abdul Khader28-Apr-04 0:43 
GeneralRe: Need help with Loop and comparing values Pin
ingerXP28-Apr-04 23:52
ingerXP28-Apr-04 23:52 
GeneralRe: Need help with Loop and comparing values Pin
Ian Darling28-Apr-04 0:49
Ian Darling28-Apr-04 0:49 
GeneralRe: Need help with Loop and comparing values Pin
ingerXP28-Apr-04 23:45
ingerXP28-Apr-04 23:45 
GeneralCapturing Screenshots into an AVI file Pin
superwinsock27-Apr-04 19:03
superwinsock27-Apr-04 19:03 
GeneralRe: Capturing Screenshots into an AVI file Pin
Dave Kreskowiak28-Apr-04 1:19
mveDave Kreskowiak28-Apr-04 1:19 
GeneralRe: Capturing Screenshots into an AVI file Pin
superwinsock28-Apr-04 1:42
superwinsock28-Apr-04 1:42 
GeneralRe: Capturing Screenshots into an AVI file Pin
Dave Kreskowiak28-Apr-04 2:03
mveDave Kreskowiak28-Apr-04 2:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.