Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Iterate over columns in LINQ to SQL result
Message
General information
Forum:
ASP.NET
Category:
LINQ
Title:
Iterate over columns in LINQ to SQL result
Environment versions
Environment:
C# 3.0
OS:
Windows XP SP2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01362512
Message ID:
01362512
Views:
92
To All:

I have the following code:
var _CSVTests = from cs in db.CSVTests
                         select cs;

foreach (CSVTest tst in _CSVTests)
	{
		
		 In here I want to iterate over each column in each record and 
		 if it is not equal to NULL I want to do something with the value,
		 such as insert that value into another table.
		
	}
How do I access the properties and values of each column in the results of my _CSVTests? Do I use IQueryable instead of var? How will that help me? I've been searching for this answer for two days now. PLEASE HELP.

Thank you.
Elgin Rogers
Epic Solutions
www.epicsolutions.net
Next
Reply
Map
View

Click here to load this message in the networking platform