How to validate the csv file in asp.net with C#

Question

2.53/5 (3 votes)

See more:

Hi,

I am working on uploading the csv file and saving the data into database. I have done with saving part but what i need is to validate the csv with correct data farmat.

-----------------------------------------------
Name  Address    Age  Gender
---------------------------------------------
a     Hyderabad  23    M
b     Banglore   25    F
c     Mumbai     26    M
---------------------------------------------

The Data In csv file need to be In above format while upload. If they enter data in below format and trying to upload it then an error message need to be display saying "Upload Valid CSV File".

-----------------------------------------------
Name  Address   (Column Name Is missing)  Gender| Column0
--------------------------------------------
a     Hyderabad            23                M   ( Some Junk Data)
b     Banglore             25                F       | 
c     Mumbai               26                M       |
---------------------------------------------
 
--------------------------------------------
Xyz        olp
--------------------------------------------

I have googled a lot but did not found valid links which suits for my problem.

Posted 28-Aug-14 0:00am

santoshkumar413

Updated 28-Aug-14 1:22am

Nelek

v2

Add a Solution

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)

vangapally Naveen Kumar · Answer 1 · 2014-08-28T00:19:00

1.If column names are fixed means you already know column names compare the column names with data base column names.
To do this first fill the data table from excel then you compare with column names.

C#

ConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", @"C:\file.xlsx"); 

objConn.Open(); 
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM ["xlWorksheet"$]", objConn); 

OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); 

objAdapter1.SelectCommand = objCmdSelect; 

DataSet objDataset1 = new DataSet(); 

objAdapter1.Fill(objDataset1); 

objConn.Close();

C#

// For each DataTable, print the ColumnName.
foreach(DataTable table in objDataset1 .Tables)
{
    foreach(DataColumn column in table.Columns)
    {
        Console.WriteLine(column.ColumnName);// gives the all column names in excel.
//compare here columns
    }
}