Accessing Data in Datasets from XML
I am using a dataset as a data source for a combo box.
The example of the XML i am loading in the dataset is:
John
Smith
Something
Somewhere
John2
Smith2
Something2
Somewhere2
In the combo box i want to load up the rentals to only one of the customers.
Currently i can get all the rentals for all the customers by using:
comboBox.DataSource = rentalData.Tables[1];
comboBox.DisplayMember = "Rental_Name";
I can also access the data of the Customers by using:
comboBox.DataSource = rentalData.Tables[0];
comboBox.DisplayMember = "First_Name";
but i dont know how to access the rental table of the customer.
How can i do this?