Solved

VB .Net DataAdapter Problem

Posted on 2010-08-20
6
318 Views
Last Modified: 2012-06-22
Hi Everyone,

My question is faily straightforward (i think).  

I have a dataset full of 20,000 rows of data (obtained from an excel spreadheet) that I would like to insert into a database table.  I'm not sure how to do it.  I think I may need to use a dataAdapter and the associated InsertCommand, but I'm somewhat lost. Can anyone provide example code to help me out? Thanks!
0
Comment
Question by:jacksonm1234
  • 3
  • 2
6 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 33488115
0
 
LVL 2

Author Comment

by:jacksonm1234
ID: 33488178
Thanks for your reply.
First link -- I'm not interested in VB6.
Second link -- I dont think there is any mention of visual basic .net in any of those replies.
 
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33488213
What kind of database you want to use?
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 2

Author Comment

by:jacksonm1234
ID: 33488271
Eventually, I'll put it into a Teradata table (using an ODBC driver).
Conceptually, though, I dont know how I would do it using ANY database.  I mean, it wouldn't make sense to set up a loop that inserts each row one by one, would it?
That's why I thought a dataadapter may be the answer, but I'm not sure how I would put it together.
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33489427
0
 
LVL 2

Accepted Solution

by:
jacksonm1234 earned 0 total points
ID: 33521642
jtoutou:
The problem was getting the data from a dataset to a database, not getting excel data into a dataset.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question