Returning Single-Row queries using ASP.NET using DataAdapter, DataTable, and DataRow
<p>I'm fairly new to ASP.NET and am working through a tutorial that demonstrates the use of DataAdapter, DataTable, and DataRow classes.  The tutorial focuses on binding returned DataTables to GridView objects - I'm having trouble understanding what to do to extract one row for display. </p>

<p>I've found I can do the following:</p>

<pre><code>ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); 
Northwind.ProductsTable productsTable = productsAdapter.GetSingleByProductID(searchID)
Northwind.ProductsRow productRow = (Northwind.ProductsRow)productsTable.Rows[0];
</code></pre>

<p>A ProductsTable should be able to return its own ProductRows w/o resorting to a cast, no?  Can't find how to do it otherwise.  </p>

<p>I'm thinking how to go about creating a form where the user will only ever be working on one record at a time.  Wouldn't it make sense for the DAL to return a ProductsRow instead of a ProductsTable? </p>
