how to change en-US dates to en-GB for asp.net? ( M/d/yyyy to dd/MM/yyyy)

• en-US: M/d/yyyy (e.g. 3/14/2012)
• en-GB: dd/MM/yyyy (e.g. 14/03/2012)

 do the following in web.config file


<configuration/>

<system.web/>

<globalization culture="en-GB"/> 

</system.web>

</configuration> 

 

503 service unavailable IIS OR Application pool stops automatically in IIS7

SharePoint:
 
503 service unavailable:

application pool stops so you start the application pool of the web Application.

I got this error message when my application pool run with user Identity.

.Net:

1.you are given wrong user name or password you got this error message.

Do the following changes in application pool.

1.click on the application pool
2.click on advanced setting on the right pane.
3.click on Identity Under the process model.
4.select built in account under this user network(Ex:network service )
5.select custom account give user name and password


 

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified

CASE 1: if you are used order by clause in the following view
SELECT  
  C.customer_id
, C.customer_code
, C.customer_type_id
A.mobile ,A.email , A.phone
FROM clinic_customers C INNER JOIN address_details A ON A.address_id=C.address_id
order by C.last_update_on desc

You got following error message

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified

do small change above code as follows it is working fine
CASE 2: if you can use order by clause in the following view
SELECT   TOP 100 PERCENT 
  C.customer_id
, C.customer_code
, C.customer_type_id
A.mobile ,A.email , A.phone
FROM clinic_customers C INNER JOIN address_details A ON A.address_id=C.address_id
order by C.last_update_on desc