Tuesday, 21 December 2010

Get the value in datarow by column index in ADO.NET

Question:
Working with datasets has always been problematic.
For each property access you have to test again and again.
This is a case for a utility method and since .Net 2 an application of extension methods.

Sunday, 10 October 2010

Asp.Net: Initialize DropDown from Url Query Parametes

Question:
How do I initialize my drop down lists with query parameters?


Regular Expression Cheat-Sheet (javascript examples)

Question:
What are the most common regular expression rules and operators?

Thursday, 9 September 2010

Get the reference levels of all tables in a database.

Question:
We need a script to truncate tables in the right order to prevent Foreign Key violations.

Answer:
The script below can be used to determine the reference levels of all tables in a database.

Determine reference levels of all tables
Wednesday, 25 August 2010

Dot.Net: Discover Attributs on Properties Sample

Question:
How to discover attributes in a class?
I do I find all properties that are annotated with marker attribute?

Dot.Net:Create Attribut Sample

Question:
How do I create a custom attribute in dot.net?
Do you have a simple sample for attribute creation in c# / dot.net?

Wednesday, 11 August 2010

After restoring a database the owner has changed.

Question:
I restored a db from my production environment.
After that step certain things became strange. It was for example now impossible to install diagram support.
I always receive this error.