Friday, 26 September 2008

Linked server double hop

This is the best article I've found regarding the proper setup of servers for double hop in MS SQL 2005: http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

It is the best overview and most complete and yet simple explanation of the problem and the solution.

Wednesday, 24 September 2008

How to make objects available as datasources for databound controls

This attribute goes to the class:


   1:  // makes objects of this class suitable for binding to controls
   2:  [System.ComponentModel.DataObject] 

And this goes to the method:


   1:  // this attribute is so that the method will show up in the 
   2:  // ObjectDataSource wizard
   3:  [System.ComponentModel.DataObjectMethodAttribute(
   4:  System.ComponentModel.DataObjectMethodType.Select, true)]