Securing Images in ASP.NET c#

add new imageHandler.aspx

using System.IO;

protected void Page_Load(object sender, EventArgs e)
{
        string fileName = Request.QueryString["src"];
        long fileSize = 0;
        if (string.IsNullOrEmpty(fileName))
        {
            fileName = "empty.gif";
        }
        fileName = Server.MapPath("..\\images\\" + fileName);
        FileStream fileStream = default(FileStream);
        fileStream = new FileStream(fileName, FileMode.Open);
        fileSize = fileStream.Length;
        byte[] Buffer = new byte[Convert.ToInt32(fileSize) + 1];
        fileStream.Read(Buffer, 0, Convert.ToInt32(fileSize));
        fileStream.Close();
        Response.BinaryWrite(Buffer);
}

add new default.aspx
<img src="imageHandler.aspx?src=1.jpg" />

Replace all special characters in c# from string

Solution 1 : 
using System.Text.RegularExpressions;
public string RemoveSpecialCharacters(string str)
{
    return Regex.Replace(str, "[^a-zA-Z0-9_.]+", "", RegexOptions.Compiled);
}

Solution 2 :

public string RemoveSpecialChars(string str)
{
    string[] chars = new string[] { ",", ".", "/", "!", "@", "#", "$", "%", "^", "&", "*", "'", "\"", ";","_","(", ")", ":", "|", "[", "]" };

  for (int i = 0; i< chars.Lenght; i++)
  {
if (str.Contains(chars[i]))
{
str = str.Replace(chars[i],"");
}
   }
return str;
}

Way in asp.net c# to force https for an entire site?

protected void Application_BeginRequest(Object sender, EventArgs e)
{
   if (HttpContext.Current.Request.IsSecureConnection.Equals(false) &&      
   HttpContext.Current.Request.IsLocal.Equals(false))
   {
       Response.Redirect("https://" + Request.ServerVariables["HTTP_HOST"]
       + HttpContext.Current.Request.RawUrl);
   }
}


That would go in the global.asax.cs

Split by Delimiter In sqlserver

DECLARE @sInputList VARCHAR(8000)='7089:38:150'
,@sDelimiter VARCHAR(8000) = ':'
CREATE TABLE #List(ID INT IDENTITY(1,1),ITEM VARCHAR(1000))
DECLARE @sItem VARCHAR(8000)
WHILE CHARINDEX(@sDelimiter,@sInputList,0) <> 0
 BEGIN
SELECT
@sItem=RTRIM(LTRIM(SUBSTRING(@sInputList,1,CHARINDEX(@sDelimiter,@sInputList,0)-1))),
@sInputList=RTRIM(LTRIM(SUBSTRING(@sInputList,CHARINDEX(@sDelimiter,@sInputList,0)+LEN(@sDelimiter),LEN(@sInputList))))
IF LEN(@sItem) > 0
INSERT INTO #List SELECT @sItem
 END
IF LEN(@sInputList) > 0
   INSERT INTO #List SELECT @sInputList
------------------------------------------
SELECT * FROM #List
DROP TABLE #List

Search text from all PROCEDURE In sqlserver

SELECT DISTINCT object_name(id) FROM syscomments WHERE text LIKE '%Saved Successfully%' ORDER BY 1

Find Min/Max Value FROM datatable

private void populateMaxOrMinValue(DataTable dtRef)
{
 if (dtRef.Rows.Count > 0)
        {
        //////////PICK THE MAX VALUE FROM DATATABLE USING ENUMERABLE
         maxValue = dtRef.AsEnumerable()
               .Where(ss => double.TryParse(ss["value"].ToString(), out val))
               .Select(ss => Convert.ToDouble(ss["value"])).Max();
         //////////PICK THE MIN VALUE FROM DATATABLE USING ENUMERABLE
         minValue = dtRef.AsEnumerable()
                .Where(ss => double.TryParse(ss["value"].ToString(), out val))
                .Select(ss => Convert.ToDouble(ss["value"])).Min();
         //////////////////////////////////////////////
 }
}

Update Table by Joining In sqlserver

UPDATE X SET X.cloumnNanme = s.columnName ,X.cloumnNanme = s.cloumnNanme
FROM UpdatedTableName X INNER JOIN
ValueTableName s
ON(s.cloumnNanme = X.cloumnNanme)