I'm trying to write a unit text that will take records from excel file and insert them into a sql database?

Question

0.00/5 (No votes)

See more:

, +

Hi,

I don't know if I'm using the correct terminology, but I'm trying to use a unit test, or just a C# class file to pull records from an excel file(sheet) and insert them into a sql Database. Does anyone know of a good tutorial, book, or any resource at all I could learn how to do this. Also what this action is called. I'm saying Unit test because that's what I use at work all the time. The project I'm working on is all C# Class Files, no asp.net files at all. So I kind of need a class file for this as well. Eventually after I get this set up, I would like to repeat this action with any excel file that needs to be inserted into my Database.

Thanks, any help would be appreciated.
I'm also doing this in visual studio 2012. FYI.

Posted 13-Sep-14 14:09pm

Commish13

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2014-09-13T14:48:00

You probably want a Project/Solution with
1) a class to parse the data (see below), and then
2) a 'Database Layer' which can all be in one class for such a simple requirement, to connect to and add data to the table (it might also need to create the table(s) etc)

I'd save the data as a csv/text file and then have (as I noted) a csv parser that you use to parse line by line of the file, calling a method in the Database class to insert the data into a table

It really depends if this is a one-of or you need something more robust for multiple use - if this is the case, you could later switch the csv class for one that can natively handle excel files.

btw, there are oodles of csv parser classes around

kanjolia gopal · Answer 2 · 2014-09-16T21:24:00

Solution 2

Hi Check this given Link

http://www.c-sharpcorner.com/UploadFile/99bb20/import-excel-data-to-sql-server-in-Asp-Net/

Posted 16-Sep-14 21:24pm

kanjolia gopal