title: Drop down list not binding with sqldatareader
body: <p>i have a form with a collection of about five drop down . i have my query as follows .</p>
  
  <pre><code> string sql = "SELECT a.clientID ,a.[cname],b.bid,b.[bname],c.contactID, c.[name] FROM "
                           + " dbo.[CLIENT] AS a INNER JOIN dbo.[BRANCH] AS b "
                           + "ON a.clientID = b.clientID JOIN dbo.[CONTACT] AS "
                           + " c ON b.bid = c.bid ORDER BY a.clientID ";
  </code></pre>
  
  <p>i then followed and bind my drop down individually to their respective columns as follows.</p>
  
  <pre><code>    SqlCommand cmd = new SqlCommand(sql, connection);
      cmd.CommandType = CommandType.Text;
  
  
      SqlDataReader reader = cmd.ExecuteReader();
  
  
  
  
          drClient.Enabled = true;
          drClient.DataSource = reader;
          drClient.DataTextField = "cname";
          drClient.DataValueField = "clientID";
          drClient.DataBind();
  
          drBranch.Enabled = true;
          drBranch.DataSource = reader;
          drBranch.DataTextField = "bname";
          drBranch.DataValueField = "bid";
          drBranch.DataBind();
  
          drContact.Enabled = true;
          drContact.DataSource = reader;
          drContact.DataTextField = "name";
          drContact.DataValueField = "contactID";
  
          drContact.DataBind();
  
  
          drEmail.Enabled = true;
          drEmail.DataSource = reader;
          drEmail.DataTextField = "name";
          drEmail.DataValueField = "contactID";
          drEmail.DataBind();
  
  
          drFax.Enabled = true;
          drFax.DataSource = reader;
          drFax.DataValueField = "contactID";
          drFax.DataTextField = "name";
          drFax.DataBind();
  </code></pre>
  
  <p>when i run this, only the first drop down bind successfully. The rest don't. I also try to loop through the reader by adding</p>
  
  <pre><code>while(reader.read())
  {
  then my bindings
  }
  </code></pre>
  
  <p>the above also fails. I though of looping as below as well.</p>
  
  <pre><code>while(read.HasRows)
  {
  
  }
  </code></pre>
  
  <p>it still fails. I am confused,any help would be appreciated. thanks</p>