title: C# handling data between a DataSet and a ListBox
body: <p>I've had a look on the Internet and, whilst I have come across some content which is similar, I can't seem to find something which is directly related to what I'm trying to achieve.</p>
  
  <p>Briefly, I want to achieve the following:</p>
  
  <p>1) Extract data from a database into a DataSet;<br>
  2) Populate data which uses ONE of the columns of information from the DataSet;<br>
  3) Use the OnIndexChanged event to trigger a component on a form to display the corresponding values of the dataset in other columns as to what is displayed in the ListBox.</p>
  
  <p>I am running a query which returns the following results:</p>
  
  <p><a href="https://i.stack.imgur.com/WUfFj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WUfFj.png" alt="enter image description here"></a></p>
  
  <p>Having loaded this into a DataSet within C#, I want to populate a ListBox with the values in the 'ADDRESS' column.</p>
  
  <p>When selecting a record in that ListBox after populating it, I want a label caption on the form to display the corresponding ADDRESS_ID value associated with that ADDRESS record.</p>
  
  <p>I hope that outlines what I want to achieve in enough detail; what I've found so far is great for populating a list box but I'm stuck after this point when trying to reverse-engineer another value based on the selected index of the ListBox.</p>