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)" the missing variable here is the 7506 one, I got around this by doing a separate SELECT COUNT(*) without the @Search condition. 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?
Videos 109, 110, 111 and 112 are excellent. Thanks a lot. Appreciate if you add another video number 114 explaining how to implement customer column search with server side jquery datatable. This is will be perfect.
Hello Sir, excellent explanation. Could you please make an application to show data on bootstrap table with server side pagination and search functionality.? Can you please do that with returning json data. Thanks in Advance
Where is the part where you code it in the jquery? I'm interested in how to code it on the client side and how it handles the paging, sorting and searching. thanks!
Hello Ross - You can all the jQuery tutorial series videos in logical sequence at the following link. Hope this helps. ua-cam.com/play/PL6n9fhu94yhVDV697uvHpavA3K_eWGQap.html
Works fine but slow with large tables I have a table with 2 millions records , it takes 20 seconds to execute spGetData 1000 ,0,0,'desc' would you please let me know how can i enhance it more
I believe it's due to LIKE operator. There's another approach known as "Full Text Search" in SQL server for searching up records, also there's 1 more approach "nGrams". Check them out, hope that helps!
Venkat, this is probably the 100000th time im saying, U R THE BEST !!! always with the most important tutorials ! Thanks again
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)"
the missing variable here is the 7506 one, I got around this by doing a separate SELECT COUNT(*) without the @Search condition.
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?
Thanks Venkat. Hoping your next series will be AngularJS... :)
Videos 109, 110, 111 and 112 are excellent. Thanks a lot. Appreciate if you add another video number 114 explaining how to implement customer column search with server side jquery datatable. This is will be perfect.
很有價值,謝謝
Excellent video sir.
Hello Sir, excellent explanation. Could you please make an application to show data on bootstrap table with server side pagination and search functionality.? Can you please do that with returning json data. Thanks in Advance
Can we do the same thing using sql query without using Stored Procedure
Hello Sir, did you have any demo for inline jQuery editable datatable on youtube? I would appreciate it :)
thank u sir...!
Where is the part where you code it in the jquery? I'm interested in how to code it on the client side and how it handles the paging, sorting and searching. thanks!
Hello Ross - You can all the jQuery tutorial series videos in logical sequence at the following link. Hope this helps.
ua-cam.com/play/PL6n9fhu94yhVDV697uvHpavA3K_eWGQap.html
@@Csharp-video-tutorialsBlogspot hola, entre a esa liga pero no encontré dónde se explica como implementarlo esto a datatables js
Can someone help me to do the same thing but without using stored procedure
When I test the stored procedure with spGetEmployees 10, 0, 1, 'asc', 'Male'
I don't get all 'Male' employees.
Because it uses "like clause", where 'female' contains 'male'
Works fine but slow with large tables
I have a table with 2 millions records , it takes 20 seconds to execute spGetData 1000 ,0,0,'desc'
would you please let me know how can i enhance it more
I believe it's due to LIKE operator. There's another approach known as "Full Text Search" in SQL server for searching up records, also there's 1 more approach "nGrams". Check them out, hope that helps!