<div>
<div class="content wysiwyg-content">
I would like to know the most efficient way to display data on a page within my site. &nbsp;The datasource would be SQL database utilizing stored procedures. &nbsp;The format I want to display (an author and their books) would ultimately look something like this: 
 
John Grisham 
&nbsp;- The Firm 
&nbsp;- The Litigators 
&nbsp;- A Time To Kill 
 
James Patterson 
&nbsp;- Kill Alex Cross 
&nbsp;- Toys 
 
Harlen Coben 
&nbsp;- Deal Breaker 
&nbsp;- Tell No One 
 
I'm seeing things on the web like datagrid, dataview, display through html, etc. &nbsp;The data is stored in the same table, each having it's own row. &nbsp;So for the above, there are 7 rows in the table with columns of Author and Book Title. &nbsp;I'd like the easiest and mose efficient method. 
 
Thanks in advance. 
 
 

</div>
</div>

I would like to know the most efficient way to display data on a page within my site.  The datasource would be SQL database utilizing stored procedures.  The format I want to display (an author and their books) would ultimately look something like this:

John Grisham
 - The Firm
 - The Litigators
 - A Time To Kill

James Patterson
 - Kill Alex Cross
 - Toys

Harlen Coben
 - Deal Breaker
 - Tell No One

I'm seeing things on the web like datagrid, dataview, display through html, etc.  The data is stored in the same table, each having it's own row.  So for the above, there are 7 rows in the table with columns of Author and Book Title.  I'd like the easiest and mose efficient method.

Thanks in advance.




Best way to display data from a SQL query

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

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).

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.