how to import csv to datagrid?

Question

hi, how to import csv file to DataGrid. please give a sample code. Thanks

Dorababu Meka · Answer

private void loadcsv() { string delimitter = "," ; string tablename = "Tblname" ; string filename = "c:\xyz.csv" ; DataSet ds = new DataSet (); StreamReader sr = new StreamReader (filename); ds.Tables.Add(tablename); ds.Tables[tablename].Columns.Add( "Product" ); //What ever fields you have in csv add here ds.Tables[tablename].Columns.Add( "Price" ); string srread = sr.ReadToEnd(); string [] rows = srread.Split( "" .ToCharArray()); foreach ( String str in rows) { string [] items = str.Split(delimitter.ToCharArray()); ds.Tables[tablename].Rows.Add(items); } this .dataGridView1.DataSource = ds.Tables[0].DefaultView; }

Sanjeeb Lenka · Answer

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

Rasadul Alam Rashed · Answer

Import CSV File into Database in C# Some time we need to import/insert data form CSV file into database. The following C# code will help you to insert all the files in a directory into database. Code is here : http://cybarlab.blogspot.com/2013/03/import-csv-file-into-database-in-c.html

how to import csv to datagrid?

Answers (3)