Re: Calculated Fields in Strongly Typed DataSets?
- From: "Miha Markic [MVP C#]" <miha at rthand com>
- Date: Wed, 11 Jan 2006 08:35:19 +0100
Though there is calculated field support built in DataTable (through
DataColumn.Expression) I would recommend to:
- add necessary column(s) do DataTable
- handle updating yourself (using RowChanged/ColumnChanged) events
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Tore" <tbostrup at agfirst> wrote in message
news:OfUaSBkFGHA.3036@xxxxxxxxxxxxxxxxxxxxxxx
> We have an XSD schema/object graph that for the most part reflects our
> database. I'm running into an issue where this granularity doesn't always
> match the need for using data from multiple datatables. For example, I
> have
> a master datatable with several detail datatables, and I would like to
> create (declare if I can) a "composite" containing column values from the
> master, as well as columns from other datatables along with aggregate
> values
> of data in yet other datatables.
>
> In reality, this resulting data will be displayed in a grid (one column
> will
> be updatable) and consurrently bound to other controls.
>
> If I was writing stored procedures and handcoding every operation, this
> would be quite straight forward, but I am trying to work with the object
> graph/schema approach.
>
> Is there a way to do this in the schema itself?
>
> What would be the best way to achieve this? Would I need to create
> derived
> DataViews and programmatically add expression columns? And would I have
> to
> implement the "external" accesses in event handlers?
>
> TIA,
> Tore.
>
>
.
- Follow-Ups:
- Prev by Date: Re: TableAdapter Garbage
- Next by Date: Re: TableAdapter Garbage
- Previous by thread: RE: (C#/2.0) ORA-01036 Error When Upd/Ins/Del from Gridview
- Next by thread: Re: Calculated Fields in Strongly Typed DataSets?
- Index(es):
Relevant Pages
|
