Output HTML from number of strings
<p>I'm trying to figure out how best to organise an inline c# page that makes a number of DB connections and passes values to strings and need some advice.</p>

<p>So basically a CMS in use with my place of work only allows for inline code so I'm doing a course search page that hooks up to some stored procedures and passes the values to strings.</p>

<p>What would be the best way to handle three different stored procedure calls that output different bits of information to strings? In the old VB version I was passing info to strings then outputting them as one large string which probably isn't the best way to handle this.</p>

<p>The code currently goes in this rough format</p>

<pre><code>Stored Procedure 1
Pass x values to string
string = "&lt;p&gt; + xString +&lt;/p&gt;"

Stored Procedure 2
Pass y values to string
string = "&lt;p&gt; + yString +&lt;/p&gt;"
</code></pre>

<p>Is there a smarter way for me to close off sections as each procedure section usually has a table involved or appends to one larger table and I'm just trying to see what people would suggest would be best practice.</p>

<p>Please note I'm really not much of a programmer and just dipping my toes so apologies if this is a school boy mistake.</p>
