T
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
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