How to improve the rendering of a custom 'data calendar' in asp.net
<p>I've been asked to improve a ASP.Net C# page. It currently shows a years worth of daily prices for a product. The page looks similar to a wall planner, with each input control showing a price for that day. </p>

<p>The page will be used to change the price of this product for that year. Currently the 'wall planner' table control is being generated cell-by-cell in the code behind. </p>

<p>There is a lot of code used to implement this but essentially it does the following.</p>

<p><strong>A table is built... dynamically</strong></p>

<ol>
<li>New Table control defined</li>
<li>12 new TableRow controls defined (months)</li>
<li>Each row has 31 TableCell controls added to it (Each with a unique id e.g. cell_yy_mm_dd)</li>
</ol>

<p><strong>Its filled with data</strong></p>

<ol>
<li>365 days of prices are retrieved from the database (Price and Date).</li>
<li>Foreach used to loop over the dataset</li>
<li>Date checked with the TableCells id. If there is a match, a new TextBox is added to the cell.</li>
</ol>

<p>This is causing a huge strain on the server (specifically memory usage). It seems so over engineered there must be a better way of doing it!</p>

<p>What would be a better method to implement such functionality?</p>
