using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public void showCurrentRegionList() //函数名随便改,这里是showCurrentRegionList
{const string TBstart = "<table cellpadding=\"0\" cellspacing=\"0\" class=\"regionlisttable\">"; //【class=\"regionlisttable\"】:给table加上CssStyle,仅影响显示效果
const string TBend = "</table>";
const string TRsrart = "<tr>";
const string TRend = "</tr>";
const string TDstart = "<td class=\"CurrentRegionList\">"; //【class=\"CurrentRegionList\"】:给table的每个单元格加上CssStyle,仅影响显示效果
const string TDend = "</td>";
string sqlstr = "select * from regiontable order by region";
MyFunction MF = new MyFunction();
DataTable dt = new DataTable();
dt = MF.SelectDB(sqlstr);
Int16 i = 1;
String htmlstr = TBstart + TRsrart;
foreach (DataRow dr in dt.Rows) //这里是两个值合并占一个单元格,需一个值占一个单元格请改为用foreach遍历datatable中的的每个值而不是行
{if ((i % 5) != 1 || i == 1) //控制table一行有几个单元格,需要每行显示6个单元格需将【i%5】改为【i%6】,以此类推
{
htmlstr += TDstart + dr["region"].ToString() + " " + dr["itnumber"].ToString() + "u" + TDend;
}
else
{
htmlstr += TRend + TRsrart + TDstart + dr["region"].ToString() + " " + dr["itnumber"].ToString() + "u" + TDend;
}
i++;
}
htmlstr += TRend + TBend;
//到这里就拼完了,htmlstr就是你要的table标签html字符串
// this.currentRegionlistTD.InnerHtml = htmlstr;
//showM_regionlist(dt);
}