Different content in Footer from the ItemTemplate result
<p>Can the DataList <code>FooterTemplate</code> have an altogether different query result in contrast to what we are using in ItemTemplate results, on data binding?</p>

<p>For eg:</p>

<pre><code>&lt;ItemTemplate&gt;
&lt;tr&gt;
&lt;td&gt;BookID: &lt;/td&gt;
&lt;td&gt;&lt;%#Eval("bookid")%&lt;/td&gt;
&lt;/tr&gt;
&lt;/ItemTemplate&gt;
&lt;FooterTemplate&gt;
&lt;tr&gt;
&lt;td&gt;Last purchase: &lt;/td&gt;
&lt;td&gt;&lt;%#Eval("")% //don't have a the result in the ItemTemplate queried DataSource result. Need to do a separate query for this and enter the columnID here&lt;/td&gt;
&lt;/tr&gt;
&lt;/FooterTemplate&gt;
</code></pre>

<p>I need run a different query to get the result in footer. For this, the the same result should also be in the DataSource for the DataList, so that I can specify it using an ID.</p>

<p>Any suggestions for this or should I use an altogether different control?</p>
