Repeater绑定数据库

时间:2023-03-09 15:51:41
Repeater绑定数据库

前台:

   <table width="" border="">
<tr>
<td class="tr1">
<asp:Label Text="姓名" runat="server"></asp:Label>
</td>
</tr>
</table> <asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<table border="" width="">
<tr>
<td class="tr1">
<%#Eval("E_Name")%>
</td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>

后台:

          protected void Page_Load(object sender, EventArgs e)
         {
        if(!IsPostBack)
        {
         string connString = "server=.;database=ComInfo;integrated security=true";//连接字符串
SqlConnection conn = new SqlConnection(connString);//创建连接
   String strsql = "select E_Name from Emp";//sql语句
   SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
   DataSet ds = new DataSet();
   da.Fill(ds);
   this.Repeater1.DataSource = ds;
   this.Repeater1.DataBind();//绑定
        }
      }