Paste the code First:
Using System.Data;
Using System.Data.OleDb;
Static voidMain (string[] args) { varstrpath = System.Environment.CurrentDirectory +"\\"; varfilename ="Ss.csv"; DataSet DataSet=getcsvdata (strpath, filename); if(DataSet. Tables.count >0) { foreach(DataTable itemTableinchDataSet. Tables) {stringTable_sheetname=itemtable.tablename;//DataTable datnew= ItemTable.DefaultView.ToTable (false,New string[] {//Select Columns "Column Name","ProjectName" }); } } } StaticDataSet Getcsvdata (stringFilenameurl,stringfileName) {OleDbConnection Olecon=NewOleDbConnection (); OleDbCommand OLECMD=NewOleDbCommand (); OleDbDataAdapter Oleda=NewOleDbDataAdapter (); DataSet CSVData=NewDataSet (); Olecon.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data source="+ Filenameurl +"; Extended properties= ' Text; fmt=delimited; Hdr=yes; '"; Olecon.open (); Olecmd.connection=Olecon; Olecmd.commandtext="SELECT * from"+FileName; Oleda.selectcommand=OLECMD; Try{Oleda.fill (CSVData,"Csvfilevcqdata"); returnCSVData; } Catch { returnCSVData; } finally{olecon.close (); Olecmd.dispose (); Oleda.dispose (); Olecon.dispose (); } }
C # read CSV format data read as DataTable type