Calculated field

[John]

Hi

I have a bond fields database winform app. How can I calculate a field form
one of the bound fields and show on form?

Thanks

Regards

[Cor Ligthert[MVP]]

John,

I am an expert in cryptic answers, however in this case you are an expert in
my idea in cryptic questions.

Cor

"John" <in**@nospam.infovis.co.ukschreef in bericht
news:O3**************@TK2MSFTNGP06.phx.gbl...

Hi

I have a bond fields database winform app. How can I calculate a field
form one of the bound fields and show on form?

Thanks

Regards

[John]

I have a bound form...Ok?

However..one of the field does not need to be bound instead calculated from
one of the bound fields...how to do it?

Let's say DOB is coming from a bound field? How to setup a Age field which
calculates from DOB?

Regards

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

John,

I am an expert in cryptic answers, however in this case you are an expert
in my idea in cryptic questions.

Cor

"John" <in**@nospam.infovis.co.ukschreef in bericht
news:O3**************@TK2MSFTNGP06.phx.gbl...

>Hi

I have a bond fields database winform app. How can I calculate a field
form one of the bound fields and show on form?

Thanks

Regards

[Cor Ligthert[MVP]]

This tip is not completely the same, however, you can do this normally using
the currency events

http://www.vb-tips.com/DataBindingEvents.aspx

Cor
"John" <in**@nospam.infovis.co.ukschreef in bericht
news:eQ**************@TK2MSFTNGP04.phx.gbl...

>I have a bound form...Ok?

However..one of the field does not need to be bound instead calculated
from one of the bound fields...how to do it?

Let's say DOB is coming from a bound field? How to setup a Age field which
calculates from DOB?

Regards

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>John,

I am an expert in cryptic answers, however in this case you are an expert
in my idea in cryptic questions.

Cor

"John" <in**@nospam.infovis.co.ukschreef in bericht
news:O3**************@TK2MSFTNGP06.phx.gbl...

>>Hi

I have a bond fields database winform app. How can I calculate a field
form one of the bound fields and show on form?

Thanks

Regards

[William Stacey]

If your class is custom, (i.e. not generated from entity model), a simple
method is to add a readonly property to the class and put custom code in the
getter. I just run into this myself with Format event not firing on a
binding and can not figure out why (inside the new datarepeater control).
So I used a calculated property instead and bind to that. Works well and
imo is cleaner.

"John" <in**@nospam.infovis.co.ukwrote in message
news:eQ**************@TK2MSFTNGP04.phx.gbl...

>I have a bound form...Ok?

However..one of the field does not need to be bound instead calculated
from one of the bound fields...how to do it?

Let's say DOB is coming from a bound field? How to setup a Age field which
calculates from DOB?

Regards

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>John,

I am an expert in cryptic answers, however in this case you are an expert
in my idea in cryptic questions.

Cor

"John" <in**@nospam.infovis.co.ukschreef in bericht
news:O3**************@TK2MSFTNGP06.phx.gbl...

>>Hi

I have a bond fields database winform app. How can I calculate a field
form one of the bound fields and show on form?

Thanks

Regards

[Steve Gerrard]

John wrote:

I have a bound form...Ok?

However..one of the field does not need to be bound instead
calculated from one of the bound fields...how to do it?

Let's say DOB is coming from a bound field? How to setup a Age field
which calculates from DOB?

If you are binding to a datatable, you can add a calculated column to the table,
and then bind a form control to the calculated column. Lookup
DataColumn.Expression to see what kind of calculations you can do, and what the
syntax is. Age is not a great example, by the way, since it changes every second
(and always in the direction of older, dang it all).

[Cor Ligthert[MVP]]

Steve,

You are right, in my opinion the best solution too.

Cor

"Steve Gerrard" <my********@comcast.netschreef in bericht
news:Rv******************************@comcast.com. ..

John wrote:

>I have a bound form...Ok?

However..one of the field does not need to be bound instead
calculated from one of the bound fields...how to do it?

Let's say DOB is coming from a bound field? How to setup a Age field
which calculates from DOB?

If you are binding to a datatable, you can add a calculated column to the
table, and then bind a form control to the calculated column. Lookup
DataColumn.Expression to see what kind of calculations you can do, and
what the syntax is. Age is not a great example, by the way, since it
changes every second (and always in the direction of older, dang it all).