.Net中生成二维的表格的代码

找了很久才找到的在NET中生成二维表格的代码不敢独享现在就贴出来给大家看看相信对大家有所帮助

代码如下:

复制代码 代码如下:

void Page_Load(object o EventArgs e)
{
DataTable dt = GetData(); //assume GetData returns the DataTable
//probably better to use Hashtable for depts and months too but to keep the order lets use ArrayList
string sSeparator = ":";
ArrayList alDept = new ArrayList(); //种类
ArrayList alMonth = new ArrayList(); //代码
Hashtable ht = new Hashtable();
foreach (DataRow dr in dtRows)
{
string sDept = dr["c"]ToString();
string sMonth = dr["p"]ToString();
//将产地代码转换为产地名称
string sMonth = GetData(sMonth);
if (!alDeptContains(sDept))
alDeptAdd(sDept);
if (!alMonthContains(sMonth))
alMonthAdd(sMonth);
ht[sDept+ sSeparator + sMonth] = dr["a"];
}
TableRow tr = new TableRow();
TableCell tc = new TableCell();
//tcText = " ";
//trCellsAdd(tc);
foreach (string sDept in alDept)
{
int i=; //用于计算某一种类的数量
foreach (string sMonth in alMonth)
{
if(ht[sDept+ sSeparator + sMonth]==null)
{
i=i+;
}
else
{
i = i + intParse(ht[sDept+ sSeparator + sMonth]ToString());
}
}
tc = new TableCell();
tcText= sDept+"("+i+")";
trCellsAdd(tc);
}
/**//*foreach (string sDept in alDept)
{
tc = new TableCell();
tcText= sDept;
trCellsAdd(tc);
} */
TableRowsAdd(tr);
foreach (string sMonth in alMonth)
{
tr = new TableRow();
/**//*tc = new TableCell();
tcText = sMonth;
trCellsAdd(tc);*/
foreach (string sDept in alDept)
{
tc = new TableCell();
if(ht[sDept+ sSeparator + sMonth]==null)
{
tcText=sMonth+"()";
}
else
{
tcText = sMonth+"("+ ht[sDept+ sSeparator + sMonth]ToString()+")";
}
trCellsAdd(tc);
}
TableRowsAdd(tr);
}
}
Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASPNET Web 窗体设计器所必需的
//
InitializeComponent();
baseOnInit(e);
}
/**////
/// 设计器支持所需的方法 不要使用代码编辑器修改
/// 此方法的内容
///
private void InitializeComponent()
{
thisLoad += new SystemEventHandler(thisPage_Load);
}
#endregion
public DataTable GetData()
{
StatisticsB stat=new StatisticsB();
DataSet dataset=statbyStone();
return datasetTables["stat"];
}
//取得名称列表
public string GetData(string statid)
{
StatisticsB stat=new StatisticsB();
return statchangeToName(statid);
}