Database

Guys is there any way that i make an Float Column output into Currency Format.. withoug rounding
e.g.
Float data is:

Name Price
Ambie 505.5560
James 44.240
Nicolas .5275
Moyano 20

OUTPUT
Ambie 505.55
James 44.24
Nicolas .52
Moyano 20.00

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