title: JQGrid: Dropdown for selecting items from a foreign table - DataValueField vs DataTextField
body: <p>Suppose Items and ItemTypes have numeric primary keys ItemID and ItemTypeID. Each Item is assigned an ItemType. </p>
  
  <p>I have a JQGrid to edit Items. When not in edit mode, I would like to see the name of the ItemType, not the ItemTypeID:</p>
  
  <pre>
      TYPE       | TITLE
      -----------+--------------------
      Category A | Item 1
      Category A | Item 2
      Category B | Item 3
      Category B | Item 4
  </pre>
  
  <p>In edit mode, I want to see a dropdown that displays the ItemType text, but that returns the ItemTypeID to the server.</p>
  
  <p>Here's what I have so far (using the ASP.NET wrapper for JQGrid):</p>
  
  <pre><code>&lt;trirand:jqgrid id="Grid1" runat="server" ... &gt;
      &lt;columns&gt;
          &lt;trirand:jqgridcolumn datafield="ItemID" editable="false" visible="false" width="50" primarykey="true" /&gt;
          &lt;trirand:jqgridcolumn datafield="ItemTypeID" editable="true" edittype="DropDown" editorcontrolid="ItemTypes" /&gt;
          &lt;trirand:jqgridcolumn datafield="Title" editable="true" sortable="true" /&gt;
          ...
      &lt;/columns&gt;
  &lt;/trirand:jqgrid&gt;
  &lt;asp:sqldatasource runat="server" id="ItemTypesDatasource" connectionstring="&lt;%$ ConnectionStrings:Main %&gt;" selectcommand="Select ItemTypeID,Title from ItemTypes order by Title" /&gt;
  &lt;asp:dropdownlist runat="server" id="ItemTypes" datasourceid="ItemTypesDatasource" datavaluefield="ItemTypeID" datatextfield="Title" /&gt;
  </code></pre>
  
  <p>The problem is that when not in edit mode, it displays the numeric ItemTypeID, rather than the text labels:</p>
  
  <pre>
      TYPE       | TITLE
      -----------+--------------------
      100123     | Item 1
      100123     | Item 2
      100124     | Item 3
      100124     | Item 4
  </pre>
  
  <p>Is there any way to have JQGrid respect the distinction between DataValueField and DataTextField? (Either using the jQuery API or the ASP.NET plugin.)</p>