Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

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 won't be updated when a value of one of its related tables changes.

 

a dataview-object isn't either what i'm looking for. they take only one table as source (but a normal database-views related on several tables)...

 

any ideas?

 

best regards

 

george

  • *Experts*
Posted

The best you'll 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 didn't get a chance to use it but it looked VERY promising (and worked, as far as I could tell).

 

-ner

"I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...