Database

<br />
byte[] img = (searchContact["Photo"] == DBNull.Value) ? null : (byte[])searchContact["Photo"];<br />

public static T GetData<T>(IDataReader rdr, string column)
{
  if (string.IsNullOrEmpty(column))
    throw new ArgumentNullException("column");
  if (rdr == null)
    throw new ArgumentNullException("rdr");
  int pos = rdr.GetOrdinal(column);
  T returnValue = (rdr[pos] == DBNull.Value) ? default(T) : (T)rdr[pos];
  return returnValue;
}

byte[]img = GetData<byte[]>(reader, "Photo");
string contact = GetData<string>(reader, "Contact");

AlirezaMaddah wrote:

If @FILTER IS NOT NULL
WITH RECOMPILE

IF @FILTER IS NULL BEGIN
  -- Query without filtering
END
ELSE BEGIN
  -- Query with filtering
END

SELECT item1, item2,...
FROM table1
WHERE (ID = @ID OR @ID IS NULL)
AND (Name = @Name OR @Name IS NULL)

aspnet_regiis -pe "connectionStrings" -app "/MyWebApp"