<p>I have a database table (sql server 2008) that I want to view data for, what is the quickest way of displaying this data?</p>

<p>(if it could have paging that would be perfect).</p>

<p>Would it be a gridview or ?</p>

<p>query: select * from testData</p>

if you're using .NET 3.5 you could use ASP.NET Dynamic Data:
http://www.asp.net/dynamicdata/
Hope this helps!