Click here to Skip to main content
15,893,668 members
Articles / Web Development / ASP.NET

A Fast CSV Reader

Rate me:
Please Sign up or sign in to vote.
4.93/5 (545 votes)
13 Jan 2016MIT8 min read 8.5M   164.8K   1.5K  
A reader that provides fast, non-cached, forward-only access to CSV data.
using System;
using System.IO;
using System.Web.UI;
using System.Web.UI.WebControls;

using LumenWorks.Framework.IO.Csv;
using LumenWorks.Framework.Tests.Unit.IO.Csv;

namespace CsvReaderDemoWeb
{
	public partial class _Default 
		: System.Web.UI.Page
	{
		protected void btnBind_Click(object sender, EventArgs e)
		{
			using (CsvReader csv = new CsvReader(new StringReader(CsvReaderSampleData.SampleData1), true))
			{
				rptSampleData.DataSource = csv;
				rptSampleData.DataBind();
			}
		}

		protected void rptSampleData_ItemDataBound(object sender, RepeaterItemEventArgs e)
		{
			string[] dataItem = (string[]) e.Item.DataItem;

			((ITextControl) e.Item.FindControl("lblFirstName")).Text = dataItem[0];
			((ITextControl) e.Item.FindControl("lblLastName")).Text = dataItem[1];
			((ITextControl) e.Item.FindControl("lblAddress")).Text = dataItem[2];
			((ITextControl) e.Item.FindControl("lblCity")).Text = dataItem[3];
			((ITextControl) e.Item.FindControl("lblState")).Text = dataItem[4];
			((ITextControl) e.Item.FindControl("lblZipCode")).Text = dataItem[5];
		}
	}
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The MIT License


Written By
Architect
Canada Canada
Sébastien Lorion is software architect as day job.

He is also a musician, actually singing outside the shower Smile | :)

He needs constant mental and emotional stimulation, so all of this might change someday ...

Comments and Discussions