求一循环语句 使得 <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
我现在代码需要怎么改正
谢谢了
急！急！急！急！急！急！！！
------解决方案--------------------------------------------------------
aspx
<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);
}
------解决方案--------------------------------------------------------
HTML:
<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();
}
------解决方案--------------------------------------------------------
<asp:repeater ID= "rpt " runat = "server " >
<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();