papillonuk - Developer IT

How do I access the .NET TimeZoneInfo class from SQL Server 2005?

- by papillonuk

The TimeZoneInfo class has a Host Protection Attribute of MayLeakOnAbort. This seems to prevent me accessing it from the SQL Server CLR. But is there a workaround?

Caching Web UserControl by Propety is not working (Grr!)

Here's my code behind: <PartialCaching(60, Nothing, "UsrCtl_WebUserControl.CacheString", Nothing, True)> _ Partial Class UsrCtl_WebUserControl Inherits System.Web.UI.UserControl Private _CacheString As String Public Property CacheString() As String Get Return _CacheString End Get Set(ByVal value As String) _CacheString = value End Set End Property End Class Here's the user control embedded in a page: <uc:wuc ID="wuc" runat="server" CacheString="A" /> And in another page: <uc:wuc ID="wuc" runat="server" CacheString="B" /> According to the docs this control should maintain a different, 60 second cached version for each value of the CacheString property. It doesn't work - it caches for 60 seconds, but only one cached copy is created regardless of what I put in the CacheString property. Anyone any ideas what i'm doing wrong? - After 4 hours of this I have no hair or nails left - please save my monitor from the brick.

Read the article

Only want "Required field" error to appear ONCE in ASP.NET Validation Summary

- by PapillonUK

I have a form with several fields with a RequiredFieldValidator on them. If any of these fields are not filled in I only want the message "Please enter the items marked with an asterisk" to appear once in the ValidationSummary control and an asterisk to appear next to each field. I have done this using the method here. i.e. by setting Text to "*" and ValidationSummary.HeaderText to my message. Great, but no cigar as I also have other fields with other validators e.g. a RegEx for an Email field. This means that if all the required fields are entered but the email is incorrect, the ValidationSummary with "Please enter the items marked with an asterisk" will appear along with the message for the invalid email. Crap! I then tried using a ValidationGroup called "ReqField" and have a one ValidationSummary for this group (with my HeaderText) and another for the other validators, but alas, my Submit button only allows one ValidationGroup to be triggered upon the click event. Does anyone have any ideas as to how I can get this to work? Thanks in adavnce.

Developer IT