Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Iterate over columns in LINQ to SQL result
Message
From
18/11/2008 09:39:40
 
General information
Forum:
ASP.NET
Category:
LINQ
Environment versions
Environment:
C# 3.0
OS:
Windows XP SP2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01362512
Message ID:
01362528
Views:
9
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform