I don't think you can iterate through the columns like you want using LINQ. If you want to do that you'll need to use datasets.
>Craig,
>
>I wasn't clear enough in my fist question. My first foreach loop works Ok, as does yours. What I really want is an inner foreach loop to step through the columns, something similar to:
>
>
>
>var _CSVTests = from cs in db.CSVTests
> select cs;
>
>foreach (CSVTest tst in _CSVTests)
>{
> foreach (Column c in tst)
> {
> Do something with the value of each column if it isn't null.
> }
>}
>
>
>
>I know the "foreach (Column c in tst) " part is not proper. What is?
>
>How do I get a collection of columns for each "record" in my _CSVTests ?
>
>Thanks.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer