how to show the textfile data into datagridview in c#

Question

i have one text file with me.i have to export the file in datagridview is it possible

Lacy Michelle · Answer

I think below code can help you much: OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = CSV document(*.csv)|*.csv; DialogResult result = dialog.ShowDialog(); if (result == DialogResult.OK) { string csvFile = dialog.FileName; Workbook workbook = new Workbook(); workbook.LoadFromFile(@D:\my file\csvtodatatable.csv ); Worksheet worksheet = workbook.Worksheets[0]; System.Data.DataTable t = worksheet.ExportDataTable(); this.dataGridView1.DataSource = t; } You can see details here: CSV to Datatable

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/ankurmee/import-data-from-text-and-csv-file-to-datagridview-in-net/