Help! Problems with showing data from XML

[nacho2]

Hi everyone, I don't know how to do something that is very basic in a program like Access, hope somebody can help me out! I'm in trouble if not. Thanks in advance.

Got (let's say) three tables (sellers, houses, buyers) and a fourth one, called operations, which relates them all throuh their ID (sellerID, houseID, buyerID). Each row in the operations table has an operationID, a customerID, a houseID and a buyerID. (An operation is a house being sold by a seller and bought by a buyer).

I need to have a datagrid (or whatever as long as it looks like a table) where I can see: OperationID, HouseName, SellerName, BuyerName. All I can get is seeing the table operations and seeing all its rows which are just numbers (buyerID...) and I need it to select the HouseName from Houses where HouseID is the same as HouseID in table operations.

I'm not using a database, I'm storing my data in a xml document. Got the dataset working correctly.

Thank you very much for all your help

[CyberHawke]

As I read your description, a few things come to mind:

Does your dataset have datarelations between the tables?

Have you attempted to run a select against your dataset?

I will be testing this for the next half hour or so, but this information would be useful in helping to debug your problem.

[nacho2]

Hey thanks for your help,

Yes my data base has relations in between the tables.

The thing is that I don't know how to run a select command against a xml database. Something as simple as SELECT Name, Age FROM Customers WHERE erased=false is been impossible for me. I've always worked with php and mysql 'til now.

All I wanna do is something Access does very easily. Thanks again.

[CyberHawke]

Here is an article I found on MSDN that shows how to display data from more than one table in a dataset, in the same DataGrid.
HOW TO: Extend the Windows Form DataGridTextBoxColumn to Display Data From Other Tables by Using Visual Basic .NET