Ad:

ASP.NET Discussion Thread
Unsolved
Views: 49052

Jan 25th, 2006

Reading CSV file into a ADO recordset

Expand Post »

I'm relatively new to programming.

Problem:
I'm creating an ASP.NET app the needs to read a CSV file and filter the data.

I searched the net and only found classic ASP examples or all DB driven examples.

Does anyone have sample code. Or is there any other suggestions on how to read and filter. Thanks

Similar Threads

sseo

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jan 2006

Permalink

Jan 25th, 2006

Re: Reading CSV file into a ADO recordset

c# code

ASP.NET Syntax (Toggle Plain Text)
 
using System.Data;
 
//in some function
System.Data.Odbc.OdbcConnection conn;
DataTable dt;
System.Data.Odbc.OdbcDataAdapter da;
string connectionString;
string importFolder;
string fileName;
 
importFolder = @"c:\importfile" //or pass it in -this is the folder in which the csv file is in
 
fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported
 
connectionString= @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";";
conn = new Odbc.OdbcConnection(connectionString)
 
//we only pass it the folder.  The csv file import is in the query which follows
 
da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);
 
//Your table is filled and uses the first row of the csv file as the column headings.
using System.Data;

//in some function
System.Data.Odbc.OdbcConnection conn;
DataTable dt;
System.Data.Odbc.OdbcDataAdapter da;
string connectionString;
string importFolder;
string fileName;

importFolder = @"c:\importfile" //or pass it in -this is the folder in which the csv file is in

fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported

connectionString= @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";";
conn = new Odbc.OdbcConnection(connectionString)

//we only pass it the folder.  The csv file import is in the query which follows

da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);

//Your table is filled and uses the first row of the csv file as the column headings.

Hope it helps

f1 fan

Reputation Points: 26

Solved Threads: 11

Posting Whiz in Training

Offline

275 posts
since Jan 2006

Permalink

Jan 26th, 2006

Re: Reading CSV file into a ADO recordset

Thanks for the code f1_fan.

I'll try to work with the code.

Does anyone have a VB example as well.

sseo

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jan 2006

Permalink

Jan 26th, 2006

Re: Reading CSV file into a ADO recordset

I will change it to vb but bear with me as my vb is rusty to say the least.

ASP.NET Syntax (Toggle Plain Text)
imports System.Data;
 
//in some function
Dim conn As System.Data.Odbc.OdbcConnection 
Dim dt As DataTable
Dim da As System.Data.Odbc.OdbcDataAdapter;
Dim connectionString As string
Dim importFolder As string
Dim fileName As string
 
importFolder = "c:\importfile" //or pass it in -this is the folder in which the csv file is in
 
fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported
 
connectionString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";"
conn = new Odbc.OdbcConnection(connectionString)
 
//we only pass it the folder.  The csv file import is in the query which follows
 
da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);
 
//Your table is filled and uses the first row of the csv file as the column headings.
imports System.Data;

//in some function
Dim conn As System.Data.Odbc.OdbcConnection 
Dim dt As DataTable
Dim da As System.Data.Odbc.OdbcDataAdapter;
Dim connectionString As string
Dim importFolder As string
Dim fileName As string

importFolder = "c:\importfile" //or pass it in -this is the folder in which the csv file is in

fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported

connectionString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";"
conn = new Odbc.OdbcConnection(connectionString)

//we only pass it the folder.  The csv file import is in the query which follows

da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);

//Your table is filled and uses the first row of the csv file as the column headings.

f1 fan

Reputation Points: 26

Solved Threads: 11

Posting Whiz in Training

Offline

275 posts
since Jan 2006

Permalink

Feb 7th, 2006

Re: Reading CSV file into a ADO recordset

Can I access a remote csv? Example: http://www.domain.com/file.csv

Romulinho

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2006

Permalink

Apr 20th, 2010

Thanks for the post

Thank you for the code, it really helped me

Click to Expand / Collapse Quote originally posted by f1 fan ...

c# code
ASP.NET Syntax (Toggle Plain Text)
 
using System.Data;
 
//in some function
System.Data.Odbc.OdbcConnection conn;
DataTable dt;
System.Data.Odbc.OdbcDataAdapter da;
string connectionString;
string importFolder;
string fileName;
 
importFolder = @"c:\importfile" //or pass it in -this is the folder in which the csv file is in
 
fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported
 
connectionString= @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";";
conn = new Odbc.OdbcConnection(connectionString)
 
//we only pass it the folder.  The csv file import is in the query which follows
 
da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn);
da.Fill(dt);
 
//Your table is filled and uses the first row of the csv file as the column headings.
using System.Data; //in some function System.Data.Odbc.OdbcConnection conn; DataTable dt; System.Data.Odbc.OdbcDataAdapter da; string connectionString; string importFolder; string fileName; importFolder = @"c:\importfile" //or pass it in -this is the folder in which the csv file is in fileName = "csvimport.csv" //or pass it in -this is the csv file to be imported connectionString= @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";"; conn = new Odbc.OdbcConnection(connectionString) //we only pass it the folder. The csv file import is in the query which follows da = new System.data.Odbc.OdbcDataAdapter("select * from [" + strFileName + "]", conn); da.Fill(dt); //Your table is filled and uses the first row of the csv file as the column headings.
Hope it helps

wakamohle

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2010

Permalink

Apr 21st, 2010

Re: Reading CSV file into a ADO recordset

You're welcome.

I'm glad you found it useful. Please read member rules - http://www.daniweb.com/forums/faq.ph...niweb_policies

Thread Closed.

Last edited by adatapost; Apr 21st, 2010 at 8:53 am.

adatapost

Moderator

Reputation Points: 2134

Solved Threads: 1226

Posting Genius

Offline

6,523 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

This thread is currently closed and is not accepting any new replies.

Previous Thread in ASP.NET Forum Timeline: HTTP Error 403 on clicking LinkButton to open PDF file

Next Thread in ASP.NET Forum Timeline: btnLogin and Create Userprofiles

DaniWeb Message

Cancel Changes

User Name
Password