title: Get other values in datasource of a dropdownlist in asp.net
body: <p>I have connected a Stored Procedure to a DropDownList</p>
  
  <p>The Stored Procedure has 3 values RepID, RepName, and RepRef</p>
  
  <p>The DropDownList has 2 values which are DataTextField and DataValueField</p>
  
  <p>I connected DataTextField to RepName and DataValueField to RepID</p>
  
  <p>I want to get the RepRef too</p>
  
  <p>how can I do that</p>
  
  <p>Here is my code</p>
  
  <pre><code>                conn.Open(); 
                  SqlCommand cmd = new SqlCommand("mySP", conn);
                  SqlDataAdapter da = new SqlDataAdapter(cmd);
                  cmd.CommandType = CommandType.StoredProcedure;
  
                  da.Fill(dt);
                  if (dt.Rows.Count &gt; 0)
                  {
                      ddlReps.DataSource = dt;
                      ddlReps.DataTextField = "RepName";
                      ddlReps.DataValueField = "RepID";
                      ddlReps.DataBind();
                  }
  </code></pre>
  
  <p>If User selected Report called "Cities" which has ID = 16 </p>
  
  <p>How Can I get the RepRef from there?</p>