Hi.
Does anybody know how to perform complex calculations using the
DataColumn.Expression property?
Specifically, I'm trying to calculate the difference between a DateTime
column and the current date:
DateTime.Now.Subtract(certainDate).TotalDays

Is there a way to integrate custom functions in this property?

Hi Amir,

I think that it is best to manually perform such calculations in this case.
Refresh them in ColumnChanged event and do an DataRowAcceptChanges if he row
wasn't modified before.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Amir Shitrit" <(E-Mail Removed)> wrote in message
news:5D9C661C-1C29-465C-A4E1-(E-Mail Removed)...
> Hi.
> Does anybody know how to perform complex calculations using the
> DataColumn.Expression property?
> Specifically, I'm trying to calculate the difference between a DateTime
> column and the current date:
> DateTime.Now.Subtract(certainDate).TotalDays
>
> Is there a way to integrate custom functions in this property?

Amir,

In my opinion is the expression not to for doing *complex* calculations.

http://msdn.microsoft.com/library/de...ssionTopic.asp

On this page is only with this sample given how to use dates
"Birthdate < #1/31/82#"

Be aware that because every thing in dotNet is nicely globalized done, you
have to investigage how it has to be used with computers outside the USA,
because this is a typical USA notation and I don't know if it is for
computers (beside English speaking Canada) in the rest of the world
accoording those culture/language notations..

I hope this helps,

Cor

Hi,

What you could do is to catch an event of the DataTable when DataRow inside
of it has been changed and calculate new date inside of this event. Then
assign value to the column. At least it will work in all the cases when row
was modified
--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Amir Shitrit" <(E-Mail Removed)> wrote in message
news:5D9C661C-1C29-465C-A4E1-(E-Mail Removed)...
> Hi.
> Does anybody know how to perform complex calculations using the
> DataColumn.Expression property?
> Specifically, I'm trying to calculate the difference between a DateTime
> column and the current date:
> DateTime.Now.Subtract(certainDate).TotalDays
>
> Is there a way to integrate custom functions in this property?