Hi Debug,
I have created a sample please take its refrence.
HTML
C#
<table>
<tr>
<%foreach (System.Data.DataColumn dc in this.ds.Tables[0].Columns)
{%>
<th>
<%=dc.ColumnName %>
</th>
<%} %>
</tr>
<%foreach (System.Data.DataRow dr in this.ds.Tables[0].Rows)
{%>
<tr>
<%foreach (System.Data.DataColumn dc in this.ds.Tables[0].Columns)
{%>
<td>
<%=dr[dc.ColumnName]%>
</td>
<%} %>
</tr>
<%} %>
</table>
VB.Net
<table>
<tr>
<%For Each dc As Data.DataColumn In Me.ds.Tables(0).Columns
%>
<th>
<%=dc.ColumnName %>
</th>
<% Next%>
</tr>
<%For Each dr As Data.DataRow In Me.ds.Tables(0).Rows
%>
<tr>
<%For Each dc As Data.DataColumn In Me.ds.Tables(0).Columns
%>
<td>
<%=dr(dc.ColumnName)%>
</td>
<% Next%>
</tr>
<% Next%>
</table>
Namespaces
C#
using System;
using System.Data;
VB.Net
Imports System
Imports System.Data
Code
C#
protected DataSet ds { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("Country",typeof(string)) });
dt.Rows.Add(1, "John Hammond", "United States");
dt.Rows.Add(2, "Mudassar Khan", "India");
dt.Rows.Add(3, "Suzanne Mathews", "France");
dt.Rows.Add(4, "Robert Schidner", "Russia");
ds = new DataSet();
ds.Tables.Add(dt);
}
VB.Net
Protected Property ds As DataSet
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
Dim dt As DataTable = New DataTable()
dt.Columns.AddRange(New DataColumn(2) {
New DataColumn("Id", GetType(Integer)),
New DataColumn("Name", GetType(String)),
New DataColumn("Country", GetType(String))})
dt.Rows.Add(1, "John Hammond", "United States")
dt.Rows.Add(2, "Mudassar Khan", "India")
dt.Rows.Add(3, "Suzanne Mathews", "France")
dt.Rows.Add(4, "Robert Schidner", "Russia")
ds = New DataSet()
ds.Tables.Add(dt)
End Sub
Output
Id | Name | Country |
1 |
John Hammond |
United States |
2 |
Mudassar Khan |
India |
3 |
Suzanne Mathews |
France |
4 |
Robert Schidner |
Russia |