Snipplr

(C#) Load different layout page based on controller - lance

Wed, 15 Jan 2014 02:13:17 UTC

How to load a different layout page for specific controller in case you need to change includes etc. Add to _ViewStart.cshtml

(C#) Change person's name to upper and lower - lance

Fri, 20 Jul 2012 05:28:04 UTC

Makes first letter upper and the rest lower except for names like Mcsomething

(Regular Expression) Regular expression for smalldatetime in SQL - lance

Tue, 08 May 2012 23:05:30 UTC

This only constraint here for smalldatetime is the year which allows 1900-2079. This does allow normal months and days so you could go outside the smalldatetime since that allows only 1/1/1900-6/6/2079.

(jQuery) JQuery autocomplete with custom display and fill form - lance

Thu, 27 Oct 2011 03:57:07 UTC

Only display the name in the search box but get the ID of the record and place it in a hidden field. When select is fired then fill form fields including the hidden field.

(JavaScript) Fill 4 digit year from 2 digits - lance

Wed, 23 Feb 2011 08:18:41 UTC

Add either 19 or 20 depending on the current year + 10

(C#) Encrypt connectionstrings in app.config - lance

Fri, 04 Feb 2011 03:12:24 UTC

(C#) Get logged in user from Active Directory and then get some of their AD attributes - lance

Thu, 03 Feb 2011 10:00:49 UTC

(C#) Screen scrape to get HTML page from client and send to database as binary-return again - lance

Thu, 03 Feb 2011 09:46:21 UTC

(JavaScript) TinyMCE configuration for rich textbox - lance

Thu, 03 Feb 2011 09:37:41 UTC

(Visual Basic) LDAP query to find all users without an entry in the webpage field in Active Directory - lance

Thu, 03 Feb 2011 06:55:47 UTC

(SQL) Fix broken username after database attach - lance

Thu, 05 Aug 2010 05:52:28 UTC

Sometimes the first set of parameters don't work so then use the second

(SQL) Create audit fields in table and create triggers to insert and update them - lance

Thu, 05 Aug 2010 05:50:27 UTC

(SQL) Update one table from another using join - lance

Thu, 05 Aug 2010 05:43:36 UTC

(SQL) Find duplicate records in table - lance

Thu, 05 Aug 2010 05:39:08 UTC

(SQL) Find tables in database with specified text in name - lance

Thu, 05 Aug 2010 05:36:16 UTC

(SQL) List all tables and fields in database - lance

Thu, 05 Aug 2010 05:34:50 UTC

(SQL) Find Stored Procedures with specified name or contains specified text - lance

Thu, 05 Aug 2010 05:31:48 UTC

(JavaScript) Remember div scroll position using javascript and ASP.Net - lance

Thu, 05 Aug 2010 00:57:00 UTC