Assigning same datasource to multiple DropDownLists?
<p>I want to assign same datasource to multiple DropDownLists in a form, when the page loads, only the first drop down list has filled the content of datasource, others are empty, what's the missing point? thanks for answers. Here are the codes;</p>

<pre><code>&lt;form id="form1" runat="server"&gt;    
    &lt;asp:ScriptManager ID="scriptManager1" runat="server"&gt;&lt;/asp:ScriptManager&gt;
&lt;asp:UpdatePanel ID="panel1" runat="server" UpdateMode="Conditional"&gt;
    &lt;ContentTemplate&gt;
     &lt;div id="div1" align="center"&gt;
      &lt;table&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Brand-Model&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:TextBox ID="brandText" runat="server" BorderStyle="Inset"&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="brandText" Display="Dynamic" ErrorMessage="*"&gt;&lt;/asp:RequiredFieldValidator&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Black&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="blackList" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:HyperLink ID="HyperLink1" runat="server" Text="Add Cartridge" NavigateUrl="~/Admin/addCartridge.aspx"&gt;&lt;/asp:HyperLink&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Color1&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="colorList1" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
       &lt;/tr&gt; 
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Color2&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="colorList2" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Color3&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="colorList3" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Other1&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="otherColor1" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Other2&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="otherColor2" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;b&gt;Other3&lt;/b&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:DropDownList ID="otherColor3" runat="server"&gt;&lt;/asp:DropDownList&gt;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:Button ID="submit" runat="server" Text="Submit" OnClick="submit_OnClick" /&gt;&lt;/td&gt;       
       &lt;/tr&gt;            
       &lt;tr&gt;
         &lt;td&gt;&lt;/td&gt;
         &lt;td&gt;&lt;asp:Label ID="submitInfo" runat="server"&gt;&lt;/asp:Label&gt;&lt;/td&gt;       
       &lt;/tr&gt;
      &lt;/table&gt;
     &lt;/div&gt;
    &lt;/ContentTemplate&gt; 
    &lt;Triggers&gt;
        &lt;asp:AsyncPostBackTrigger ControlID="submit" EventName="Click" /&gt;   
    &lt;/Triggers&gt;   
   &lt;/asp:UpdatePanel&gt; 
&lt;/form&gt;
</code></pre>

<hr>

<pre><code>protected void FillTheDropDownLists()
    {
        SqlApplication con = new SqlApplication();
        try
        {
            SqlCommand cmd = new SqlCommand("SELECT name FROM BT.dbo.Cartridge ORDER BY name", con.GetConnection());
            con.OpenSqlConnection();

            SqlDataReader reader = cmd.ExecuteReader();

            blackList.DataValueField = "name";
            blackList.DataSource = reader;
            blackList.DataBind();

            colorList1.DataValueField = "name";
            colorList1.DataSource = reader;
            colorList1.DataBind();

            colorList2.DataValueField = "name";
            colorList2.DataSource = reader;
            colorList2.DataBind();

            colorList3.DataValueField = "name";
            colorList3.DataSource = reader;
            colorList3.DataBind();

            otherColor1.DataValueField = "name";
            otherColor1.DataSource = reader;
            otherColor1.DataBind();

            otherColor2.DataValueField = "name";
            otherColor2.DataSource = reader;
            otherColor2.DataBind();

            otherColor3.DataValueField = "name";
            otherColor3.DataSource = reader;
            otherColor3.DataBind();

            reader.Close();
        }
        catch (Exception err)
        {
            System.Diagnostics.Debug.WriteLine("Exception: " + err.Message);
        }
        finally
        {
            con.CloseSqlConnection();
        }
    }
</code></pre>
