Home
Manage Your Code
Snippet: Read a csv into a dataset (C#)
Title: Read a csv into a dataset Language: C#
Description: reads a csv file into a dataset using odbc and enterprise library Views: 1432
Author: Justin Jones Date Added: 12/13/2007
Copy Code  
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}