Friday, August 12, 2011

Display Status of Long Running Process in ASP.NET using Jquery.

Whenever we encounter a long process in a web application, we don't want the user to see frozen browser for long time. He may find it difficult to assert whether the process is done or not. So its better that  we display the progress or tell about each sub process completion in such scenarios.

We can achieve this by using Web Services and JQuery to call the web service asynchronously to find out the status of the application.

Attached is the sample application which demonstrates the same.

P.S: We cannot use session to hold the status as using session will force asp.net to process the web service requests only after the long running process.

Drop out your comments or questions if you have any. Please let me know if there is a better way to achieve this task.

Sample Application

Wednesday, August 3, 2011

SQL Server restore

SQL Server - Take Back up  and restore and execute to fix the orphaned users. When u restore u dont find the user in msdb. so u have to execute this  .. (not sure abt this )


exec sp_change_users_login 'auto_fix','UserName',NULL,'Password'