Reading csv file into datatable.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

archana - 14 Jun 2007 05:52 GMT

Hi all,

I want to read csv file into datatable. Is there any csv reader and
writer available for freeware.

I am reading csv file using schema.ini file. I don't want this
dependency. The problem while reading csv is that datatype depend on
first 8 or 16 rows depend in value set in registry.

Is there any option provided in framework 2.0 to read content of csv
file into datatable properly means without truncation or without data
type conversion?

Please help me asap.

thanks in advance.

Reply to this Message

Samuel R. Neff - 14 Jun 2007 06:02 GMT

This is a really wonderful CSV reader. Download project even includes
500+ unit tests.

http://www.codeproject.com/cs/database/CsvReader.asp

Provides both a custom api and an IDataReader implementation.

HTH,

Sam

------------------------------------------------------------
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.

>Hi all,
>
[quoted text clipped - 12 lines]
>
>thanks in advance.

Reply to this Message

Marc Gravell - 14 Jun 2007 08:09 GMT

Seconded; I use that reader; very effective.

Marc

Reply to this Message

Michael Nemtsev - 14 Jun 2007 08:52 GMT

Hello archana,

Alternative solution is to use SQL DTS

---
WBR, Michael Nemtsev [.NET/C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

a> Hi all,
a>
a> I want to read csv file into datatable. Is there any csv reader and
a> writer available for freeware.
a>
a> I am reading csv file using schema.ini file. I don't want this
a> dependency. The problem while reading csv is that datatype depend on
a> first 8 or 16 rows depend in value set in registry.
a>
a> Is there any option provided in framework 2.0 to read content of csv
a> file into datatable properly means without truncation or without data
a> type conversion?
a>
a> Please help me asap.
a>
a> thanks in advance.
a>

Reply to this Message

archana - 15 Jun 2007 06:15 GMT

Hi all,

thanks for replies.

I want to do some validation on that csv file and also wants to update
that csv file. So my preference is to use it in code in service.

I am facing 2 major problem one is of datatype conversion and other is
if file name contains dot then its not working.

Can you tell me how to solve both this problem.

I am expecting some way to remove this limitation. Is there any
solution in framework 2.0 for this.

thanks in advance.

Reply to this Message

Reading csv file into datatable.

Free Magazines