Binding csv file to datagrid

[lltaylor]

Hello All,

I am currently in the process of writing an application
references a lot of data from user supplied csv files.

However for completeness I need to show the end user the data
in a neat and tidy format.

Is there an easy way of binding a csv file to a datagrid?

Any help on this matter would be much appreciated.

Thanks in advance.

Lloyd

 

[Nicholas Paldino [.NET/C# MVP]]

lltaylor,

I believe that there is an ODBC driver for CSV files that you can use.
In order to use this, you can use the Odbc data classes in the
System.Data.Odbc namespace. Using those classes, you can create a
connection and a data adapter and then populate a data set, which you can
then bind to a grid.

Hope this helps.

 

[Madhu [MVP]]

Hi,

You can use Jet OLEDB provider to open the CSV file and
fill the dataset using OLEDB Adapter. Which can then be
used as a datasource for the datagrid.

Take a look at the following article...

http://authors.aspalliance.com/ericm/articles/textdb.asp

hope this helps...

Regards,
Madhu

MVP | MCSD.NET

 

[Lloyd Taylor]

Thats exactly what I was looking for.

Many thanks to both of you.