如何往动态生成的table里添加数据集
//读取数据库确定有几条记录
string connstr=System.Configuration.ConfigurationSettings.AppSettings["sqllink"];
SqlConnection conn1=new SqlConnection(connstr);
conn1.Open();
string sql1="SELECT count(*) as icount FROM CPZone WHER ACTID =000002";
SqlCommand comm=new SqlCommand(sql1,conn1);
SqlDataReader dr1=comm.ExecuteReader();
dr1.Read();
int count=System.Convert.ToInt32(dr1["icount"].ToString());
dr1.Close();
HtmlTable table1 = new HtmlTable();
table1.Border = 1;
for(int i=0; i<=count; i++)//行
{
HtmlTableRow row = new HtmlTableRow();//创建行
for(int j=1; j<=6; j++)//列
{
//HtmlTableCell cell = new HtmlTableCell();
HtmlTableCell cell;//创建列
if(i <= 0)
{
cell = new HtmlTableCell("th");
}
else
{
cell = new HtmlTableCell();
}
cell.Controls.Add(new LiteralControl("显示的内容");
row.Cells.Add(cell);
}
table1.Rows.Add(row);
}
PlaceHolder1.Controls.Clear();
PlaceHolder1.Controls.Add(table1);
//////////////////////////////////////////////////////
如何添加数据集到动态生成的table里/
string sql2="SELECT ZoneID, AtPos,SnType, SnNum, AlmType,Inst_Date FROM CPZone WHERE ACTID =000002";