ASP.net C# SQL count(*)
<p>I have a query that I'm running in C# .cs file:</p>

<pre><code>DataSet ds = db.ExecuteDataSet(System.Data.CommandType.Text, "SELECT count(*) as counter FROM [Table] where [Table].[Field] = 'test'");
</code></pre>

<p>I want to do is retrieve the value of "counter" in this query and "return" it as my functions return value.</p>

<p>How can I do that?</p>
