creating View

G

ganders

Active member
Joined
Nov 25, 2004
Messages
32
hi folks

let me ask you an easy question: how are database-views loaded to a dataset? i like to load my whole oracle database (30 tables, 25 views) to a dataset for an offline editing-tool. but if i load the views as normal tables, they wont be updated when a value of one of its related tables changes.

a dataview-object isnt either what im looking for. they take only one table as source (but a normal database-views related on several tables)...

any ideas?

best regards

george
 
The best youll get, I think, is a custom class that works like a DataView. I found and converted (from VB.NET to C#) the JoinView sample from Microsoft - you can google for it. It allows you to create a DataView-like object that spans multiple tables. My need for it went away so I didnt get a chance to use it but it looked VERY promising (and worked, as far as I could tell).

-ner
 
Back
Top