title: C# SQL if query returns any rows count
body: <p>What is the simplest and most efficient way to find if a data returns using a query? I'm using <code>DataTable</code> like <code>sqlAdapter.Fill(_table1)</code> and then doing <code>_table1.Rows.Count</code> to see if a datatable has any rows. Is there any classes and functions in C# that just gives me if there are any rows. I don't need the data of the rows. Just the count is what I need. I'm running this query against very large datasets so I don't wanna fill the datatable with all the row info.</p>