Can can anyone tell me how to convert text file into datatable?

Question

Sachin Singh · Answer

test this public static DataTable ConvertCSVtoDataTable(string strFilePath) { StreamReader sr = new StreamReader(strFilePath); string[] headers = sr.ReadLine().Split( ',' ); DataTable dt = new DataTable(); foreach (string header in headers) { dt.Columns.Add(header); } while (!sr.EndOfStream) { string[] rows = Regex.Split(sr.ReadLine(), ",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)" ); DataRow dr = dt.NewRow(); for ( int i = 0; i { dr[i] = rows[i]; } dt.Rows.Add(dr); } return dt; } static void Main(string[] args) { string filepath = "d://ConvertedFile.csv" ; DataTable res = ConvertCSVtoDataTable(filepath); } Note:- The first line in CSV is header Name, Age,Salary sachin,25,1234567

Satya Karki · Answer

Hi Try this simple code. string[] rows = content .Split(','); // your separator or delimeter foreach (string s in rows) { string[] columns = s.Split(':'); var dataRow = someDataTable .NewRow(); dataRow["someColumnName"] = columns[0]; dataRow["anotherColumnName"] = columns[1]; dataRow["someOtherColumnName"] = columns[2]; // and so on... someDataTable.Rows.Add(dataRow); }

Rijwan Ansari · Answer

Hi, You can use this code. public DataTable ConvertToDataTable (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(','); // use your delimeter like ,:, |, .. DataRow dr = tbl .NewRow(); for(int cIndex = 0 ; cIndex 3 ; cIndex++) { dr[cIndex] = cols[cIndex]; } tbl.Rows.Add(dr); } return tbl; } Regards Rijwan

Ganesan C · Answer

Hi, Try this. public DataTable ConvertToDataTable ( string filePath, int numberOfColumns) { DataTable tbl = new DataTable(); for ( int col =0; 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 { dr[cIndex] = cols[cIndex]; } tbl.Rows.Add(dr); } return tbl; }

Meena Bisht · Answer

Hello , You can try the below lines of code to read the txt file and convert it to a datatable. var table = new DataTable(); var fileContents = File.ReadAllLines("yourFile"); var splitFileContents = (from f in fileContents select f.Split(':')).ToArray(); int maxLength = (from s in splitFileContents select s.Count()).Max(); for (int i = 0; i { table.Columns.Add(); } foreach (var line in splitFileContents) { DataRow row = table.NewRow(); row.ItemArray = (object[])line; table.Rows.Add(row); } Thanks,

Jignesh Kumar · Answer

Hi Asarsh, Please find below link which will help you, https://www.c-sharpcorner.com/blogs/how-to-read-csv-or-text-file-c-sharp-datasetdatatable

Can can anyone tell me how to convert text file into datatable?

Answers (6)