Ajax ScriptManager

The ASP .NET ScriptManager manages ASP.NET Ajax script libraries and script files, partial-page rendering, and client proxy class generation for Web and application services. Here are some tips for the ScriptManager that I have found useful. Please note that many of these topics apply to ASP .NET 4.0.Access ScriptManager From ChildYou can only have one instance of the ScriptManager per page, so a...

When you work with master pages and content pages, both can use the same events (such as Page_Load).Be sure you know which events come before others. You are bringing two classes together to create a singlepage class, and a specific order is required. When an end user requests a content page in the browser, the event ordering is as follows:Master page child controls initialization: All server controls...

sql server faq link

http://dotnetguts.blogspot.com/2007/08/faq-on-view-in-sql-server.h...

How to call Server Side function from Client Side Code using PageMethods in ASP.NET AJAX

You cannot call server-side code ‘directly’ from client-side code. That is because by design, the server side code executes at server side and client side code at the client. However there are some workarounds. To call serverside code from javascript, you will need to use AJAX, and the easiest way out, is to use the ASP.NET AJAX Extensions. One option while using Microsoft ASP.NET AJAX is to call...

TRY…CATCH and ERROR Handling-Sql Server 2005

Syntax:BEGIN TRY{ sql_statement |statement_block }END TRYBEGIN CATCH{ sql_statement |statement_block }END CATCHThe TRY or CATCH block can contain a single T-SQL statement or a series of statements. The CATCH block must follow immediately after the TRY block. The TRY/CATCH block cannot span more than a single batch. In addition, TRY/CATCH block cannot span an IF/ELSE statement. Example of TRY…CATCH:BEGIN...

Table Variables

Q1: Why were table variables introduced when temporary tables were already available?A1: Table variables have the following advantages over temporary tables: As mentioned in the SQL Server Books Online "Tables" article, table variables, such as local variables, have a well defined scope at the end of which they are automatically cleared.Table variables result in fewer recompilations...