ToString() format is not working

I've a strange problem. We use Dutch and French lanuage on our site (nl-NL / fr-FR)

I'm binding to a gridview and the strange thing is, the numeric value-saparator (dot) is not displaying well for French (fr-FR)

ASP.NET

protected void gridview_RowDataBound(object sender, GridViewRowEventArgs e)
{
    Label lbla_min_10 = new Label();
    lbla_min_10 = e.Row.FindControl("lbla_min_10") as Label;
    lbla_min_10.Text = ((int)DataBinder.Eval(e.Row.DataItem, "a_min_10")).ToString("#,#.###");
    //....
}

e.g. DB value is 24369

in Dutch it displays 24.369 and

in French it displays 24 369 -> there is no DOT separator, but an empty space.

I looked at the view source and the code looks the same excep开发者_运维问答t theres is a (dot) in NL and (space) in FR.....

Does someone have any idea?

why does it work for Dutch (nl-NL) fine and not for French (fr-FR)?

Try using "nl-BE" and "fr-BE". They use the same formatting when it comes to numbers.

String.Format("{0:##,###}", 12345); // nl-NL: 12.345
String.Format("{0:##,###}", 12345); // fr-FR: 12 345
String.Format("{0:##,###}", 12345); // nl-BE: 12.345
String.Format("{0:##,###}", 12345); // fr-BE: 12.345

That's how the french denote thousands. with a space. The dutch use a .(full stop), the Engish use a , (comma).

So the regional formatting is working as expected.

In the 'Fr Culture' there is no separator between 1000's and 100's. So if you write 10.000 in dutch you can write 10 000 in french.. Why is it a problem?

Well, it behaves correctly. The problem is, what you actually used is grouping (thousands) separator. If you want it to be formatted always with full stop, add CultureInfo.InvariantCulture as second parameter.