Click here to Skip to main content
15,902,189 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: VB.NET application to login in Website Pin
Tony Richards28-Dec-08 1:34
Tony Richards28-Dec-08 1:34 
AnswerRe: VB.NET application to login in Website Pin
Mycroft Holmes28-Dec-08 15:10
professionalMycroft Holmes28-Dec-08 15:10 
QuestionWindows Mobile Toolbar Pin
UniBond27-Dec-08 14:58
UniBond27-Dec-08 14:58 
QuestionVB.NET - OLEDB with Foxpro table Pin
iluha27-Dec-08 13:49
iluha27-Dec-08 13:49 
AnswerRe: VB.NET - OLEDB with Foxpro table Pin
CodingYoshi27-Dec-08 21:56
CodingYoshi27-Dec-08 21:56 
GeneralRe: VB.NET - OLEDB with Foxpro table Pin
iluha28-Dec-08 4:26
iluha28-Dec-08 4:26 
GeneralRe: VB.NET - OLEDB with Foxpro table Pin
CodingYoshi29-Dec-08 3:18
CodingYoshi29-Dec-08 3:18 
GeneralRe: VB.NET - OLEDB with Foxpro table Pin
Ben Fair29-Dec-08 8:54
Ben Fair29-Dec-08 8:54 
FoxPro has indexing on it's tables using either IDX or CDX files, they'll have the same name as the .DBF file, but with a different extension; that is if there are any indexes on the table. Hopefully, there is an index on the zipcode field that can be used to speed up the look up queries. From my experience with OLEDB, it's generally faster to send as few commands as possible, so build a single query like:

select zipcode from zipcodes where zipcode in (... comma-separated list of zip codes ...)

This query of course will perform much better if there is an index on the zipcode field. It will give you the list of zipcodes that exist and need to be UPDATEd and ones that aren't in the result set will be INSERTs.

Keep It Simple Stupid! (KISS)

QuestionVB.net & XML Pin
Shazz Rock26-Dec-08 21:50
Shazz Rock26-Dec-08 21:50 
AnswerRe: VB.net & XML Pin
Guffa27-Dec-08 3:58
Guffa27-Dec-08 3:58 
Questionresizing a tree node Pin
Sanam26-Dec-08 21:07
Sanam26-Dec-08 21:07 
AnswerRe: resizing a tree node Pin
Dave Kreskowiak27-Dec-08 5:51
mveDave Kreskowiak27-Dec-08 5:51 
GeneralAnyone with web browser making experience please read this! Pin
113st4life26-Dec-08 20:43
113st4life26-Dec-08 20:43 
GeneralRe: Anyone with web browser making experience please read this! Pin
Colin Angus Mackay27-Dec-08 8:30
Colin Angus Mackay27-Dec-08 8:30 
GeneralRe: Anyone with web browser making experience please read this! Pin
Mycroft Holmes28-Dec-08 16:20
professionalMycroft Holmes28-Dec-08 16:20 
GeneralRe: Anyone with web browser making experience please read this! Pin
113st4life28-Dec-08 22:20
113st4life28-Dec-08 22:20 
QuestionCrystal Report Opening Problem. Pin
Nanda_MR26-Dec-08 18:26
Nanda_MR26-Dec-08 18:26 
QuestionNeed similar Coding for Treeview Pin
bharanidharanit26-Dec-08 15:46
bharanidharanit26-Dec-08 15:46 
AnswerRe: Need similar Coding for Treeview Pin
bharanidharanit28-Dec-08 14:39
bharanidharanit28-Dec-08 14:39 
Questioncrystal report with vb6 Pin
blade0426-Dec-08 7:38
blade0426-Dec-08 7:38 
AnswerRe: crystal report with vb6 Pin
Christian Graus26-Dec-08 12:12
protectorChristian Graus26-Dec-08 12:12 
Generalhello Pin
blade0426-Dec-08 7:31
blade0426-Dec-08 7:31 
GeneralRe: hello Pin
Christian Graus26-Dec-08 12:12
protectorChristian Graus26-Dec-08 12:12 
QuestionFirst Question - Problem repainting datagridview Pin
snakeyes200226-Dec-08 5:40
snakeyes200226-Dec-08 5:40 
AnswerRe: First Question - Problem repainting datagridview Pin
Mycroft Holmes28-Dec-08 16:29
professionalMycroft Holmes28-Dec-08 16:29 

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.