Sunday, August 3, 2014

Create DataTable from Text File in C#.Net

   
//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