Linq Query - Selective Fields as DataTable?
<p>I want to create a datatable from linq query. 
The below code selects all filed, but i need select few fileds like "door_no","street_name","city_name","post_code","date of birth" and need to create it as Datatable.</p>

<pre>
var Results = from SelRow in MyDtb1.AsEnumerable() where SelRow.Field("door_no") != null select SelRow;
DataTable ChkResult = Results.CopyToDataTable();
</pre>

<p>Any Better Ideas
Thanks &amp; Regards
PARAMU</p>
