title: C# data bound ListBox
body: <p>I have the following two <a href="/questions/tagged/ms-access" class="post-tag" title="show questions tagged &#39;ms-access&#39;" rel="tag">ms-access</a> tables:</p>
  
  <p>Employee table:  </p>
  
  <pre><code>EmployeeID  
  Name
  </code></pre>
  
  <p>etc.  </p>
  
  <p>Project table:  </p>
  
  <pre><code>ProjectID  
  EmployeeID  
  ProjectDescription
  </code></pre>
  
  <p>Each Employee can manage zero or more projects.</p>
  
  <p>I know how to use the <code>DataSet</code> Designer to add the Employee table as details (multiple bound controls) on <code>Form1</code> (<strong>Windows Form Application</strong>):</p>
  
  <p>Dragging the Company database's Employee table (as details) to form creates the following components:  </p>
  
  <p>• CompanyDataSet<br>
  • employeeBindingSource<br>
  • employeeTableAdapter<br>
  • tableAdapterManager<br>
  • employeeBindingNavigator  </p>
  
  <ol>
  <li><p>How do you add a ListBox to Form1 that displays the ProjectDescription of all the projects the currently displayed Employee manages?  What ListBox properties need to be set?</p>
  
  <p>I believe I will need the following query:  </p>
  
  <pre><code>SELECT Project.ProjectDescription  
  FROM  Project RIGHT JOIN Employee ON Project.EmployeeID = Employee.EmployeeID  
  WHERE EmployeeID = ?  
  </code></pre>
  
  <p>Parameter would be the employeeIDtextbox.Text  </p></li>
  <li><p>Project records will be created programmatically (OleDbConnection, OleDbCommand) from Form2.  What statement is required to update Form1 when it is displayed?</p></li>
  </ol>
  
  <p>I have searched the web and read pages and pages of Microsoft documentation and have hit a wall...</p>