Categories

Validating Email Addresses

Ok, validating an email address should not be difficult. You look up the definition in the RFC and write a little regular expression. Here is what I could extract from RFC 822:

address        =  mailbox                      ; one addressee                  /  group                        ; named list mailbox        [...]

Attaching User to a Login (SQL Server)

Probably most people already know – but it still happens often to me: When restoring a SQL database you cannot login even though the database user matches the SQL Server login. This can easily be fixed with the following command:

sp_change_users_login ‘AUTO_FIX’, ‘ [User_Name]’

DataContext.Connection.ConnectionString – No Password

My favourite way to clean up database tables is with a little stored procedures that runs from an async database command. It is a bit old fashioned but LinqToSql does not have any built-in async support. I want avoid that the clean-up tasks uses processing time of my application.

To create the async command I need [...]

Working with Enumerators in Business Data Catalog (Moss 2007)

I was just working through some BDC examples and thought that the way DbEntityInstanceEnumerator is being used is a shame. So, instead of each time using the MoveNext method and a cast I wrote these little extension methods:

public static void Foreach(this DbEntityInstanceEnumerator instances, Action<DbEntityInstance> action) { [...]

Site Column Web Part

Did you ever wonder if you could plug a SharePoint Field Control into a Web Part?

I did today – and yes, you can. The code is trivial. Instantiate the Field Control and add it to the controls collection. Ok, maybe normal people do not do that. But I wanted to add some flexibility to [...]