Database

kibromg wrote:

How or where would i get a database script?

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