?
Solved

VB .Net DataAdapter Problem

Posted on 2010-08-20
6
Medium Priority
?
325 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 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses
Course of the Month8 days, 9 hours left to enroll

621 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