Eliminated duplicated data in repeater
<p>My output is not as I expected, what i want is eliminated duplicated data. i tried to use <code>group by</code> and <code>distinct</code> before but it doesn't work.=(</p>

<p><strong>data in my database</strong></p>

<pre><code>who are u?   A
who are u?   B
who are u?   C
who am i?    A
who am i?    B
who am i?    C
</code></pre>

<p><strong>current output</strong></p>

<blockquote>
  <p>Column 'ExerciseTable.r1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. </p>
</blockquote>

<p><strong>expected output</strong></p>

<pre><code>who are u? A
           B
           C

Who am i?  A
           B
           C
</code></pre>

<hr>

<pre><code>&lt;asp:SqlDataSource ID="SqlDataSource2" runat="server" 
 ConnectionString="&lt;%$ ConnectionStrings:ConnectionString %&gt;" 
 SelectCommand="SELECT [Question],[r1] FROM [ExerciseTable] GROUP BY [Question]"&gt;

&lt;/asp:SqlDataSource&gt;
</code></pre>
