How to read textfile to datatable in c#

Question

Below is my class code

 public class TextReaderClass
 {

    public DataTable ReadTextFile(string filepath)
    {
        DataTable dtTextFile = new DataTable();

        dtTextFile.Columns.Add("Emp_Id");
        dtTextFile.Columns.Add("Emp_FirstName");
        dtTextFile.Columns.Add("Emp_LastName");
        dtTextFile.Columns.Add("Emp_Designation");
        dtTextFile.Columns.Add("Emp_Salary");
        dtTextFile.Columns.Add("Emp_JoiningDate");

        //CODE to add here reading from text file and filling the data table
        string[] readTextfile = System.IO.File.ReadAllLines(@"D:\Rutu\datatest.txt");

        //Run a loop here for each record in the text file
        foreach (string line in readTextfile)
        {
            var cols = line.Split(';');
            DataRow dtrow = dtTextFile.NewRow();
            //Create an object of Data Row
            dtTextFile.Rows.Add(dtrow);              
            //Fill the row data in DataTable
        }
       return dtTextFile;

    }
}

I tried this CODE for reading from text file and filling the data table. Any help will be highly appreciated. Thanks

plz refer the link :https://stackoverflow.com/questions/20860101/how-to-read-text-file-to-datatable — SUNIL DHAPPADHULE, Dec 19 '19 at 06:08

score 1 · Answer 1 · answered Dec 19 '19 at 05:58

You can do like that by doing this you you also read and add it to datatable

public DataTable ReadTextFile(string filePath, int numberOfColumns)
{
    DataTable tbl = new DataTable();

    for(int col =0; col < numberOfColumns; col++)
        tbl.Columns.Add(new DataColumn("Column" + (col+1).ToString()));


    string[] lines = System.IO.File.ReadAllLines(filePath);

    foreach(string line in lines)
    {
        var cols = line.Split(':');

        DataRow dr = tbl.NewRow();
        for(int cIndex=0; cIndex < 3; cIndex++)
        {
           dr[cIndex] = cols[cIndex];
        }

        tbl.Rows.Add(dr);
    }

    return tbl;
}

How I get the datatable coloumn value in a datagridview ? – Rutuparna Panda Dec 19 '19 at 06:09 — Rutuparna Panda, Dec 19 '19 at 06:09
dataGridView.SelectedRows[0].Cells["xxx"] – Tech Sourav Dec 19 '19 at 06:16 — Tech Sourav, Dec 19 '19 at 06:16

score 0 · Answer 2 · answered Dec 19 '19 at 06:04

If you have a formatted text file and MS SQL Server consider using the bulk insert facility:

https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15

An example:

BULK INSERT Sales.Orders FROM 'C:\Rutu\datatest.txt' WITH ( FORMAT='CSV');

score 0 · Accepted Answer · edited Dec 19 '19 at 07:05

try this code.

public DataTable ReadTextFile(string filepath,int numberOfColumns)
{
    DataTable dtTextFile = new DataTable();

    for(int col =0; col < numberOfColumns; col++)
        dtTextFile.Columns.Add(new DataColumn("Column" + (col+1).ToString()));


    string[] readTextfile = System.IO.File.ReadAllLines(filepath);


    foreach (string line in readTextfile)
    {
        var cols = line.Split(';');
        DataRow dtrow = dtTextFile.NewRow();

        for(int cIndex=0; cIndex < 3; cIndex++)
        {
            dtrow [cIndex] = cols[cIndex];
        }

        dtTextFile.Rows.Add(dtrow);              

    }

    return dtTextFile;

}

And also get datatable to gridview

dataGridview.DataSource=ReadTextFile(filepath,6);

How to read textfile to datatable in c#

3 Answers3