Thursday 7 April 2011

Formatting a date in a bound field

For your basic gridview:

DataFormatString="{0:dd/MM/yyyy}"

And for a devexpress gridview:

PropertiesTextEdit-DisplayFormatString="{0:dd/MM/yyyy}"

Monday 5 July 2010

SQLServer - Search all stored procedures for a string

I find this a very useful little search tool

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchString%'