tag:blogger.com,1999:blog-6082652835152798567.post7749534920422740939..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: jQuery datatables stored procedure for paging sorting and searchingUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6082652835152798567.post-7307939821502027802019-01-21T21:12:24.163-08:002019-01-21T21:12:24.163-08:00how to pass custom parameter from this code to c#how to pass custom parameter from this code to c#Anonymoushttps://www.blogger.com/profile/09732703793511526314noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-23793133181773717362016-11-07T11:31:15.817-08:002016-11-07T11:31:15.817-08:00very nice, only one piece missing though, if we do...very nice, only one piece missing though, if we do type a search term, datatables needs an additional field to show the total unfiltered rows. This will allow it to display "Showing 1 to 10 of 138 entries (filtered from 7,506 total entries)"<br /><br />the missing variable here is the 7506 one, I got around this by doing a separate SELECT COUNT(*) without the @Search condition.<br /><br />Also out of curiosity, in the final SELECT, wouldnt it be faster if you did SELECT TOP (@DisplayLength) from cte instead of processing the whole CTE set to match the RowNum? In the TOP case,SQL Server will stop processing the rest of the CTE once @DisplayLength records have been found, no?Sajjan Sarkarhttps://www.blogger.com/profile/07258575012965819548noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-79338835741503949862016-01-27T12:20:19.519-08:002016-01-27T12:20:19.519-08:00buen tutorial.
me podrias pasar la fuente.buen tutorial.<br />me podrias pasar la fuente.Anonymoushttps://www.blogger.com/profile/17330942261432401780noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-55187093845809967262015-10-25T09:09:31.592-07:002015-10-25T09:09:31.592-07:00hi
thank you for tutorial
can teach update , delet...hi<br />thank you for tutorial<br />can teach update , delete ,... in jquery plugin ?<br />Anonymoushttps://www.blogger.com/profile/01532764799370046212noreply@blogger.com