title: load column data into checkboxlist
body: <p>i am trying to load r1,r2,r3 column to a checkboxlist, but the output is not my expected result</p>
  
  <p><strong>data inside my db</strong>   </p>
  
  <p>Question   r1  r2  r3</p>
  
  <p>who am i? A B C</p>
  
  <p><strong>output(item that inside my checkboxlist)</strong></p>
  
  <p>A</p>
  
  <p><strong>Expected output</strong></p>
  
  <p>A</p>
  
  <p>B</p>
  
  <p>C</p>
  
  <p>i was tried to add r1,r2,r3 into DataTextField but asp.net not allow me to do so=(</p>
  
  <p>
  
  <pre><code>        DataSourceID="SqlDataSource1" DataTextField="r1" DataValueField="r1"&gt;
  
      &lt;/asp:CheckBoxList&gt;
  
      &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
  
          ConnectionString="&lt;%$ ConnectionStrings:ConnectionString %&gt;" 
  
          SelectCommand="SELECT [r1], [r2], [r3] FROM [ExerciseTable] WHERE ([Question] = @Question)"&gt;
  
          &lt;SelectParameters&gt;
  
              &lt;asp:Parameter DefaultValue="who am i?" Name="Question" Type="String" /&gt;
  
          &lt;/SelectParameters&gt;
  </code></pre>