Datatypfloat shows in datagrid 5 on instead of 5.00?

  • Thread starter Thread starter Michael Schindler
  • Start date Start date
M

Michael Schindler

I use C# windows Appl.

My problem i have is whit my column amount.
In the database i have float as datatyp an my datagris shows the amount
place without decimal.

I know dgTextBoxColumn.Format but functioned with me not.

Please can anywhere me help.

Thanks

Michael

Here my code:

private void dataGridFiBuErfassenFormatierung()

{ DataGridTextBoxColumn dgTextBoxColumn = new DataGridTextBoxColumn();

dgTextBoxColumn.Format = "D";

dataGridFiBuErfassen.CaptionText="Buchungungen";

dataGridFiBuErfassen.ReadOnly = false; //Tabellen Zugriff sperren, markieren
erlaubt


dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[0].Widt
h=0;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[1].Widt
h=70;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[1].Head
erText = "Beleg Nr.";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[1].Null
Text = "";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[2].Widt
h=70;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[2].Head
erText = "Datum";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[2].Null
Text = DateTime.Today.ToShortDateString();

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[3].Widt
h=30;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[3].Head
erText = "Typ";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[3].Null
Text = "S";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[4].Widt
h=70;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[4].Head
erText = "Konto Nr.";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[4].Null
Text = "";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[5].Widt
h=200;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[5].Head
erText = "Buchungstext";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[5].Null
Text = "";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[6].Widt
h=70;

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[6].Head
erText = "Betrag";

dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[6].Null
Text = "";

//dataGridFiBuErfassen.TableStyles["tblFiBuErfassen"].GridColumnStyles[7].Wi
dth=70;

}
 
Michael Schindler wrote:

[...]

Sorry, nobody will be able to help you. Please learn english or use the
newsgroup of your native language, if available:

microsoft.public.br.dotnet.languages.csharp
microsoft.public.cn.dotnet.languages.csharp
microsoft.public.de.german.entwickler.dotnet.languages.csharp
microsoft.public.es.csharp
microsoft.public.fi.dotnet.languages.csharp
microsoft.public.fr.dotnet.languages.csharp
microsoft.public.in.csharp
microsoft.public.it.dotnet.csharp
microsoft.public.kr.dotnet.csharp
microsoft.public.tw.dotnet.languages.csharp

HTH,

Michael
 
thank you for help :-(

For Example:

I have a field in my database whit datatyp float.
In my Datagrid show this fild whitout the 00.

I will show this 00 how i can make that the datagrid shows nummber for
example 5$ => 5.00?

Thank you for help

Michael
 
Michael

A quick and dirty way is to modify the datatype of your column on the
fly:

Assuming your first column is the double,

dataTable1.Columns[0].DataType = typeof(System.Int32);



Hope that helps,

Charles Steinhardt[MVP]
(To Email: remove _SPAM_ME_NOT_ from return address)
 
:-(

Error message:

An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll

Additional information: Cannot change DataType of a column once it has data.

----------------------------------------------------------------------------

This is my code:

ds.Tables["tblFiBuErfassen"].Columns[7].DataType = typeof(System.Int32);

any ideas?



Thanks michael
 
Back
Top