AspDotNetAtoms.com provides daily updates on ASP.NET Tutorials, Programming Resources, .NET Articles, Authors and more.

Categories

Recent Posts

Flat File Data Reader :

Monday, September 01 2008

An abstract IDataReader implementation that reads flat files. Enables bulk loading of SQL Server using SqlBulkCopy from flat files with strange formats. For ordinary delimited or fixed-width files, SSIS is a better tool, but when your file format doesn't work well with these tools or you need a pure .NET solution, consider using this FlatFileDataReader. Includes the option to skip over lines in the file for multi-format files. Good scenarios are loading from clients (without SSIS), and loading files with multiple record layouts, heders and footers, etc. The FlatFileDataReader base class will process the file line-by-line. Each line will be passed to an abstract class member for you to parse out the column values and store them in local variables....

Read More:
Flat File Data Reader :
Also See:
Performing Batch Deletes from the Database : Scott Mitchell
Learn The Basics Of LINQ : Timothy Khouri
Refresh GridView in Parent Page : AzamSharp
Master/Detail Filtering With a DropDownList : Scott Mitchell
Using Parameterized Queries with the SqlDataSource : Scott Mitchell

Post your comment

Comment