给你写了一个,你参考一下:
在.aspx中:
<asp:repeater id="repeater1" runat="server">
<ItemTemplate>
·<a href='<%# DataBinder.Eval(Container.DataItem,"hyperAddress") %>' target="_blank"><%# DataBinder.Eval(Container.DataItem,"document") %></a><br>
</ItemTemplate>
</asp:repeater>在.aspx.cs中(以SQL SERVER为例):
using System.Data.SqlClient;
protected System.Data.SqlClient.SqlConnection cn;
protected System.Data.SqlClient.SqlCommand cm;
protected System.Data.SqlClient.SqlDataReader dr;
private void Page_Load(object sender, System.EventArgs e)
{
//下面的连接字符串要修改成你的
cn=new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=myDataBase");
string strSQL="select * from QmsDocument";
cm=new SqlCommand(strSQL,cn);
cn.Open();
dr=cm.ExecuteReader();
repeater1.DataSource=dr;
repeater1.DataBind();
cn.Close();
}
在.aspx中:
<asp:repeater id="repeater1" runat="server">
<ItemTemplate>
·<a href='<%# DataBinder.Eval(Container.DataItem,"hyperAddress") %>' target="_blank"><%# DataBinder.Eval(Container.DataItem,"document") %></a><br>
</ItemTemplate>
</asp:repeater>在.aspx.cs中(以SQL SERVER为例):
using System.Data.SqlClient;
protected System.Data.SqlClient.SqlConnection cn;
protected System.Data.SqlClient.SqlCommand cm;
protected System.Data.SqlClient.SqlDataReader dr;
private void Page_Load(object sender, System.EventArgs e)
{
//下面的连接字符串要修改成你的
cn=new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=myDataBase");
string strSQL="select * from QmsDocument";
cm=new SqlCommand(strSQL,cn);
cn.Open();
dr=cm.ExecuteReader();
repeater1.DataSource=dr;
repeater1.DataBind();
cn.Close();
}
<HeaderTemplate>
<table align="center" width="90%" border="0" cellpadding="0" cellspacing="0">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<a href='<%# DataBinder.Eval(Container.DataItem,"hyperAddress") %>'><%# DataBinder.Eval(Container.DataItem,"document") %></a>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
{
SqlConnection cn=new SqlConnection(msConnStr);
SqlCommand cmd=new SqlCommand(); cn.Open(); cmd.Connection=cn; SqlDataReader dr;
string strSQL="select * from QmsDocument";
cmd.CommandText=strSQL;
dr=cmd.ExecuteReader();
Repeater1.DataSource=dr;
Repeater1.DataBind(); dr.Close();
cn.Close();
}
1、绑定数据:
private void myDataBind()
{
SqlConnection cn=new SqlConnection(msConnStr);
SqlDataAdapter da=SqlDataAdapter(SQLTEXT,cn);
cn.Open();
DataSet ds=new DataSet();
da.Fill(ds,"table1");
dr=cmd.ExecuteReader();
DataGrid1.DataSource=ds.tables[0];
DataGrid1.DataBind();
cn.Close();
}
2、绑定模板hyperAddress
<ItemTemplate>
<a href='<%# DataBinder.Eval(Container.DataItem,"hyperAddress") %>'
target="_blank"><%# DataBinder.Eval(Container.DataItem,"document") %
></a><br>
</ItemTemplate>