30.4.11

How to use append correctly

http://www.learningjquery.com/2009/03/43439-reasons-to-use-append-correctly

28.4.11

JQUERY Create,insert,update,delete
http://dotnetfriendly.blogspot.com/2011/01/jquery-datatables-in-aspnet-with-crud.html

15 Great jQuery Plugins For Better Table Manipulation
http://www.webdesignbooth.com/15-great-jquery-plugins-for-better-table-manipulation/

23.4.11

jquery slideshow automatic

http://www.devirtuoso.com/2009/08/jquery-slideshow-explained/

Sql Queries Information

1.)if you want to check, last 7 days sp created in database use this..

SELECT * FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 7


2.)Find Text In Store Procedure:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Users%'
AND ROUTINE_TYPE='PROCEDURE'


3.) Check tables created in database last 7 days:

SELECT * FROM sys.tables WHERE type = 'U' AND DATEDIFF(D,create_date, GETDATE()) < 14


4.) List of All tables in Database:

SELECT * from sys.tables where type_desc = 'USER_TABLE'

5.) List of All users Sps in Database.
SELECT * FROM sys.objects WHERE type = 'P'

20.4.11

Load Content On scrolling

http://www.go4coding.com/post/2011/04/11/Auto-loading-content-on-page-scroll-in-aspnet-using-jquery.aspx

14.4.11

Check TextBox Value in Database With jQuery

http://forums.asp.net/p/1584699/4001877.aspx

Datalist with custom paging

http://www.dotnetfunda.com/articles/article456-custom-seo-friendly-paging-with-aspnet-repeater-or-datalist-control-.aspx