<div>
You can Query a DataTable:<br />
<br />
DataTable table = new DataTable();<br />
// fill rows<br />
DataRow[] rows = table.Select(&quot;{field} = {value}&quot;,&quot;{sortcolumn}&quot;);<br />
<br />
the first parameter is essentially the WHERE clause, and the second (optional) parameter is the ORDER BY clause<br />
<br />
<br />

</div>


You can Query a DataTable:

DataTable table = new DataTable();
// fill rows
DataRow[] rows = table.Select("{field} = {value}","{sortcolumn}");

the first parameter is essentially the WHERE clause, and the second (optional) parameter is the ORDER BY clause




<div>
<div class="content wysiwyg-content">
Please tell me if it is possible and if it is how to use SQL select statements to query a dataset.<br />
<br />
Thank-you
</div>
</div>


Please tell me if it is possible and if it is how to use SQL select statements to query a dataset.

Thank-you

Search a DataSet using SQL Select statements

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).