Different Culture number format using a website

Changes in Web.Config:

<globalization enableClientBasedCulture="true" culture="de-DE" uiCulture="auto"/>

·         culture="de-DE" will set the language in which the Database will fetch the records, for e.g: if Database is of "de-DE" language then culture should be in "de-DE".

·         uiCulture="auto" will consider the language set in Clients browser for User Interface.

Page Level Changes:

Old Code: [Current Browser Culture will be set to Page Culture]

protected void Page_Init(object sender, EventArgs e)

    {

System.Globalization.CultureInfo pageCultureInfo = System.Globalization.CultureInfo.CurrentCulture;

      Page.Culture = pageCultureInfo.Name.ToString();

    }

New Code: [Current Browser Culture will be set to Page UICulture]

protected void Page_Init(object sender, EventArgs e)

    {

System.Globalization.CultureInfo pageCultureInfo = new CultureInfo(ApplicationConstants.RegionalSettings, false);

        Page.UICulture = pageCultureInfo.Name.ToString();

    }

Solution Status:

The Property Data type of in Class will be same as the Table field Data type

·         For Price and Weight fields

o   If data type of property is string the format is applied perfectly

o   If data type of property is double the formatting has problem

drOrder["Purchase_Price"] value is set to "1,50" in database

double dblPrice = Convert.ToDouble(drOrder["Purchase_Price"])  

dblPrice à shows "1.50"

dblPrice.ToString() àshows "1,50"

when binding to coolite grid it displays "1.50" instead of "1,50"

§  checked with forums  http://msdn.microsoft.com/en-us/library/system.convert.todouble(VS.71).aspx