Posts

C#: Format number to string with comma separated with thousand place

int number = 1000000000; string whatYouWant = number.ToString("#,##0"); //You get: 1,000,000,000

HTML5 Upload Directory

http://html5-demos.appspot.com/static/html5storage/demos/upload_directory/index.html#

How to reseed SQL Server identity coloumn

dbcc checkident ('TableName', reseed, 100)

How to find the top 10 largest files or directories in Linux

du -a /var | sort -n -r | head -n 10

Execute JavaScript in ASP.NET Code Behind

If you want to execute JavaScript in code behind for example after an event, you can: ScriptManager.RegisterStartupScript(this, GetType(), "anyName", "myScript();", true);

Include JavaScript in ASP.NET Master Page

When I directly put the following script in the markup of Master File. There is also some JavaScript error. It is because .aspx in different folder may using this master page, so javascript path may become incorrect. To solve it, you need to register the javascript in page_load method. Page.ClientScript.RegisterClientScriptInclude("jquery", ResolveUrl("~/Script/jquery-1.4.2.min.js"));

The SQL Server Service Broker for the current database is not enabled

The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications. ----Check if the service broker is enabled SELECT is_broker_enabled FROM sys.databases WHERE name = 'YOUR_DB' -- Enable broker ALTER DATABASE YOUR_DB SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE -- If fail above then new broker ALTER DATABASE YOUR_DB SET NEW_BROKER WITH ROLLBACK IMMEDIATE