开发者

Entity Framework + stored procedure with paging

I am using Entity Framework now and using a stored procedure to populate my entity. Where there is no problem with populating my entity, but when i trying to bind the result to a gridview control with "Enable Paging" set to true, it gives an error saying "The data s开发者_JS百科ource does not support server-side data paging."

I am using stored procedure because one of the table column is FullTextIndexed, and there is a requirement to be able to search on that field.

Can anyone tell me how the paging would work in this situation?


I don't have a lot of experiences using the DataSource controls. I usually handle my own data retrieval / binding. Having said that I would allow the stored procedure to return only the records that are being requested (ie. 10-12 for page 2).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜