Source Forge Support This Project
sync toc
Introduction
Downloads
History
Screencasts and Movies
Powered By ...
Must Read
Quick Start Delimited
Quick Start Fixed Length
Quick Start Record by Record
Attributes List
Converters Arguments
.NET 2.0 Generics
RunTime Records
Events
Record Class Wizard
Tips for VB.NET
Contact and Credits
Examples of Use
Easy Example
Easy Example(Generics)
Error Handling
Nullable Types
Delimited File Engine
Fixed File Engine
RunTime Records
Record Conditions
Master-Details 1
Master-Details 2
MultiRecordEngine
Async Example
Enum Converter
Common Engine
Progress Notification
Decimal Converter
DataLink Example
SqlServerStorage ExtractRecords
SqlServerStorage InsertRecords
ExcelStorage Example
File Transform Engine
More Info
Roadmap
How Help Us
Library Statistics
FileHelpers on the Web
Library Testing
F.A.Q.
Class Diagrams
Engines Diagram
DataStorages Diagram
DataLinks Diagram
RunTime Records Diagram
Support Forums
FileHelpers on SourceForge
FileHelpers
AfterReadRecordEventArgs Class
AfterReadRecordEventArgs Members
Properties
Record Property
SkipThisRecord Property
AfterReadRecordHandler Delegate
AfterWriteRecordEventArgs Class
AfterWriteRecordEventArgs Members
Properties
RecordLine Property
AfterWriteRecordHandler Delegate
AlignMode Enumeration
BadUsageException Class
BeforeReadRecordEventArgs Class
BeforeReadRecordEventArgs Members
Properties
SkipThisRecord Property
BeforeReadRecordHandler Delegate
BeforeWriteRecordEventArgs Class
BeforeWriteRecordEventArgs Members
Properties
SkipThisRecord Property
BeforeWriteRecordHandler Delegate
CommonEngine Class
CommonEngine Members
Methods
CsvToDataTable Method
CsvToDataTable Method (String, CsvOptions)
CsvToDataTable Method (String, Char)
CsvToDataTable Method (String, String, Char)
CsvToDataTable Method (String, String, Char, Boolean)
DataTableToCsv Method
DataTableToCsv Method (DataTable, String)
DataTableToCsv Method (DataTable, String, CsvOptions)
DataTableToCsv Method (DataTable, String, Char)
MergeAndSortFile Method
MergeAndSortFile Method (Type, String, String, String)
MergeAndSortFile Method (Type, String, String, String, String)
MergeAndSortFile Method (Type, String, String, String, String, Boolean)
MergeFiles Method
RawReadAllFile Method
RawReadFirstLines Method
ReadFile Method
ReadFile Method (Type, String)
ReadFile Method (Type, String, Int32)
ReadFileAsDT Method
ReadFileAsDT Method (Type, String)
ReadFileAsDT Method (Type, String, Int32)
ReadSortedFile Method
ReadString Method
ReadString Method (Type, String)
ReadString Method (Type, String, Int32)
RecordsToDataTable Method
RecordsToDataTable Method (ICollection)
RecordsToDataTable Method (ICollection, Int32)
RecordsToDataTable Method (ICollection, Type)
RecordsToDataTable Method (ICollection, Type, Int32)
RemoveDuplicateRecords Method
SortFile Method
SortFileByField Method
SortRecords Method
SortRecordsByField Method
SortRecordsByField Method (Object[], String)
SortRecordsByField Method (Object[], String, Boolean)
TransformFile Method
TransformFileAsync Method
WriteFile Method
WriteString Method
ConditionalRecordAttribute Class
ConditionalRecordAttribute Members
ConditionalRecordAttribute Constructor
ConverterBase Class
ConverterBase Members
Properties
DefaultDateTimeFormat Property
Methods
FieldToString Method
StringToField Method
ConverterKind Enumeration
ConvertException Class
ConvertException Members
ConvertException Constructor
ConvertException Constructor (String, Type)
ConvertException Constructor (String, Type, String)
ConvertException Constructor (String, Type, String, Int32, Int32, String)
Properties
ColumnNumber Property
FieldName Property
FieldStringValue Property
FieldType Property
LineNumber Property
MessageExtra Property
CsvEngine Class
CsvEngine Members
CsvEngine Constructor
CsvEngine Constructor (String, Char, String)
CsvEngine Constructor (String, Char, Int32)
CsvEngine Constructor (CsvOptions)
Methods
CsvToDataTable Method
CsvToDataTable Method (String, CsvOptions)
CsvToDataTable Method (String, Char)
CsvToDataTable Method (String, String, Char)
CsvToDataTable Method (String, String, Char, Boolean)
DataTableToCsv Method
DataTableToCsv Method (DataTable, String)
DataTableToCsv Method (DataTable, String, CsvOptions)
CsvOptions Class
CsvOptions Members
CsvOptions Constructor
CsvOptions Constructor (String, Char, Int32)
CsvOptions Constructor (String, Char, String)
Properties
DateFormat Property
DecimalSeparator Property
Delimiter Property
Encoding Property
FieldsPrefix Property
HeaderDelimiter Property
HeaderLines Property
NumberOfFields Property
RecordClassName Property
SampleFileName Property
DelimitedFileEngine Class
DelimitedFileEngine Members
DelimitedFileEngine Constructor
Properties
Options Property
DelimitedRecordAttribute Class
DelimitedRecordAttribute Members
DelimitedRecordAttribute Constructor
DelimitedRecordOptions Class
DelimitedRecordOptions Members
Properties
Delimiter Property
ErrorInfo Class
ErrorInfo Members
Properties
ExceptionInfo Property
LineNumber Property
RecordString Property
ErrorManager Class
ErrorManager Members
ErrorManager Constructor
ErrorManager Constructor ()
ErrorManager Constructor (ErrorMode)
Properties
ErrorCount Property
ErrorMode Property
Errors Property
HasErrors Property
Methods
ClearErrors Method
LoadErrors Method
SaveErrors Method
SaveErrors Method (String)
SaveErrors Method (String, String)
ErrorMode Enumeration
FieldAlignAttribute Class
FieldAlignAttribute Members
FieldAlignAttribute Constructor
FieldAlignAttribute Constructor (AlignMode)
FieldAlignAttribute Constructor (AlignMode, Char)
FieldConverterAttribute Class
FieldConverterAttribute Members
FieldConverterAttribute Constructor
FieldConverterAttribute Constructor (ConverterKind)
FieldConverterAttribute Constructor (ConverterKind, String)
FieldConverterAttribute Constructor (ConverterKind, String, String)
FieldConverterAttribute Constructor (ConverterKind, String, String, String)
FieldConverterAttribute Constructor (Type, String)
FieldConverterAttribute Constructor (Type, String, String)
FieldConverterAttribute Constructor (Type, String, String, String)
FieldConverterAttribute Constructor (Type, Object[])
FieldConverterAttribute Constructor (Type)
FieldDelimiterAttribute Class
FieldDelimiterAttribute Members
FieldDelimiterAttribute Constructor
FieldFixedLengthAttribute Class
FieldFixedLengthAttribute Members
FieldFixedLengthAttribute Constructor
FieldIgnoredAttribute Class
FieldIgnoredAttribute Members
FieldIgnoredAttribute Constructor
FieldInNewLineAttribute Class
FieldInNewLineAttribute Members
FieldInNewLineAttribute Constructor
FieldNullValueAttribute Class
FieldNullValueAttribute Members
FieldNullValueAttribute Constructor
FieldNullValueAttribute Constructor (Object)
FieldNullValueAttribute Constructor (Type, String)
FieldOptionalAttribute Class
FieldOptionalAttribute Members
FieldOptionalAttribute Constructor
FieldQuotedAttribute Class
FieldQuotedAttribute Members
FieldQuotedAttribute Constructor
FieldQuotedAttribute Constructor ()
FieldQuotedAttribute Constructor (Char)
FieldQuotedAttribute Constructor (QuoteMode)
FieldQuotedAttribute Constructor (QuoteMode, MultilineMode)
FieldQuotedAttribute Constructor (Char, QuoteMode)
FieldQuotedAttribute Constructor (Char, QuoteMode, MultilineMode)
FieldQuotedAttribute Constructor (MultilineMode)
FieldTrimAttribute Class
FieldTrimAttribute Members
FieldTrimAttribute Constructor
FieldTrimAttribute Constructor (TrimMode)
FieldTrimAttribute Constructor (TrimMode, Char[])
FieldTrimAttribute Constructor (TrimMode, String)
FileDiffEngine Class
FileDiffEngine Members
FileDiffEngine Constructor
Methods
OnlyDuplicatedRecords Method
OnlyMissingRecords Method
OnlyNewRecords Method
OnlyNoDuplicatedRecords Method
WriteNewRecords Method
FileHelperAsyncEngine Class
FileHelperAsyncEngine Members
FileHelperAsyncEngine Constructor
FileHelperAsyncEngine Constructor (Type)
FileHelperAsyncEngine Constructor (Type, Encoding)
Properties
LastRecord Property
Methods
BeginAppendToFile Method
BeginReadFile Method
BeginReadStream Method
BeginReadString Method
BeginWriteFile Method
BeginWriteStream Method
Close Method
Flush Method
ReadNext Method
ReadNexts Method
IEnumerable.GetEnumerator Method
IDisposable.Dispose Method
WriteNext Method
WriteNexts Method
FileHelperEngine Class
FileHelperEngine Members
FileHelperEngine Constructor
FileHelperEngine Constructor (Type)
FileHelperEngine Constructor (Type, Encoding)
Properties
Options Property
Methods
AppendToFile Method
AppendToFile Method (String, IEnumerable)
AppendToFile Method (String, Object)
ReadFile Method
ReadFile Method (String)
ReadFile Method (String, Int32)
ReadFileAsDT Method
ReadFileAsDT Method (String)
ReadFileAsDT Method (String, Int32)
ReadStream Method
ReadStream Method (TextReader)
ReadStream Method (TextReader, Int32)
ReadStreamAsDT Method
ReadStreamAsDT Method (TextReader)
ReadStreamAsDT Method (TextReader, Int32)
ReadString Method
ReadString Method (String)
ReadString Method (String, Int32)
ReadStringAsDT Method
ReadStringAsDT Method (String)
ReadStringAsDT Method (String, Int32)
WriteFile Method
WriteFile Method (String, IEnumerable)
WriteFile Method (String, IEnumerable, Int32)
WriteStream Method
WriteStream Method (TextWriter, IEnumerable)
WriteStream Method (TextWriter, IEnumerable, Int32)
WriteString Method
WriteString Method (IEnumerable)
WriteString Method (IEnumerable, Int32)
Events
AfterReadRecord Event
AfterWriteRecord Event
BeforeReadRecord Event
BeforeWriteRecord Event
FileHelpersException Class
FileHelpersException Members
FileHelpersException Constructor
FileHelpersException Constructor (String)
FileHelpersException Constructor (String, Exception)
FileTransformEngine Class
FileTransformEngine Members
FileTransformEngine Constructor
Properties
DestinationEncoding Property
DestinationType Property
SourceEncoding Property
SourceType Property
Methods
ReadAndTransformRecords Method
TransformFile Method
TransformFileAsync Method
TransformRecords Method
FixedFileEngine Class
FixedFileEngine Members
FixedFileEngine Constructor
Properties
Options Property
FixedLengthRecordAttribute Class
FixedLengthRecordAttribute Members
FixedLengthRecordAttribute Constructor
FixedLengthRecordAttribute Constructor ()
FixedLengthRecordAttribute Constructor (FixedMode)
FixedMode Enumeration
FixedRecordOptions Class
FixedRecordOptions Members
Properties
FixedMode Property
RecordLength Property
IComparableRecord Interface
IComparableRecord Members
Methods
IsEqualRecord Method
IgnoreCommentedLinesAttribute Class
IgnoreCommentedLinesAttribute Members
IgnoreCommentedLinesAttribute Constructor
IgnoreCommentedLinesAttribute Constructor (String)
IgnoreCommentedLinesAttribute Constructor (String, Boolean)
IgnoreEmptyLinesAttribute Class
IgnoreEmptyLinesAttribute Members
IgnoreEmptyLinesAttribute Constructor
IgnoreEmptyLinesAttribute Constructor ()
IgnoreEmptyLinesAttribute Constructor (Boolean)
IgnoreFirstAttribute Class
IgnoreFirstAttribute Members
IgnoreFirstAttribute Constructor
IgnoreFirstAttribute Constructor ()
IgnoreFirstAttribute Constructor (Int32)
IgnoreLastAttribute Class
IgnoreLastAttribute Members
IgnoreLastAttribute Constructor
IgnoreLastAttribute Constructor ()
IgnoreLastAttribute Constructor (Int32)
INotifyRead Interface
INotifyRead Members
Methods
AfterRead Method
INotifyWrite Interface
INotifyWrite Members
Methods
BeforeWrite Method
MultilineMode Enumeration
MultiRecordEngine Class
MultiRecordEngine Members
MultiRecordEngine Constructor
MultiRecordEngine Constructor (Type[])
MultiRecordEngine Constructor (RecordTypeSelector, Type[])
Properties
LastRecord Property
RecordSelector Property
Methods
AppendToFile Method
AppendToFile Method (String, IEnumerable)
AppendToFile Method (String, Object)
BeginAppendToFile Method
BeginReadFile Method
BeginReadStream Method
BeginReadString Method
BeginWriteFile Method
BeginWriteStream Method
Close Method
Flush Method
ReadFile Method
ReadNext Method
ReadNexts Method
ReadStream Method
ReadString Method
IEnumerable.GetEnumerator Method
IDisposable.Dispose Method
WriteFile Method
WriteFile Method (String, IEnumerable)
WriteFile Method (String, IEnumerable, Int32)
WriteNext Method
WriteNexts Method
WriteStream Method
WriteStream Method (TextWriter, IEnumerable)
WriteStream Method (TextWriter, IEnumerable, Int32)
WriteString Method
WriteString Method (IEnumerable)
WriteString Method (IEnumerable, Int32)
Events
AfterReadRecord Event
AfterWriteRecord Event
BeforeReadRecord Event
BeforeWriteRecord Event
NetLanguage Enumeration
NetVisibility Enumeration
ProgressChangeHandler Delegate
ProgressEventArgs Class
ProgressEventArgs Members
Properties
ProgressCurrent Property
ProgressMode Property
ProgressTotal Property
ProgressMode Enumeration
QuoteMode Enumeration
RecordCondition Enumeration
RecordOptions Class
RecordOptions Members
Properties
IgnoreCommentedLines Property
IgnoreEmptyLines Property
IgnoreFirstLines Property
IgnoreLastLines Property
RecordCondition Property
RecordOptions.IgnoreCommentInfo Class
RecordOptions.IgnoreCommentInfo Members
Properties
CommentMarker Property
InAnyPlace Property
RecordOptions.RecordConditionInfo Class
RecordOptions.RecordConditionInfo Members
Properties
Condition Property
Selector Property
RecordTypeSelector Delegate
TransformToRecordAttribute Class
TransformToRecordAttribute Members
TransformToRecordAttribute Constructor
TrimMode Enumeration
FileHelpers.DataLink
AccessStorage Class
AccessStorage Members
AccessStorage Constructor
AccessStorage Constructor (Type)
AccessStorage Constructor (Type, String)
Properties
AccessFileName Property
AccessFilePassword Property
DatabaseStorage Class
DatabaseStorage Members
Properties
ConnectionString Property
ExecuteInBatchSize Property
FillRecordCallback Property
InsertSqlCallback Property
SelectSql Property
TransactionMode Property
Methods
ExtractRecords Method
InsertRecords Method
DataStorage Class
DataStorage Members
Properties
ErrorManager Property
RecordType Property
Methods
ExtractRecords Method
ExtractRecordsAsDT Method
InsertRecords Method
SetProgressHandler Method
SetProgressHandler Method (ProgressChangeHandler)
SetProgressHandler Method (ProgressChangeHandler, ProgressMode)
ExcelBadUsageException Class
ExcelDataLink Class
ExcelDataLink Members
ExcelDataLink Constructor
Properties
DataStorage Property
ExcelStorage Property
LastExtractedRecords Property
LastInsertedRecords Property
Methods
ExtractToExcel Method
InsertFromExcel Method
ExcelStorage Class
ExcelStorage Members
ExcelStorage Constructor
ExcelStorage Constructor (Type)
ExcelStorage Constructor (Type, Int32, Int32)
ExcelStorage Constructor (Type, String, Int32, Int32)
Properties
FileName Property
HeaderRows Property
OverrideFile Property
SheetName Property
StartColumn Property
StartRow Property
TemplateFile Property
Methods
ExtractRecords Method
InsertRecords Method
FileDataLink Class
FileDataLink Members
FileDataLink Constructor
Properties
DataStorage Property
FileHelperEngine Property
LastExtractedRecords Property
LastInsertedRecords Property
Methods
EasyExtractToFile Method
EasyInsertFromFile Method
ExtractToFile Method
ExtractToStream Method
InsertFromFile Method
InsertFromStream Method
FileStorage Class
FileStorage Members
FileStorage Constructor
Properties
Engine Property
FileName Property
Methods
ExtractRecords Method
InsertRecords Method
FillRecordHandler Delegate
GenericDataLink Class
GenericDataLink Members
GenericDataLink Constructor
Properties
DataStorage1 Property
DataStorage2 Property
Methods
CopyDataFrom1To2 Method
CopyDataFrom2To1 Method
InsertSqlHandler Delegate
OleDbStorage Class
OleDbStorage Members
OleDbStorage Constructor
SqlServerStorage Class
SqlServerStorage Members
SqlServerStorage Constructor
SqlServerStorage Constructor (Type)
SqlServerStorage Constructor (Type, String)
SqlServerStorage Constructor (Type, String, String)
SqlServerStorage Constructor (Type, String, String, String, String)
Properties
DatabaseName Property
ServerName Property
UserName Property
UserPass Property
TransactionMode Enumeration
FileHelpers.MasterDetail
CommonSelector Enumeration
MasterDetailEngine Class
MasterDetailEngine Members
MasterDetailEngine Constructor
MasterDetailEngine Constructor (Type, Type, MasterDetailSelector)
MasterDetailEngine Constructor (Type, Type, CommonSelector, String)
Properties
MasterType Property
Methods
AppendToFile Method
AppendToFile Method (String, MasterDetails)
AppendToFile Method (String, MasterDetails[])
ReadFile Method
ReadStream Method
ReadString Method
WriteFile Method
WriteFile Method (String, MasterDetails[])
WriteFile Method (String, MasterDetails[], Int32)
WriteStream Method
WriteStream Method (TextWriter, MasterDetails[])
WriteStream Method (TextWriter, MasterDetails[], Int32)
WriteString Method
WriteString Method (MasterDetails[])
WriteString Method (MasterDetails[], Int32)
MasterDetails Class
MasterDetails Members
MasterDetails Constructor
MasterDetails Constructor ()
MasterDetails Constructor (Object, Object[])
Properties
Details Property
Empty Property
Master Property
MasterDetailSelector Delegate
RecordAction Enumeration
FileHelpers.RunTime
ClassBuilder Class
ClassBuilder Members
Properties
ClassName Property
FieldCount Property
Fields Property
GenerateProperties Property
IgnoreCommentedLines Property
IgnoreEmptyLines Property
IgnoreFirstLines Property
IgnoreLastLines Property
Namespace Property
RecordCondition Property
SealedClass Property
Visibility Property
Methods
ClassFromBinaryFile Method
ClassFromBinaryFile Method (String)
ClassFromBinaryFile Method (String, NetLanguage)
ClassFromBinaryFile Method (String, String, NetLanguage)
ClassFromSourceFile Method
ClassFromSourceFile Method (String)
ClassFromSourceFile Method (String, NetLanguage)
ClassFromSourceFile Method (String, String)
ClassFromSourceFile Method (String, String, NetLanguage)
ClassFromString Method
ClassFromString Method (String)
ClassFromString Method (String, NetLanguage)
ClassFromString Method (String, String)
ClassFromString Method (String, String, NetLanguage)
ClassFromXmlFile Method
ClassToBinaryFile Method
ClearFields Method
CreateRecordClass Method
FieldByIndex Method
GetClassBinaryCode Method
GetClassSourceCode Method
LoadFromXml Method
SaveToBinaryFile Method
SaveToBinaryFile Method (String)
SaveToBinaryFile Method (String, NetLanguage)
SaveToSourceFile Method
SaveToSourceFile Method (String)
SaveToSourceFile Method (String, NetLanguage)
SaveToXml Method
ClassBuilder.IgnoreCommentInfo Class
ClassBuilder.IgnoreCommentInfo Members
Properties
CommentMarker Property
InAnyPlace Property
ClassBuilder.RecordConditionInfo Class
ClassBuilder.RecordConditionInfo Members
Properties
Condition Property
Selector Property
CsvClassBuilder Class
CsvClassBuilder Members
CsvClassBuilder Constructor
CsvClassBuilder Constructor (String, Char, String)
CsvClassBuilder Constructor (String, Char, Int32)
CsvClassBuilder Constructor (CsvOptions)
Methods
AddField Method
AddField Method (String, String)
AddFields Method
AddFields Method (Int32)
AddFields Method (Int32, String)
DelimitedClassBuilder Class
DelimitedClassBuilder Members
DelimitedClassBuilder Constructor
DelimitedClassBuilder Constructor (String, String)
DelimitedClassBuilder Constructor (String)
DelimitedClassBuilder Constructor (String, String, DataTable)
Properties
Delimiter Property
Fields Property
LastField Property
Methods
AddField Method
AddField Method (DelimitedFieldBuilder)
AddField Method (String)
AddField Method (String, String)
AddField Method (String, Type)
FieldByIndex Method
DelimitedFieldBuilder Class
DelimitedFieldBuilder Members
Properties
FieldQuoted Property
QuoteChar Property
QuoteMode Property
QuoteMultiline Property
FixedFieldBuilder Class
FixedFieldBuilder Members
Properties
AlignChar Property
AlignMode Property
FieldLength Property
FixedLengthClassBuilder Class
FixedLengthClassBuilder Members
FixedLengthClassBuilder Constructor
FixedLengthClassBuilder Constructor (String)
FixedLengthClassBuilder Constructor (String, Int32[])
FixedLengthClassBuilder Constructor (String, DataTable, Int32)
FixedLengthClassBuilder Constructor (String, FixedMode)
Properties
Fields Property
FixedMode Property
LastField Property
Methods
AddField Method
AddField Method (FixedFieldBuilder)
AddField Method (String, Int32, String)
AddField Method (String, Int32, Type)
FieldByIndex Method
SetFieldsLength Method
RunTimeCompilationException Class
RunTimeCompilationException Members
Properties
CompilerErrors Property
SourceCode Property