During the course of time, I often required to write solutions which involve reading CSV (Comma Separated Values) Files. After repeating the same thing for a few times, I decided to write a component that will parse the CSV file and return a DataTable.

To use the the component is really simple. First you need to declare the object,

    CsvDataSource.CsvDataSource src = new CsvDataSource.CsvDataSource();

and then read the CSV file. There are three possible way to read the CSV:

    //Using comma as character separator, first line is NOT treated as column names
    DataTable dt1 = src.ReadFile("input.csv"); 

    //Using comma as separator character, first line is treated as column names
    DataTable dt2 = src.ReadFile("input.csv", true); 

    //Using pipe (|) as separator character, first line is treated as column names
    DataTable dt3 = src.ReadFile("input.csv", true, '|');

The complete source code as follows: Download the class source code.

Simple demo using Command Line Application:

/* Demo of CsvDataSource using Command Line Application
 * (c) 2007 Hardono Arifanto
 * http://sodeve.net
 */
using System;
using System.Collections.Generic;
using System.Text;
using CsvDataSource;
using System.Data;

namespace CsvDataSourceDemo
{
    class Program
    {
        private static void printHelp()
        {
            Console.WriteLine(@"Demo for CsvDataSource.
    Usage: CsvDataSourceDemo [inputfile.csv]");
        }
        static void Main(string[] args)
        {
            DataTable dt;
            if (args.Length > 0)
            {
                CsvDataSource.CsvDataSource src = new CsvDataSource.CsvDataSource();
                dt = src.ReadFile(args[0],true,',');
                //Display the DataTable content
                foreach (DataColumn dc in dt.Columns)
                {
                    Console.Write(dc.ColumnName + "t");
                }
                Console.WriteLine();
                foreach (DataRow dr in dt.Rows)
                {
                    for(int i=0; i < dt.Columns.Count; i++)
                    {
                        Console.Write(dr[i] + "t");
                    }
                    Console.WriteLine();
                }
            }
            else
                printHelp();
        }
    }
}

 

Possibly Related Posts

• Create Drag-and-Drog File Path Locator
• How to Write Email Subject Better

 

net read csv file (10), read csv file in net (5), net csv file (2), csv files net (2), reading csv file in net (2), read csv file to datatable get column names (1), read csv file through net (1), read csv file net (1), how to read the csv file using CsvDataSource (1), read csv file class net (1), net read a csv (1), net csv file reader (1), Read csv file with net (1), read csv files using net (1), read csv to datatable asp net (1), vb net csvdatasource (1), reading first row csv file in asp net (1), reading csv file net (1), reading csv file in net code (1), reading csv file from net (1), reading a csv file with net (1), reading a csv file in net (1), read gmail using vb net (1), read gmail csv using net (1), vb net working with csv files (1), net components to read csv files (1), dotnet read csv file (1), csv files in net (1), csv files for net (1), csv file parsing net (1)

Advertise Here