title: Assign Different Value and Text to Dropdown List Items
body: <p>I am trying to populate a dropdown list on pageload with data from the batabase. </p>
  
  <p>While populating I want the dropdown items (<code>&lt;option&gt;</code>) to have the display text which is different from '<code>value</code>' of the <code>&lt;option&gt;</code></p>
  
  <p>For example: The dropdown list will show "Title" (column from db) as text on UI, but the '<code>value</code>' of the <code>&lt;option&gt;</code> should be "ID" (column from db)</p>
  
  <p>How do I achieve this?</p>
  
  <p>Currently my code is like this: (<code>drpReleaseTitle</code> is the ID of the dropdown)</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
          con1.Open();
  
          SqlCommand releaseTitlecmd = new SqlCommand("select Title from LWMDemo_ReleaseInfo order by ReleaseID", con1);
          SqlDataReader releaseTitledr = releaseTitlecmd.ExecuteReader();
          while (releaseTitledr.Read())
          {
              drpReleaseTitle.Items.Add(releaseTitledr.GetValue(0).ToString());
          }
          con1.Close();
      }
  }
  </code></pre>