<p>Say I have a sql query </p>

<pre><code>SELECT fname, lname, dob, ssn, address1, address2, zip, phone,state from users
</code></pre>

<p>Now say the records are now either in dictionary base or a strongly typed collection.</p>

<p>I have a grid view control and i want to bind it to my collection but I only want to display fname, lname, dob and ssn and not the other columns.</p>

<p>Is there an easy way to extract the columns and then bind to the extracted item? Not sure if LINQ would be helpful here.</p>

<p>This is a test project as I am getting familiar with the web world wqith VS-2008</p>

Perhaps LINQ and an anonymous class could do the trick for you.
```
```
from user in UserCollection
select new { FirstName=user.fname, LastName=user.lname, Dob=user.dob, SSN=user.ssn }
```
```