title: Best list to use when ordering
body: <p>I'm extending my question here <a href="https://stackoverflow.com/questions/11426012/dynamically-creating-gridview">Dynamically Creating GridView</a> and trying a different approch as suggested, but im stuck again.</p>
  
  <p>I have a table that handles my names and order of key values.</p>
  
  <pre><code>KeyNames:
  ID Int primary key
  KeyName1 varchar(20)
  KeyOrder int
  KeyName2 varchar(20)
  KeyOrder int
  ...
  KeyNameN varchar(20)
  KeyOrder int
  </code></pre>
  
  <p>These Keys represent the Name and Order of another table to be displayed in a gridview. ie:</p>
  
  <pre><code> DocumentTable:
   ID int primary key
   PDF_Folder varchar(30)
   Key1value varchar(100)
   Key2value varchar(100)
   ..
   KeyNvalue varchar(100)
  </code></pre>
  
  <p>So in my gridview the user can decide the column names of the Keys and the value (I might want to called Key1 "description" order 1 and Key2 "Names Mentioned" and order 2.</p>
  
  <p>if Order &lt; 0 then it will not be displayed in the gridview. </p>
  
  <p>Im stuck on how I will create a gridview to display each columns for KeyNValue with the colmn name KeyNameN and the order of KeyOrderN..</p>