Wednesday, May 29, 2013

Website URL validation in Java Script

funtion WebsiteValidation(){
 var website = document.getElementById("<%=TxtWeb.ClientID %>").value.toLowerCase();
            if (website != "") {
                var websitePart = website.split(".");
                    if (websitePart.length > 2) {
                    if (websitePart[0] == "www" && websitePart[1].length > 1 && websitePart[websitePart.length - 1].length < 4 && websitePart[websitePart.length - 1].length > 1) {
                    }
                    else {
                        alert('Invalid website');
                        return false;
                    }
                }
                else {
                    alert('Invalid website');
                    return false;
                }
            }
}

Monday, May 27, 2013

Website URL validation in C#

 public bool UrlValidation(string websiteUrl)
    {                var websitePart = websiteUrl.Split('.');
                    if (websitePart.Length > 2) {
                    if (websitePart[0] == "www" && websitePart[1].Length > 1 && websitePart[websitePart.Length - 1].Length < 4 && websitePart[websitePart.Length - 1].Length > 1) {
                    return true;
                    }
                    else {
                      
                        return false;
                    }
                }
                else {
                   
                    return false;
                }
}

Friday, May 17, 2013

Remove Special Characters in SQL Server

Below is code:

Create Function [dbo].[RemoveNonAlphaCharacters]
(
   @Temp VarChar(1000)

Returns VarChar(1000) 
AS 
Begin 
 
    Declare @KeepValues as varchar(50) = '%[^a-z0-9]%' 
    While PatIndex(@KeepValues, @Temp) > 0 
        Set @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, '') 
 
    Return @Temp 
End