.Net Material

Stored Procedure 1) If error occurred then execute next statement. 2) Use EXECUTE or EXEC to run.3) Can return values not mandatory. 4) SP can not be called from UDF. 5) Have transaction. 6) Can use XML FROM Clause. UDF 1) If error occurred then can not execute next statement. 2) Execute from sql SELECT or SQL action queries. 3) Must return 1 Value or table. 4) UDF can be called from SP. 5) Don't have transaction because don't have DML queries. 6) Can't use XML FROM Clause.

1. ScriptManager: it takes care of loading the JavaScript libraries needed by ASP.NET AJAX. A component control that manages the marshalling of messages to the AJAX-enabled server for the parts of the page requiring partial updates. Every ASP.NET page will require a ScriptManager control in order to work. It is important to note that you can have only a single ScriptManager control on a page. 2. ScriptManagerProxy: Enables nested components such as content pages and user controls to add script and service references to pages when a ScriptManager control is already defined in a parent element. A component control that acts as a ScriptManager control for a content page. The ScriptManagerProxy control, which sits on the content page (or sub-page), works in conjunction with a required ScriptManager control that resides on the master page. 3. Timer: The Timer control performs postbacks at defined intervals. If you use the Timer control with an UpdatePanel control, you can enab