How to simulate WAN (Wide Area Network) in LAN (Local Area Network)

Anyone ever needed to test the web application on a low bandwidth WAN link? But u can’t afford create a link using actual routers and other networking equipment.  I came across such situation where, a web application works fine within the development environment which is a LAN. But when application is deployed in the actual environment which is a WAN with low bandwidths like 128Kbps it becomes very slow to response. My solution was WINEM.

How to prevent user from double clicking button on a web application

I faced with situations where users click a button on a web application, and before the request was processed and response comes to the client user clicks again. This may produce inconsistent and unexpected results. A calculation will be performed twice or an entry is posted twice.

In order to prevent this I used was disabling the button until the response using java script.

How to Import data in Excel sheet to SQL Express Database using AD-HOC Query

This something I got to do, Import data in Excel 2007 sheet to table in MS SQL database in SQL Express 2005. So I'm blogging it anyone who need can quickly get it done.
Here are the details you need to know:
Excel File: D:\MyTable.xls
Excel Sheet: Sheet1
SQL database: NewTestDB
Database Table: TestTable (This doesn't exist yet)