title: how to display data in HTML table in asp.net vb.net
body: <p>I have a table in database named <em>user</em>. The columns are <code>id, name, phone and address</code>. I put a <code>textbox</code> as a search box so when the user search using the search box, it will display list of users related. I want to retrieve the list of data in a <code>HTML table</code> because I want to add an <strong><em>edit</em></strong> button for each line retrieved. I tried this code but it has a problem with <code>ForEach</code> function. When I separate as <code>ForEach</code>, it says <em>For must end with Next</em>. </p>
  
  <pre><code>&lt;TABLE style="Z-INDEX: 113; POSITION: absolute; TOP: 368px; LEFT: 592px" id="Table1" border="1" cellSpacing="1" cellPadding="1" width="300"&gt;
  &lt;% for each(DataRow row in ds.Tables[0].Rows) { %&gt;
    &lt;TR&gt;
       &lt;td&gt;&lt;%= row["columnName"] %&gt;&lt;/td&gt;
     &lt;/TR&gt;&lt;% } %&gt;
  &lt;/TABLE&gt;
  </code></pre>
  
  <p>I already retrieved my data into <code>SQLDataAdapter</code> with this code:</p>
  
  <pre><code>Dim Adpt As New SqlDataAdapter(cm.CommandText, cnConnect)
  Dim ds As New DataSet
  </code></pre>