Asp.Net Menu Not work in crome when control contaion Submenu .

Solution for crome.
write this code in page_lode event.

if (Request.UserAgent.IndexOf("AppleWebKit") > 0)
       {
           Request.Browser.Adapters.Clear();
       }

function in sql server that get the numeric value from string...

CREATE FUNCTION dbo.GetNumeric
(@strAlphaNumeric VARCHAR(256))
RETURNS VARCHAR(256)
AS
BEGIN
DECLARE @intAlpha INT
SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric)
BEGIN
WHILE @intAlpha > 0
BEGIN
SET @strAlphaNumeric = STUFF(@strAlphaNumeric, @intAlpha, 1, '' )
SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric )
END
END
RETURN ISNULL(@strAlphaNumeric,0)
END
GO

To covert from HTTP: to HTTPS

<%
dim srvname
dim scrname
    if Request.ServerVariables("HTTPS") = "off" then
        srvname = Request.ServerVariables("SERVER_NAME")
        scrname = Request.ServerVariables("SCRIPT_NAME")
        response.redirect("https://" & srvname & scrname)
    end if

    ' continue "secure" code here
Response.Write("Redirect test")
    %>

For deleting the Duplicate rows from table in sql server 2005

WITH CTE (column1,column2, DuplicateCount)
AS
(
SELECT column1,column2,
ROW_NUMBER() OVER(PARTITION BY column1,column2 ORDER BY column1) AS DuplicateCount
FROM tablename
)
DELETE
FROM CTE
WHERE DuplicateCount > 1
GO