How to use data of a specific column from any row?
<p>I'm using VS 2010 C# ASP.NET 4 and SQL Server 2008 R2</p>

<p>On an aspx I read data from the database and present it as a grid view.
Both the gridview and the datasource are part of the aspx.</p>

<p>There is no problem with that.</p>

<p>Now, I wish to use the same datasorce, and present the data which resides in a specific column and one row (any row = the column has identical values on each row)</p>

<p>How do I do that?</p>

<p>I thought to use a repeater, and limit it's adavance, but I do not find a way to do that.</p>

<p>I wrote that:</p>

<pre><code>&lt;asp:Repeater ID="Repeater1" runat="server" DataSourceID="DataSource1"&gt;
    &lt;ItemTemplate&gt;
        &lt;%# Eval("Col").ToString() %&gt;
    &lt;/ItemTemplate&gt;
&lt;/asp:Repeater&gt;
</code></pre>

<p>How do I stop the repeater after one iteration?</p>

<p>Because I found no way of limiting / stopping the repeater, I get a row of the same number as a result.</p>

<p>How do I get only the first, last or any other value, but only one value from this clumn?</p>
