Select on collection - C#
<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>
