Loading

How to dynamicaly add .txt file in to Data table row in c#

Sujeet Raman

I have methode to export excel.I created table coloums for that.but my table row data in following form.How can i add 1000 + data dynamicaly from following format?here in LastList i have 1000 values with comma seperated.I have to add that values like table.Rows.Add(1, 2, "M", //"M", "M", "M", "M", "M", "M") format. only 9 values so like this 9 *100.Please find my attached solution.I have also attached the txt file to be added in the row

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tomasz Borawski5y ago
Hi,

If you can export an excel file to a text file, you will be able to use my function published on c# corner
Import Text Files Into A List In C# (c-sharpcorner.com)

After that, you can easily load a list into a database using Entity Framework.
0