title: How do I bind the result of DataTable.Select() to a ListBox control?
body: <p>I have the following code:</p>
  
  <pre><code>ListBox.DataSource = DataSet.Tables("table_name").Select("some_criteria = match")
  ListBox.DisplayMember = "name"
  </code></pre>
  
  <p>The <a href="http://msdn.microsoft.com/en-us/library/system.data.datatable.select(VS.80).aspx" rel="noreferrer"><code>DataTable.Select()</code> method</a> returns an array of <a href="http://msdn.microsoft.com/en-us/library/system.data.datarow(VS.80).aspx" rel="noreferrer"><code>System.Data.DataRow</code></a> objects.</p>
  
  <p>No matter what I specify in the <code>ListBox.DisplayMember</code> property, all I see is the ListBox with the correct number of items all showing as <code>System.Data.DataRow</code> instead of the value I want which is in the <code>"name"</code> column!</p>
  
  <p>Is it possible to bind to the resulting array from <code>DataTable.Select()</code>, instead of looping through it and adding each one to the <code>ListBox</code>?</p>
  
  <p>(I've no problem with looping, but doesn't seem an elegant ending!)</p>