There are two process for report,- 1) Report for Database. . 2) Report for Front end. http://msdn.microsoft.com/en-us/library/ms225593%28v=vs.80%29.aspx[^] http://msdn.microsoft.com/en-us/magazine/cc188691.aspx[^] May be these link helps you.

Yes it is. And since it's native for Sql Server, I'd say you have lot's of opportunities when you play with it :) The need to optimize rises from a bad design.My articles[^]

Do you mean Indexing? Google it! ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

Google is your friend :) ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

If you don't want to use the datagrid view then you can use HTML table to display. Example: http://www.asp.net/mvc/tutorials/displaying-a-table-of-database-data-cs[^] Om Prakash Pant