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