求一循环语句 使得<a>标签能显示出SQL中一列的所有数据
现在<a>标签只能显示一条纪录
如何能让<a>标签显示出SQL中一列的所有纪录呢
求助高手
.aspx
<a href="#"><%=str%></a>.cs
public partial class ASP_Code_Question : System.Web.UI.Page
{
public void Page_Load(object sender, EventArgs e)
{
string strSQL = "SELECT [userID]FROM User";
DataSet ds = SqlHelper.ExecuteAdapter(SqlHelper.ConnM2D, CommandType.Text, strSQL, null);
str=ds.Tables[0].DefaultView[0].Row["userID"].ToString();
}
public String str;
}
高手请看看怎么写这条循环语句 能让<a>标签显示出所有的UserID
我现在代码需要怎么改正 谢谢了
急!急!急!急!急!急!!!
现在<a>标签只能显示一条纪录
如何能让<a>标签显示出SQL中一列的所有纪录呢
求助高手
.aspx
<a href="#"><%=str%></a>.cs
public partial class ASP_Code_Question : System.Web.UI.Page
{
public void Page_Load(object sender, EventArgs e)
{
string strSQL = "SELECT [userID]FROM User";
DataSet ds = SqlHelper.ExecuteAdapter(SqlHelper.ConnM2D, CommandType.Text, strSQL, null);
str=ds.Tables[0].DefaultView[0].Row["userID"].ToString();
}
public String str;
}
高手请看看怎么写这条循环语句 能让<a>标签显示出所有的UserID
我现在代码需要怎么改正 谢谢了
急!急!急!急!急!急!!!
{
str += row["userID"].ToString();
}
<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>cs
foreach(DataRow row in ds.Tables[0].Rows)
{
string str = row["userID"].ToString();
HtmlAnchor ha = new HtmlAnchor();
ha.HRef = "#";
ha.InnerText = str;
PlaceHolder1.Controls.Add(ha);
}
<table>
<tbody id="aa" runat=server>
<tr></tr>
</tbody>
</table>后台:
for()
StringBuilder stringbuilder = new StringBuilder ("");
foreach(DataRow row in ds.Tables[0].Rows)
{ stringbuilder .Append("<tr>");
stringbuilder .AppendFormat("<td><a href="连接页面">{0}</a></td>",row ["userID"].ToString());
stringbuilder .Append("</tr>");
aa.innerhtml=stringbuilder .ToString();
}
<table>
<tbody id="aa" runat=server>
<tr></tr>
</tbody>
</table>后台:
StringBuilder stringbuilder = new StringBuilder ("");
foreach(DataRow row in ds.Tables[0].Rows)
{ stringbuilder .Append("<tr>");
stringbuilder .AppendFormat("<td><a href="连接页面">{0}</a></td>",row ["userID"].ToString());
stringbuilder .Append("</tr>");
aa.innerhtml=stringbuilder .ToString();
}
<ItemTemplate ><li/><a href="#"><%#DataBinder.Eval(Container.DataItem,"f") %></a></ItemTemplate>
</asp:repeater>DataTable dt = new DataTable();
dt.Columns .Add ( new DataColumn ("f", typeof( String )));
DataRow row = dt.NewRow();
row["f"] = "xiao";
dt.Rows.Add(row);
row = dt.NewRow();
row["f"] = "aa";
dt.Rows.Add(row); this.rpt.DataSource = dt;
this.rpt.DataBind();