title: Ajax accordion, specific data from a dataset, multiple datasets or distinct data from a dataset possible?
body: <p>What i have accordion being loaded with an issue, I want distinct header information and multiple rows in the content.</p>
  
  <p>For example I have a DataTable with the following:</p>
  
  <pre><code>Fruit|Apples
  Fruit|Mango
  Vegetables|peas
  </code></pre>
  
  <p>I want it to result like this</p>
  
  <pre><code>Fruit
        -Apples
        -Mango
  Vegetables
        -peas
  </code></pre>
  
  <p>This is what I get right now.</p>
  
  <pre><code>Fruit
       - Apples
  Fruit
       - Mango
  Vegetables
       - peas
  </code></pre>
  
  <p>The code i'm using to databind is below:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      CurrentUserID = HttpContext.Current.Session["userID"].ToString();
      BindAccordion();
  
  }
  
  private void BindAccordion()
  {
      viewablePages = new List&lt;string&gt;();
      string storedProcedureName = "GrabAccordionPages";
  
      using (MySqlConnection cn = new MySqlConnection("Server="";Database=""; User=root;Password="";"))
      {
          List&lt;string&gt; roles = new List&lt;string&gt;();
          cn.Open();
          MySqlCommand cmd = new MySqlCommand(storedProcedureName, cn);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@usernameID", CurrentUserID);
          MySqlDataAdapter da = new MySqlDataAdapter(cmd);
          DataTable dtTable = new DataTable();
          da.Fill(dtTable);
          NavigateAccordion.DataSource = dtTable.DefaultView;
          NavigateAccordion.DataBind();
  
  
      }
  
  } 
  </code></pre>
  
  <p>My accordion looks like</p>
  
  <pre><code>&lt;ajaxToolKit:ToolkitScriptManager ID="ToolkitScriptManager1" runat="Server" /&gt;
  &lt;ajaxToolKit:Accordion ID="NavigateAccordion" runat="server" 
                         SelectedIndex="0" 
                         HeaderCssClass="accordionHeader" 
                         ContentCssClass="accordionContent" 
                         FadeTransitions="true" 
                         SuppressHeaderPostbacks = "true"
                         FramesPerSecond="80" 
                         TransitionDuration="200"
                         AutoSize="None"
                         Width="200"&gt;
  
  &lt;HeaderTemplate&gt;
    &lt;asp:Label runat="server" Id="lbHeaderId" Text='&lt;%#Eval("service") %'&gt;&gt; &lt;/asp:Label&gt;
  &lt;/HeaderTemplate&gt;
  </code></pre>
  
  <p>Is there a way to manipulate the <code>&lt;%#Eval("service") %'&gt;&gt;</code> or do I need to create something besides a DataTable to accomplish what I need.  Or can i bind two datasources to one accordion, but then how do i manage both sources in the content?</p>