Correct approach using Collections with GridView control asp.net c#
<p>Here is my typical scenario:</p>

<p>I have many c# business objects that more or less match my database design. I also have collections of these objects that I use to bind to gridviews. What is the best way to combine fields from both of these objects to my gridview (without using datatables or creating a view)</p>

<p>Let's say I want a gridview with the following columns: Product ID, Product Name, Product Cost, Shipping Company Name. Usually I simply get my collection of products from the database and use an item template for the shipping company name. I would then get the ShippingCompanyID in the rowdatabound event and go to the database again to get my shipping company name. I hate going to the database twice, can someone coach me on how I should approach this?</p>

<p>Product Class</p>

<ul>
<li>ProductID</li>
<li>Name</li>
<li>Cost</li>
<li>ShippingCompanyID</li>
</ul>

<p>Shipping Company Class</p>

<ul>
<li>ShippingCompanyID</li>
<li>Name</li>
</ul>
