Display dates not in database, only specific days of the week
<p>I have a sql database filled with specific dates for weekly training. We only have weekly training on Tuesdays and Wednesdays. It currently outputs like this:</p>

<pre><code>Training Schedule

Mar 4 - Training Title
Mar 5 - Training Title
Mar 12 - Training Title
Mar 19 - Training Title
</code></pre>

<p>Well now I am being asked to show dates that aren't in the database as well but only Tuesday's and Wednesdays. So basically it has to look like this now.</p>

<pre><code>Training Schedule

Mar 4 - Training Title
Mar 5 - Training Title
Mar 12 - Training Title
Mar 13 - No Training
Mar 19 - Training Title
Mar 20 - No Training
</code></pre>

<p>What is the best way to do this without going in and adding all the 'No Training' dates to the database (because that would take forever). Right now I'm simply just outputting the database results using the following code:</p>

<pre><code>var now = DateTime.Now;
var tableSql = "select * from Training where Date &gt;= " + "'" + now + "'" + " order by Date";
pcm.CommandText = tableSql;
prs = pcm.ExecuteReader();
var rowcount = 0;
while (prs.Read())
   {
     rowcount++;
          %&gt;
 &lt;%=Convert.ToDateTime(prs["Date"].ToString()).ToString("MMM d").ToUpper()%&gt; - &lt;%=prs["Title"].ToString().ToUpper() %&gt; &lt;% } %&gt;
        &lt;%
            prs.Close();
            pcn.Close();
        %&gt;
</code></pre>
