Reading CSV into Dataset no column names

[tshad]

I have a csv file that I am reading into my dataset. But I want to ignore
any rows that have nothing in the 3rd column - something like:

da = new OleDbDataAdapter("SELECT * FROM " +
Path.GetFileName(strFile) + "WHERE F3 is not null",csvConnection);

or Where F3 = ''

where F3 would be some type of column number. The problem is I don't have
any column names as I am reading this from a csv text file.

How would I do this?

Thanks,

Tom

 

[christery]

and where does F3 come from? I'd name columns to have a name I put
there...
look at http://msdn2.microsoft.com/en-us/library/ms709353.aspx for
additional info on schema.ini
//CY Who stole chr$(12)?

 

[sloan]

If you don't have columns , you define them in a seperate file..that resides
in the SAME directory.

http://www.google.com/search?hl=en&q=IDataReader+text++"HDR=No"+ini

I think its called "schema.ini", but can't remember exactly.

But there is a way...hopefully that will help.

 

[christery]

interesting point sloan, why of why didnt I think of that...
//CY