SQL datasource for gridview

Posted by Karsten on Stack Overflow See other posts from Stack Overflow or by Karsten
Published on 2010-04-14T19:47:03Z Indexed on 2010/04/14 19:52 UTC
Read the original article Hit count: 512

Hi

I want to use a gridview with sorting and paging to display data from an SQL server, the query uses 3 joins and the full text search containstable. The from part of the query uses all 3 tables in the join.

What is the best way to do this? I can think of a stored procedure, SQL directly in the SQLDataSource and creating a view in the database. I want good performance and would like to leverage the automatic sorting and paging features of the gridview as much as possible.

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql-server