C # encapsulate TXT file processing

Using system;
Using system. Collections. Generic;
Using system. text;
Using system. Data;
Using system. IO;

Namespace myquery. utils
{
/// <Summary>
/// Encapsulate TXT file processing
/// By Jia Shiyi 2011-5-27
/// </Summary>
Public static class txthelper
{
/// <Summary>
/// Load TXT data to Dataset
/// </Summary>
/// <Param name = "FILENAME"> the complete path TXT file name is suffixed with .txt. </param>
/// <Param name = "encoding"> default character type: GBK </param>
/// <Param name = "split"> delimiter </param>
/// <Param name = "isfirsttitle"> whether the first line is a title line </param>
/// <Returns> </returns>
Public static dataset getdatafromtxt (string filename, string encoding, char split, bool isfirsttitle)
{
Dataset DS = NULL;
If (istxtfile (filename) & file. exists (filename ))
{
Datatable dt = new datatable ();
Encoding ecode;
If (string. isnullorempty (encoding ))
{
Ecode = encoding. getencoding ("GBK ");
}
Else
{
Ecode = encoding. getencoding (encoding );
}
Int I = 0;
String [] lines = file. readalllines (filename, ecode );
Foreach (string line in lines)
{
String [] Options = datahelper. getstrings (line, split );
If (options! = NULL)
{
// Column
If (I = 0)
{
For (Int J = 0; j <options. length; j ++)
{
String n = NULL;
If (isfirsttitle)
{
N = options [J];
}
If (string. isnullorempty (n ))
{
N = J. tostring ();
}
DT. Columns. Add (N );
}
I = 1;
If (isfirsttitle)
{
Continue;
}
}
Else if (options. length> DT. Columns. Count)
{
For (Int J = 0; j <options. Length-Dt. Columns. Count; j ++)
{
DT. Columns. Add (Dt. Columns. Count. tostring ());
}
}
// Data
Datarow DR = DT. newrow ();
For (Int J = 0; j <options. length; j ++)
{
Dr [J] = options [J];
}
DT. Rows. Add (DR );
}
}
If (Dt. Rows. Count> 0)
{
DS = new dataset ();
DS. Tables. Add (DT );
}
}
Return Ds;
}

/// <Summary>
/// Whether the suffix type is supported by TXT reading
/// </Summary>
/// <Param name = "FILENAME"> file name </param>
/// <Returns> </returns>
Public static bool istxtfile (string filename)
{
Return! String. isnullorempty (filename )&&
(Filename. endswith (". txt", stringcomparison. currentcultureignorecase)
| Filename. endswith (". CSV", stringcomparison. currentcultureignorecase ));
}
/// <Summary>
/// Read text
/// </Summary>
/// <Param name = "FILENAME"> complete file name </param>
/// <Returns> </returns>
Public static string getstring (string filename)
{
String result = NULL;
If (file. exists (filename ))
{
Result = file. readalltext (filename, encoding. utf8 );
}
Return result;
}
/// <Summary>
/// Write text to a text file
/// </Summary>
/// <Param name = "name"> complete file name </param>
/// <Param name = "content"> content </param>
/// <Param name = "iscover"> whether to overwrite existing files </param>
Public static void writetofile (string name, string content, bool iscover)
{
Filestream FS = NULL;
Try
{
If (! Iscover & file. exists (name ))
{
FS = new filestream (name, filemode. append, fileaccess. Write );
Streamwriter Sw = new streamwriter (FS, encoding. utf8 );
Sw. writeline (content );
Sw. Flush ();
Sw. Close ();
}
Else
{
File. writealltext (name, content, encoding. utf8 );
}
}
Finally
{
If (FS! = NULL)
{
FS. Close ();
}
}

}
}
}

Welcome to: http: // 121.18.78.216, which is a demonstration platform for ease of query and analysis, workflow, content management, and project management.