Database

wienzzz wrote:

1. Is there anyway so the query result would contain all of the record instead of first record only??

wienzzz wrote:

I assume this has something to do with Localization class in C#. Am I right?

wienzzz wrote:

2. If not possible, any suggestion how to make it possible? maybe using Function in SQL Server? I'm barely new to SQL server..

When you create the database the collation sequence should be defined as Accent Insensitive (AI). It causes more problems that it is worth to individually define columns as a specific collation

wienzzz wrote:

can I just modify the properties after the database created?

<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"