c# - Perform Aggregate function of DataTable -

i have perform aggregate function on datatable datatable.compute compute return object want perform aggregate function on datatable , datarow .

_summarytable.compute("min(fareadult)", whereclause                          + "airlinedisplayname='"                          + convert.tostring(airline["airlinedisplayname"])                          + "' , ( stops=0) "); 

but above code return min(fareadult) want select 2 column based on above condition datatable.

how can through linq have select min(fareadult) , totelprice value of same row

use select instead compute

_summarytable.select("filterationexpression");  datarow[] dr = _summarytable.select("min(fareadult),airlinedisplayname='" + convert.tostring(airline["airlinedisplayname"]) + "' , ( stops=0) ");