dropdownlist custom databinding
<p>DropDownList inside Gridview.</p>

<p>Database Schema:   </p>

<pre><code>Restaurants       Menus           Products
RestaurantID      MenuID          ProductID  
RestaurantName    MenuName        ProductName
                  RestaurantID    MenuID 
</code></pre>

<p>it doesnt work with this:</p>

<pre><code>&lt;asp:DropDownList ID="DropDownList8" runat="server" DataSourceID="ObjectDataSource3"
                                SelectedValue='&lt;%# Bind("MenuID") %&gt;'  DataTextField="RestaurantName" DataValueField="RestaurantID"&gt;
</code></pre>

<p>Gridview has GetAllProducts method.</p>

<p>ObjectDataSource3 has GetAllRestaurants method.</p>

<p>I want to edit and insert Menus of each Product. But I want to show RestaurantName indtead of MenuID..</p>

<p>When you want to bind Questions and Categories (just two) tables, this can work easily:</p>

<pre><code>&lt;asp:DropDownList ID="DropDownList8" runat="server" DataSourceID="ObjectDataSource3" SelectedValue='&lt;%# Bind("CategoryID") %&gt;' DataTextField="CategoryName" DataValueField="CategoryID"&gt;
</code></pre>

<p>I have 3 tables to reach data.. How can I do this?</p>

<p>Thanks</p>
