CSVファイルからデータテーブルに読み込む方法

CSVファイルからデータテーブルに読み込む方法
CSVファイルをデータベースとして扱う方法（Jet）
VB.NET

Dim csvDir As String = "C:\csvdata\"
Dim csvFileName As String = "csvdata.csv"

Dim conString As String = _
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
    + csvDir + ";Extended Properties=""text;HDR=No;FMT=Delimited"""
Dim con As New System.Data.OleDb.OleDbConnection(conString)

Dim commText As String = "SELECT * FROM [" + csvFileName + "]"
Dim da As New System.Data.OleDb.OleDbDataAdapter(commText, con)

Dim dt As New DataTable
da.Fill(dt)

C#

string csvDir = @"C:\csvdata\";
string csvFileName = "csvdata.csv";

string conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
    + csvDir + ";Extended Properties=\"text;HDR=No;FMT=Delimited\"";
System.Data.OleDb.OleDbConnection con =
    new System.Data.OleDb.OleDbConnection(conString);

string commText = "SELECT * FROM [" + csvFileName + "]";
System.Data.OleDb.OleDbDataAdapter da =
    new System.Data.OleDb.OleDbDataAdapter(commText, con);

DataTable dt = new DataTable();
da.Fill(dt);

CSVファイルをデータベースとして扱う方法（ODBC）
VB.NET

Dim csvDir As String = "C:\csvdata\"
Dim csvFileName As String = "csvdata.csv"

Dim conString As String = _
    "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" _
    + csvDir + ";Extensions=asc,csv,tab,txt;"
Dim con As New System.Data.Odbc.OdbcConnection(conString)

Dim commText As String = "SELECT * FROM [" + csvFileName + "]"
Dim da As New System.Data.Odbc.OdbcDataAdapter(commText, con)

Dim dt As New DataTable
da.Fill(dt)

C#

string csvDir = @"C:\csvdata\";
string csvFileName = "csvdata.csv";

string conString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq="
    + csvDir + ";Extensions=asc,csv,tab,txt;";
System.Data.Odbc.OdbcConnection con =
    new System.Data.Odbc.OdbcConnection(conString);

string commText = "SELECT * FROM [" + csvFileName + "]";
System.Data.Odbc.OdbcDataAdapter da =
    new System.Data.Odbc.OdbcDataAdapter(commText, con);

DataTable dt = new DataTable();
da.Fill(dt);