Hello!

I'm new to this ADO thing so I have some questions. I'm using Visual Studio 2005 (.NET 2.0) and Oracle 10.

I understand how the OracleDataAdapter.Fill and .Update works for single tables (SELECT * FROM one_table). But how does it work if I do a more complex commandtext?


Like:
SELECT e.FirstName, o.ShipCity FROM Employees e, Orders o WHERE e.EmployeeID = o.EmployeeID ORDER BY e.FirstName

If I do a Fill() on that one, I get a result with FirstName from Employee and ShipCity from Orders. Like a charm.

But if I do an Update(), how would the code know that changes to FirstName goes into Employee and changes to ShipCity goes into Orders, and at the same time check so it's the right EmployeeID?


So, in other words what I want to achieve is:
I want to select a bunch of information from different tables. Show this to the user in a grid where the user can alter this information and then save the changes that the user have made.