1//In App.Config: <add name="DataFile" providerName="System.Data.Odbc" connectionString="Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=.\;Extensions=csv,txt"/>
2
3//Note: this code uses Enterprise Library 3.1
4
5DataSet ds = new DataSet();
6Database datafile = DatabaseFactory.CreateDatabase("DataFile");
7
8using(DbCommand cmd = datafile.GetSqlStringCommand("select * from DataList.csv"))
9{
10 datafile.LoadDataSet(cmd, ds, "DataList");
11}