I'm fairly new to ADO.NET and haven't tried to do anything fancy with it
yet. It's not clear to me how to pose the question except in very
general terms. I'd be grateful for some advice.
I have a dataview based on a union query:
select COL1, COL2 ...
from Table1
UNION
select COL1, COL2 ...
from Table2
UNION
....
During the course of the editing session, the user may add or change
rows in Table1 and/or Table2, or delete rows from it. I would like the
union-dataview to act like a 'view' in Oracle or SQL Server -- not as a
stale point-in-time snapshot but always fresh.
Is there any way to trigger the dataview to do a "requery"? If I'm able
to leave the connection open (not a problem from a scalability
standpoint as the app will have only 6 users) can I get the union-query
dataview to "listen" for changes to the underyling database tables on
which it is based, and refresh itself as needed? Each of those other
tables will be updated via dataviews that belong to the same dataset as
the union-query dataview.
If the above is possible, can it be done also in a multi-user
environment, where changes to Table1 or Table2 can be made by someone
else? Can I get ADO.NET to act as though it were not "disconnected", or
somehow percolate a table-changed event up through the connection into
the dataset?
Thanks
Scot
|
Similar Threads
