String Builder Class in asp.net
<p>SqlDataReader myreader;
                            myreader = cmmd.ExecuteReader();</p>

<pre><code>                        StringBuilder sb = new StringBuilder();
                        sb.Append("&lt;b&gt;Vaccine&lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;b&gt; Vaccination Date&lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;b&gt; Vaccination Due Date&lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;b&gt; Incomplete Vaccination &lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;b&gt;Dose No.&lt;/b&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;b&gt; Remarks &lt;/b&gt;&lt;br/&gt;&lt;br/&gt;");
                        while (myreader.Read())
                            {
                                    sb.Append(myreader["VaccineID"]);
                                    sb.Append("&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;");
                                    sb.Append(myreader["DateOFVaccine"]);
                                    sb.Append("&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;");
                                    sb.Append(myreader["NextVaccinationDueDate"]);
                                    sb.Append("&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;");
                                    sb.Append(myreader["AnyIncompleteImmunization"]);
                                    sb.Append("&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;");
                                    sb.Append(myreader["DoseNumber"]);
                                    sb.Append("&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;");
                                    sb.Append(myreader["Remark1"]);
                                    sb.Append("&lt;br/&gt;");
                            }
                        lblDisplayDetails.Text = sb.ToString();
                        myreader.Close();
</code></pre>

<p>WHAT EXACTLY I WANT IS TO RETRIEVE DATA(may be from separate table) AND THEN DISPLAY THEM PUTTING SOME STYLE(font,color etc).</p>

<p>Is retrieving from multiple table is possible in gridview ? I could use the DataReader, but how to display them in style(font,color etc) ?
Regards
Indranil</p>
