Format Combobox value pulled from SQL database (LINQ) in C# Project (WPF)

Question

I need some help with the code below... I need to make the Float value pulled from the SQL Database in the Brazilian format of the Real Number Set in a C# (WPF) project in a Combobox (as Double). That is, bring it as String in Intemssource and not stay in this format "0.000", but in this "0,000".

Code:

var query_Fardo = from f in oDB.tabProdutos 
                  where f.Codigo == Convert.ToInt32(txtCodigoApontaPrd.Text) 
                  select f.Fardo;
CmBox_FardoApontaPrd.ItemsSource = query_Fardo;
CmBox_FardoApontaPrd.ItemStringFormat = "0,000";//Não funciona

Grateful for the support...

Answer 1

I didn’t understand if I wanted the guy to look like Double, but it follows a transforming response to string:

var query_Fardo = from f in oDB.tabProdutos 
                  where f.Codigo == Convert.ToInt32(txtCodigoApontaPrd.Text) 
                  select f.Fardo.ToString("#,###.###");

With that, it wouldn’t be necessary

Cmbox_fardoapontaprd.Itemstringformat = "0,000";