SQL Server 2005 Features comparison

Features comparison of different editions of SQL Server 2005

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

AJAX Futures July 2007 release

Again another release within last 2 months. Waiting for these cooooool features in ASP.NEt

1. Dynamic Language Runtime - IronPython for ASP.NET and Managed JScript support
2. Dynamic light weight Data controls for ASP.NET
3. SilverLight support inside ASP.AJAX.NEt

New Controls in Futures

AJAX Futures May 2007 release has some additional controls like ListView and DetailView which supports concurrent update and asynchronous calls from javascript. It is coool.. but it is changing from release to release from Microsoft. So we have to wait for production release or next version of AJAX web Extension. Till then use updatepanel and partial postbacks...

gridview deleting rows by javascript web method calls

After deleting, updating rows of the gridview, if you want to update the gridview display, you can have a Delete web method call from javascript and RowDeleting method, you can refresh / rebind the gridview.

Reason for this.
1. It has lower overheads compared to direct ItemCommand delete, because ItemCommand method will try to find the control from gridview and get the value of the ID of the grid by iterating from row to row and column to column.

2. PageMethod is a static webmethod, so we can't have the access to the page controls

Asynchronous calls from javascript

Direct calls from javascript has async calls. Suppor if you have 3 web method calls from javascript, all the 3 calls are processed at the same time. So if the first method takes long time than the other two, it will return the results of method2 and method3 before method1

Programmatic update of the specific updatepanel

If you want to update a specific updatepanel after your database modification programmatically, you can do it by UpdatePanel1.Update()

Export to Excel from UpdatePanel

If you gridview inside update panel, then when you export to excel on button click using Response.ContentType and Response.write method, you will get an error of Sys.Page... error. To overcome this, in the triggers section, have
asp:PostBackTrigger ControlID=xlsExport .

CollapsiblePanelExtender Flicker

Make sure that you have the same space in the browser / div width.

Check for any additional rendering tags like td, and attributes like width, height in the both panels.

ModalPopup for GridView Editing rows

http://mattberseth.com/blog/2007/07/modalpopupextender_example_for.html

The simple one is making one dummy button to assign targetcontrolID property of the Modal Popup Extender.

Error Handling for AJAX.ASP.NET update panel

http://ajax.asp.net/docs/tutorials/CustomizingErrorHandlingforUpdatePanel.aspx

IE hangs in AJAX Update Panel pages

Badly designed UpdatePanel may cause this issue in the popup IE page. For example, you have UpdatePanel in the start of the page. Then have a window.close button inside this UpdatePanel. Just close and open this 2 or 3 times from base IE. After that it hangs.

Resolution:

1. close button should not post back, so you can have return false in OnClientClick event
2. close button should be outside of update panel
3. call Sys.WebForms.PageRequestManager.getInstance().abortPostBack() on body unload

ModalPopup Flicker

This flicker at postback can be avoided by

div id="divProgress" runat="server" style="display: none"

asp:Panel runat="server" ID="pnUpdateProgress" Width="400px" BackColor="Gainsboro"
Height="100px"

and making divProgress display:block during the display of modalpopup

restartOnExternalChanges for appsettings

1. If you want to do this, you will have to change it in machine.config. By default, it is specified as true in machine.config.

2. If the appsettings are stored in external file like mySettings.config, then any changes to mySettings.config will not get effected if you specify appsettings "file" attribute. But if you specify "configSource" attribute, it is effected immediately.

Free Graph Control for ASP.NET 2.0

http://zedgraph.org/wiki/index.php?title=Main_Page

Cool Controls are available here. Another good open source from SourceForge

Leaving the page when Update Panel is processing

When updatepanel is processing, we may not be able to leave that page. If you forcefully leave that page, then memory leak or long pending server side process will take place and IE will hang for some time.

Resolution:
1. Have UpdateProgress and have "Abort Process" button and call


function AbortPostBack() {
if (Sys.WebForms.PageRequestManager.getInstance().get_isInAsyncPostBack()) {
Sys.WebForms.PageRequestManager.getInstance().abortPostBack();
} }

2. Write Javascript on body unload and call AbortPostBack() method. You may have this in Master Page.

Debugging Javascript in VS.Net

write debugger; in the javascript code. And UnCheck - Disable Script DeBugging in IE-Tools-Internet Options-Advanced.

That is it, you can do F10, F11 in VS.NET now.

AJAX Partial Postback event lifecycle

http://ajax.asp.net/docs/tutorials/UpdatePanelClientScripting.aspx

initializeRequest
beginRequest
pageLoading
pageLoaded
endRequest

so instead of page load, page unload method these events will be fired

Finding aspx pagename in ASP.NEt

System.IO.Path.GetFileName(Request.ServerVariables ["SCRIPT_NAME"])