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..
The ASP.NET Wiki was started by Scott Hanselman in February of 2008. The idea is that folks spend a lot of time trolling the blogs, googlinglive-searching for answers to common "How To" questions. There's piles of fantastic community-created and MSFT-created content out there, but if it's not found by a search engine and the right combination of keywords, it's often lost.
The ASP.NET Wiki articles moved to CodeProject in October 2013 and will live on, loved, protected and updated by the community.