[ValidationProperty("Text")]
public class CustomControl : CheckboxList
    { yadayada... }

to the class definiton of the control to tell the ASP.Net validation framework what value to validate...simple, huh? Just replace the "Text" in the live above with the Property of your custom control to be validated.

There are only 2 preconditions: 7-zip installed and xp-cmdshell enabled (see this).

USE MASTER

CREATE procedure spBackupAndFtpDB
@FTPServer    varchar(128) ,
@FTPUser    varchar(128) ,
@FTPPWD        varchar(128) ,
@FTPPath    varchar(128) = '/' ,
@DBList            varchar(MAX),
@Delimiter    varchar(MAX) = ',',
@ZipBackup    bit = 1,
@DelteLocalFiles bit = 1,
@workdir    varchar(128) = 'C:\Windows\Temp\',
@7zipdir    varchar(255) = 'C:\Program Files\7-zip\'

as
    -- deal with special characters for echo commands
    select @FTPServer = replace(replace(replace(@FTPServer, '|', '^|'),'<','^<'),'>','^>')
    select @FTPUser = replace(replace(replace(@FTPUser, '|', '^|'),'<','^<'),'>','^>')
    select @FTPPWD = replace(replace(replace(@FTPPWD, '|', '^|'),'<','^<'),'>','^>')
    select @FTPPath = replace(replace(replace(@FTPPath, '|', '^|'),'<','^<'),'>','^>')
    
    declare    @cmd varchar(1000)
    declare @workfilename varchar(128)
    
    DECLARE @SourceFile varchar(255)
    
    create table #a (id int identity(1,1), s varchar(1000))
           

    --start loop
    DECLARE @CSVString varchar(MAX);
    SET @CSVString = @DBList

    DECLARE @pos INT;
    DECLARE @DB VARCHAR(MAX);

    SELECT @pos = 1;

    WHILE @pos!= 0
    BEGIN
        SET @pos = CHARINDEX(@Delimiter,@CSVString);
        IF @pos != 0
            SET @DB = LTRIM(RTRIM(LEFT(@CSVString, @pos - 1)));
        ELSE
            SET @DB = LTRIM(RTRIM(@CSVString));

        IF( LEN(@DB) > 0)
        BEGIN

            --backup    
            SET @SourceFile = @DB + CONVERT(VARCHAR(6), GETDATE(), 12) + '.bak'
            SELECT @cmd = 'BACKUP DATABASE [' +   @DB + '] TO  DISK = N''' + @workdir + @SourceFile + ''' WITH NOFORMAT, INIT,  NAME = N''' + @DB + '-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD,  STATS = 100'
            EXEC (@cmd)



            --compress
            IF @ZipBackup = 1 BEGIN
                SELECT @cmd = '"' + @7zipdir +'7z" a ' + @workdir + @SourceFile + '.7z ' + @workdir + @SourceFile
                print @cmd
                insert #a
                exec master..xp_cmdshell @cmd
               
                IF @DelteLocalFiles = 1
                BEGIN
                    --remove backup
                    SELECT @cmd = 'del "' + @workdir + @SourceFile + '"'
                    print @cmd
                    insert #a
                    exec master..xp_cmdshell @cmd
                END
           
                --set zipped sourcefile
                SELECT @SourceFile = @SourceFile + '.7z'
            END
           
           

            --ftp
            select @workfilename = 'ftpcmd.txt'
           
            select    @cmd = 'echo '                    + 'open ' + @FTPServer
                    + ' > ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + @FTPUser
                    + '>> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + @FTPPWD
                    + '>> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + 'put ' + @workdir + @SourceFile + ' ' + @FTPPath + @SourceFile
                    + ' >> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
            select    @cmd = 'echo '                    + 'quit'
                    + ' >> ' + @workdir + @workfilename
            exec master..xp_cmdshell @cmd
           
            print @cmd
            select @cmd = 'ftp -s:' + @workdir + @workfilename
           
            insert #a
            exec master..xp_cmdshell @cmd

           
--Not logged in.
--Login failed.
--File not found

            IF @DelteLocalFiles = 1
            BEGIN
                --remove backup
                SELECT @cmd = 'del "' + @workdir + @SourceFile + '"'
                print @cmd
                insert #a
                exec master..xp_cmdshell @cmd
            END
           
           
            --report results
            SELECT id, ouputtmp = s FROM #a WHERE s IS NOT NULL
           
            IF EXISTS(SELECT * FROM #a WHERE s LIKE '%Not logged in%' OR s LIKE '%Login failed%' OR s LIKE '%File not found%' OR s like '%WARNINGS for files%')
            BEGIN
                SET @cmd = 'An Error occured during Backup and FTP. Details: '
                SELECT @cmd = @cmd + '; ' + ISNULL(s, '') FROM #a WHERE s IS NOT NULL
                RAISERROR (@cmd, -- Message text.
                   16, -- Severity.
                   1 -- State.
                   );
            END
           

        END

        SET @CSVString = RIGHT(@CSVString, LEN(@CSVString) - @pos);
    END
    
    
    RETURN 0
    
go

Note: No Codebehind needed! And jsut add a little .js and .css found here and my menu was able to render without a <form> tag. Hooray. That saved the day!

(SELECT STUFF((SELECT ', ' + Type FROM dbo.Reactor r FOR XML PATH('')),1,1,''))

namespace Data
{
    using System.Data.Linq.Mapping;
    using System.Data.Linq;
    using System.Reflection;
    partial class MyDataContext
    {

...

}

Problem: If you add a sample.zh.resx for the Chinese version you get an error "...already contains a definition for..." because there is no invariant zh culture! So the runtime tries to generate a neutral proxy...for most languages there is an invariant version (http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo%28VS.71%29.aspx) but not for Chinese. You have to choose a specific culture instead. e.g. zh-CHS for traditional Chinese.

<%@ Page Language="VB" %>
<%@ Import Namespace="Microsoft.Win32" %>

<script runat="server">
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim componentsKeyName As String = "SOFTWARE\Microsoft\NET Framework Setup\NDP"
        Dim componentsKey As RegistryKey = Registry.LocalMachine.OpenSubKey(componentsKeyName)
        Dim instComps As String() = componentsKey.GetSubKeyNames()
        For Each instComp As String In instComps
            Dim key As RegistryKey = componentsKey.OpenSubKey(instComp)
            If instComp IsNot Nothing AndAlso instComp.StartsWith("v") Then
                lblVersion.Text = lblVersion.Text & instComp & " SP " & key.GetValue("SP") & ", "
            End If
        Next
    End Sub
</script>

<html>
<head runat="server">   
    <title>CLR Versions</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:Label ID="lblVersion" runat="server">Your server is running ASP.NET and the versions are: </asp:Label>
    </form>
</body>
</html>




 

Here is a schematic overview of what you can do with this Full Text Personalization Provider Framework. Download sample Project to support Full Text Search. All you need to do is implement your custom storage: CustomPersonalization.zip