Its long time since I used ASP or .Net. But today however I got a chance to review a .Net component called DataStreams
It is basically a component library for .Net developers to easily integrate data from various formats like CSV, Excel, and XML into their applications. CSV Reader is an extensively fast, reliable and perfectly stable .Net class that can manage stream based parsing of virtually all kinds of commonly used delimited data format such as CSV files, tab delimited files, and all other kind of data delimited files.
CSVreader class can be used from C#, VB.Net, ASP.Net, or any other .Net language. The Datastreams group has made CSV reader as fully compatible with version 1.0, 1.1, and version 2.0 of the .Net frameworks. The methods of the csvreader have been designed as user friendly as possible, while the inner architecture is designed purely for speed and higher degree of efficiency without inducing loads on the system unnecessarily.
CSVreader parses the delimited data source using the standard CSV file specifications. Csvreader handles quoted fields, delimiters in the data, and even data that spans across multiple lines. This gives you the ability to open csv files, edit csv files, and save csv files all directly from code. This provides a magnificent ease of use of the datafile in any application using the csvreader class from datastreams website.
The CSVreader.com web site provides downloadable versions of the DataStreams class so that users may download the class, integrate and use it in their application and then when they are satisfied by the overall power of the Datastreams, they can later buy the class and use all its potential featres empowering the application to even work with csv files at their full ease.
SPECIAL FEATURES:
* Stream based file parsing allowing for parsing of large files without storing the entire file contents in memory
* Simple reader pattern movement through file
* Simple access to field data by index or by field name
* Internal parsing using arrays instead of strings for fast looping over large files
* Uses built in framework functionality to handle most encoding issues instead of guessing or hardcoding
* Includes a CSV writer to ease the worries while creating CSV data. No more needing to worry about what to replace with what to match up with delimiters, text qualifiers, etc
Speed comparison chart: