I'm going to explain how extract data from csv file using c#.
First you have to declare two string variables and their properties for store directory and filename of csv file which you want to extract data.
private string dirCSV;
private string fileNevCSV;
public string FileNevCSV
{
get{return fileNevCSV;}
set{fileNevCSV=value;}
}
public string dirCSV
{
get{return dirCSV;}
set{dirCSV=value;}
}
In the second step connect to the data source and fill it to the dataset.
public DataSet loadCVS(int noofrows)
{
DataSet ds = new DataSet();
try
{
string strConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + this.dirCSV.Trim() + ";Extensions=asc,csv,tab,txt;Persist Security Info=False";
string sql_select;
OdbcConnection conn;
conn = new OdbcConnection(strConnString.Trim());
conn.Open();
if (noofrows == -1)
{
sql_select = "select * from [" + this.FileNevCSV.Trim() + "]";
}
else
{
sql_select = "select top " + noofrows + " * from [" + this.FileNevCSV.Trim() + "]";
}
OdbcDataAdapter obj_oledb_da = new OdbcDataAdapter(sql_select, conn);
obj_oledb_da.Fill(ds, "csv");
conn.Close();
}
catch (Exception e) {
}
return ds;
}
In the third step extract data to DataTable from generated DataSet.
this.dirCSV = "file path";
this.fileNevCSV ="file name";
DataSet ds = loadCVS(-1);
DataTable table = ds.Tables[0];
foreach (DataRow row in table.Rows)
{
}
Thanks.
Happy coding..