How to add data to SQL server in MVC from one or multiple csv files in a folder.

Question

0.00/5 (No votes)

See more:

C#

I have to build a C# MVC web application. This is my first exposure to C# and MVC both. The requirement is that there could be one or more csv files with FileName_mm-dd-yyyy.csv. I need to add the data in these files to an SQL table which has one more column in the begining as a date which date in the file name -1.

I know how to use Database first to create the basic application with the default views. Can someone help me how to proceed from here onwards.

What I have tried:

This is my first experience with C# and MVC structure. I have so far learned how to build a basic application. I am planning to use database first approach here.

Posted 27-Sep-16 7:25am

DinoOnCodeProject

Updated 27-Sep-16 17:28pm

v2

Add a Solution

Comments

[no name] 27-Sep-16 13:52pm

What is your question? What one specific issue with the code that you have written is giving you problems? So far, your whole posting can be condensed to "I have a project to do. Can someone teach me programming in a forum posting?" and the answer is no we can't.

1 solution

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)

Karthik_Mahalingam · Accepted Answer · 2016-09-27T17:28:00

Solution 1

First you will have to analyse the strucutre of the data in the CSV file and based on that create schema for Tables in SQL.

refer these docs,
c# - How to read a CSV file into a .NET Datatable - Stack Overflow[^]
c# - Insert datatable in to sql table - Stack Overflow[^]
Comma-separated values [^]

Posted 27-Sep-16 17:28pm

Karthik_Mahalingam

Comments

DinoOnCodeProject 7-Nov-16 11:53am

Thanks a lot Karthik, the requirement was changed to create a console app which was quite easy for me using C# but the second link you advised was really helpful. Thanks a lot.

Karthik_Mahalingam 8-Nov-16 2:07am

welcome :)