cell.Controls.Add(new LiteralControl(ds.Tables[0].Rows[j][i].ToString()));
改为
for(int k=0; k<3; k++)
{
cell.Controls.Add(new LiteralControl(ds.Tables[0].Rows[i][k].ToString()));}
可以试一下
改为
for(int k=0; k<3; k++)
{
cell.Controls.Add(new LiteralControl(ds.Tables[0].Rows[i][k].ToString()));}
可以试一下
{
string str = string.Format("select * from yh");
DataSet ds = DBAccess.ExecuteDataset(str);
int row_count = 0;
TableRow row = new TableRow();
row_count++;
TableCell cell = new TableCell();
cell.Controls.Add(new LiteralControl(("用户名")));
cell.Controls.Add(new LiteralControl(("密码")));
cell.Controls.Add(new LiteralControl(("确认密码")));
cell.Controls.Add(new LiteralControl(("电子邮件")));
for (int j = 1; j < ds.Tables[0].Rows.Count; j++)
{ TableRow row = new TableRow();
row_count++; for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
cell.Controls.Add(new LiteralControl(ds.Tables[0].Rows[j][i].ToString()));
row.Cells.Add(cell);
row.Attributes["onMouseOver"] = "this.bgColor='#ccffff'";
row.Attributes["onMouseOut"] = "this.bgColor='#ffffff'";
}
Table1.Rows.Add(row);
}
}
TableCell cell1 = new TableCell();
TableCell cell12 = new TableCell();
TableCell cell13 = new TableCell();
TableCell cell14 = new TableCell();
cell1.Controls.Add(new LiteralControl("用户名");
cell2.Controls.Add(new LiteralControl("密码");
cell3.Controls.Add(new LiteralControl("确认密码");
cell4.Controls.Add(new LiteralControl("电子邮件");
row.Cells.Add(cell1);
row.Cells.Add(cell2);
row.Cells.Add(cell3);
row.Cells.Add(cell4);
然后再写两个for结构。
这话是什么意思 特别是1=1 这是什么意思啊
加了where 1=1,后边就直接
strCondition= " and "+条件
就行了,不用判断是不是第一行