日期:2014-05-18  浏览次数:20454 次

DataTable循环一行两列
想在前台页面循环DataTable输出数据,布局是多行两列的,请问怎么循环?

------解决方案--------------------
用datalist repeatcoluns = "2 "
------解决方案--------------------
StringBuilder sBuilder=new StringBuilder();
sBuilder.Append( " <table> ");
for(int i=0;i <=Table.Rows.Count;i++)
{
Response.Write ( " <tr> ");
for(int j=0;j <Table.Cloumuns.Count;j++)
{
sBuilder.Append( " <td> ");
sBuilder.Append(Table.Rows[i][j].ToStrings());
sBuilder.Append( " </td> ");
}
sBuilder.Append( " </tr> ");
}
sBuilder.Append( " </table> ");
Response.Write(sBuilder.ToString(););
------解决方案--------------------
最方便的还是for each

Dim dt as DataTable
dt=.... '这里为DataTable添入数据。
'循环读取数据
Dim dr as DataRow
For each dr in dt
something1=dr( "列1 ").ToString()
something2=dr( "列2 ").ToString()
...
End For

如果不满足,还可以嵌套循环。