Try this one:
invoiceItemTable.Columns.Add("Desc",
typeof(string),"MAX(Child.Description)");
> -----Original Message-----
> From: dotnet discussion [mailto:[EMAIL PROTECTED]]
> On Behalf Of Shawn Wildermuth
> Sent: Monday, April 22, 2002 1:08 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [DOTNET] DataColumn.Expression Syntax and Child.XXX
>
>
> Sorry, I didn't give any examples of what worked and didn't work:
>
> Doesn't Works:
> invoiceItemTable.Columns.Add("Price", typeof(float), "Child.Price");
>
> Works:
> invoiceItemTable.Columns.Add("Price", typeof(float),
> "Avg(Child.Price)");
>
> This works because it is a one-to-one relationship and it is a number.
> I haven't found any hacks to make it work for strings. What
> I want is:
>
> invoiceItemTable.Columns.Add("Desc", typeof(string),
> "Child.Description");
>
> Any ideas?
>
> Thanks,
>
> Shawn Wildermuth
> [EMAIL PROTECTED]
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
