asp:Repeater绑定数据源

ASP.NET Repeater控件数据绑定

最新推荐文章于 2021-08-05 14:32:21 发布

最新推荐文章于 2021-08-05 14:32:21 发布 · 386 阅读

文章标签：

#xhtml #ui #c#

本文介绍如何使用ASP.NET中的Repeater控件来显示数据库中的信息，并通过C#实现数据绑定。文章展示了完整的HTML及C#代码，包括设置表格布局、自定义数据显示如性别转换等细节。

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="showRepeater.aspx.cs" Inherits="bindData.connection.showRepeater" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>repeater显示信息</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Repeater ID="repeater_info" runat="server"> <HeaderTemplate> <table style="text-align: center"> <tr> <td nowrap> 名字 </td> <td nowrap> 性别 </td> <td nowrap> 年龄 </td> <td nowrap> 生辰 </td> <td nowrap> 说明 </td> <td nowrap> 邮箱 </td> <td nowrap> 电话 </td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td> <asp:HiddenField ID="HiddenField1" Value='<%# Eval("id")%>' runat="server" /> <%# Eval("names")%> </td> <td nowrap> <%# showSex(Eval("sex").ToString())%> </td> <td nowrap> <%# Eval("age")%> </td> <td nowrap> <%# Eval("birthday")%> </td> <td nowrap> <%# Eval("explain")%> </td> <td nowrap> <%# Eval("email")%> </td> <td nowrap> <%# Eval("telephone")%> </td> </tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; namespace bindData.connection { public partial class showRepeater : System.Web.UI.Page { /// <summary> /// 连接字符 /// </summary> string connStr = ConfigurationManager.ConnectionStrings["pubs"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bindData(); } } /// <summary> /// 绑定数据源 /// </summary> private void bindData() { string sql = "select * from company"; SqlConnection sqlConnection = new SqlConnection(connStr); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, connStr); DataSet ds = new DataSet(); sqlDataAdapter.Fill(ds, "company"); DataView dv = ds.Tables["company"].DefaultView; repeater_info.DataSource = dv; repeater_info.DataBind(); } /// <summary> /// 显示性别：0=女 1=男 /// </summary> /// <param name="sex"></param> /// <returns></returns> protected string showSex(string sex) { string sexStr = string.Empty; if (!string.IsNullOrEmpty(sex.ToString())) { if (sex == "0") { sexStr = "女"; } else { sexStr = "男"; } } return sexStr; } } }