Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

VB .Net DataAdapter Problem

Posted on 2010-08-20
6
319 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
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 
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

How our DevOps Teams Maximize Uptime

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

Question has a verified solution.

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

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

828 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