//Sample.txt ==============================
// SrNo Item ModifiedOn FileType
// 1 Item1 01-Apr-14 pdf
// 2 Item2 12-Feb-14 doc
// 3 Item3 01-Dec-13 xls
// 4 Item4 18-Sep-13 ppt
// 5 Item5 15-Aug-13 txt
//Method ==============================
private DataTable fnGetDataTableFromTextFile(string strFileName)
{
strFileName = "D:Sample.txt";
string strText = System.IO.File.ReadAllText(strFileName);
string[] arrLine = strText.Split(new string[] { "\n", "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
DataTable dt = new DataTable();
int i = 0; int j = 0;
string[] arrCol = arrLine[0].ToString().Split(new string[] { "\t" }, StringSplitOptions.RemoveEmptyEntries);
for (j = 0; j <= arrCol.GetUpperBound(0); j++)
{
dt.Columns.Add(new DataColumn(arrCol[j].ToString()));
}
for (i = 1; i <= arrLine.GetUpperBound(0); i++)
{
arrCol = arrLine[i].ToString().Split(new string[] { "\t" }, StringSplitOptions.RemoveEmptyEntries);
DataRow dr = dt.NewRow();
for (j = 0; j <= arrCol.GetUpperBound(0); j++)
{
dr[j] = arrCol[j];
} dt.Rows.Add(dr);
}
return dt;
}
No comments:
Post a Comment