asp.net calendar: disable past months

protected void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
{
  if (e.NewDate < DateTime.Today)
  Calendar1.VisibleDate = DateTime.Today;
}

Ajax CascadingDropDown: method error 500

Якщо Вы заюзали CascadingDropDown і отримали method error 500,
то потрібно лише додати атрибут
[System.Web.Script.Services.ScriptService()]
до класу вашого сервіса.

  [WebService(Namespace = "http://tempuri.org/")]
  [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
  [System.Web.Script.Services.ScriptService()]
   public class ClientsService : System.Web.Services.WebService
   {...}

MSSQL split function

CREATE FUNCTION [dbo].[Split](@text nvarchar(max)) 
 RETURNS @Strings TABLE 
( 
 value nvarchar(max) 
) 
AS 
BEGIN 
 DECLARE @index int 
 DECLARE @delimiter char(1)
 
 SET @index = -1 
 SET @delimiter = ',' 
    
 WHILE (LEN(@text) > 0) 
 BEGIN 
  SET @index = CHARINDEX(@delimiter , @text) 
  IF (@index = 0) AND (LEN(@text) > 0) 
  BEGIN 
   INSERT INTO @Strings VALUES (@text) 
   BREAK 
  END 
  IF (@index > 1) 
   BEGIN 
    INSERT INTO @Strings VALUES (LEFT(@text, @index - 1)) 
    SET @text = RIGHT(@text, (LEN(@text) - @index)) 
   END 
  ELSE 
   SET @text = RIGHT(@text, (LEN(@text) - @index)) 
  END 
 RETURN 
END