Click here to Skip to main content
15,919,358 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: using do...loop until Pin
Abbhie2-Oct-07 6:43
Abbhie2-Oct-07 6:43 
GeneralRe: using do...loop until Pin
Volker Weichert2-Oct-07 7:07
Volker Weichert2-Oct-07 7:07 
GeneralRe: using do...loop until Pin
Dave Kreskowiak2-Oct-07 8:11
mveDave Kreskowiak2-Oct-07 8:11 
GeneralRe: using do...loop until Pin
Abbhie3-Oct-07 2:48
Abbhie3-Oct-07 2:48 
GeneralRe: using do...loop until Pin
Dave Kreskowiak3-Oct-07 3:17
mveDave Kreskowiak3-Oct-07 3:17 
QuestionAuthenticating account using PrincipalPermission Pin
archangel_262-Oct-07 4:52
archangel_262-Oct-07 4:52 
AnswerRe: Authenticating account using PrincipalPermission Pin
Dave Kreskowiak2-Oct-07 8:09
mveDave Kreskowiak2-Oct-07 8:09 
QuestionSending manually created datatable to SQL server Pin
DA_Loring2-Oct-07 2:02
DA_Loring2-Oct-07 2:02 
Hi, I have an application that reads data from a text file into a datatable in the format required for a table in an SQL SErver 2005 database.

My question is, having filled the table 'manually' in memory, how do I connect that table to the database and insert the information? Obviously I can do inserts for each row in the datatable, but there are around 30,000 rows so I am looking for a faster method as this can take some time.

I understand that the dataadapter requires the insert command etc but 1) how do I get the table into the adapter and 2) does it know that these are new records?

Any help would be very geatly appreciated.

David Loring
!! Keep Music Live !!

AnswerRe: Sending manually created datatable to SQL server Pin
Colin Angus Mackay2-Oct-07 6:38
Colin Angus Mackay2-Oct-07 6:38 
AnswerRe: Sending manually created datatable to SQL server Pin
Dave Kreskowiak2-Oct-07 8:07
mveDave Kreskowiak2-Oct-07 8:07 
QuestionBlock Application Pin
SamRST2-Oct-07 1:36
SamRST2-Oct-07 1:36 
AnswerRe: Block Application Pin
Christian Graus2-Oct-07 2:04
protectorChristian Graus2-Oct-07 2:04 
GeneralRe: Block Application Pin
SamRST2-Oct-07 23:50
SamRST2-Oct-07 23:50 
AnswerRe: Block Application Pin
ESTAN2-Oct-07 2:05
ESTAN2-Oct-07 2:05 
GeneralRe: Block Application Pin
SamRST2-Oct-07 23:50
SamRST2-Oct-07 23:50 
QuestionHow detect IE activity like open, close, and navigate Pin
J. Pan2-Oct-07 1:30
J. Pan2-Oct-07 1:30 
AnswerRe: How detect IE activity like open, close, and navigate Pin
Christian Graus2-Oct-07 2:05
protectorChristian Graus2-Oct-07 2:05 
GeneralRe: How detect IE activity like open, close, and navigate Pin
GuyThiebaut2-Oct-07 5:35
professionalGuyThiebaut2-Oct-07 5:35 
GeneralRe: How detect IE activity like open, close, and navigate Pin
Christian Graus2-Oct-07 10:52
protectorChristian Graus2-Oct-07 10:52 
QuestionBack up Pin
naal_1234562-Oct-07 1:08
naal_1234562-Oct-07 1:08 
AnswerRe: Back up Pin
SamRST2-Oct-07 1:32
SamRST2-Oct-07 1:32 
QuestionAdd-in in VS 2005 does not correctly destroy itself when unloading studio Pin
vj20202-Oct-07 1:06
vj20202-Oct-07 1:06 
AnswerRe: Add-in in VS 2005 does not correctly destroy itself when unloading studio Pin
Dave Kreskowiak2-Oct-07 8:01
mveDave Kreskowiak2-Oct-07 8:01 
GeneralRe: Add-in in VS 2005 does not correctly destroy itself when unloading studio Pin
vj20202-Oct-07 18:28
vj20202-Oct-07 18:28 
GeneralRe: Add-in in VS 2005 does not correctly destroy itself when unloading studio Pin
Dave Kreskowiak3-Oct-07 3:14
mveDave Kreskowiak3-Oct-07 3:14 

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.