title: VB.NET, Two SQL command, build a string
body: <p>Im coding a programm with VB.NET (2010), which works with a local database(.sdf - SQL Server CE).</p>
  
  <p>Now, I need to execute <strong>two SELECT</strong> command.
  Here an example to understand what I want:</p>
  
  <p><strong>SQL command example 1:</strong></p>
  
  <pre><code>SELECT A FROM tbl_Name
  </code></pre>
  
  <p>If I read this result with SqlCeDataReader, I will get following:</p>
  
  <blockquote>
    <p>James</p>
    
    <p>Tom</p>
    
    <p>Mike</p>
  </blockquote>
  
  <p><strong>SQL command example 2:</strong></p>
  
  <pre><code>SELECT B FROM tbl_Age
  </code></pre>
  
  <p>If I read this result with SqlCeDataReader, I will get following:</p>
  
  <blockquote>
    <p>14</p>
    
    <p>15</p>
    
    <p>16</p>
  </blockquote>
  
  <hr>
  
  <p>The problem is, how can I build a string which contains finally a value like this -> </p>
  
  <blockquote>
    <p>James;14</p>
    
    <p>Tom;15</p>
    
    <p>Mike;16</p>
  </blockquote>
  
  <p>How can I do that? I know that I have to use a StringBuilder and then AppendLine(), but the problem/question is more: How can I bring together the NAME and the AGE in one line?
  How can I solve this problem elegant?
  I hope you can help me. Thanks! BK_</p>
  
  <p><strong>Update:</strong></p>
  
  <p>No, they havent any relation. Im working with Sql Server CE. </p>
  
  <p>Otherwhise it would be very nice, if there is a table <strong>update</strong> possible. That means, if I can update these both tables to one table like:</p>
  
  <p>Tbl_personality
  Column Name and Column Age</p>
  
  <p>And than read it at once with SQL * FROM tbl_personality</p>