protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
BindStudent();
}
private void BindStudent()
{
string str = ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString;
using (SqlConnection sqlCnn = new SqlConnection(str))
{
using (SqlDataAdapter da = new SqlDataAdapter("select * from student", sqlCnn))
{
DataSet ds = new DataSet();
da.Fill(ds);
this.Repeater1.DataSource = ds;
this.Repeater1.DataBind();
}
}
}
%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
!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>/title>
/head>
body>
form id="form1" runat="server">
%--asp:Repeater ID="Repeater1" runat="server">
HeaderTemplate>
hr />
/HeaderTemplate>
ItemTemplate>div>
asp:Label ID="lblSid" runat="server" Text='%# Eval("sid") %>'>/asp:Label>
asp:Label ID="lblSname" runat='server' Text='%# Eval("sname") %>'>/asp:Label>
asp:Image ID="imgPhoto" runat="server" ImageUrl='%# Eval("photo") %>' />/div>
/ItemTemplate>
SeparatorTemplate>
hr />
/SeparatorTemplate>
AlternatingItemTemplate>
div style="
asp:Label ID="lblSid" runat="server" Text='%# Eval("sid") %>'>/asp:Label>
asp:Label ID="lblSname" runat='server' Text='%# Eval("sname") %>'>/asp:Label>
asp:Image ID="imgPhoto" runat="server" ImageUrl='%# Eval("photo") %>' />/div>
/AlternatingItemTemplate>
FooterTemplate>hr />/FooterTemplate>
/asp:Repeater>--%>
div>
asp:Repeater ID="Repeater1" runat="server"
onitemcommand="Repeater1_ItemCommand">
HeaderTemplate>table>
tr>td style="width:100px">編號(hào)/td>td style="width:100px">姓名/td>
td style="width:100px">圖片/td>td>nbsp;/td>td>nbsp;/td>/tr>
/HeaderTemplate>
ItemTemplate>
tr>
td>%# Eval("sid") %>/td>td>%# Eval("sname") %>/td>
td>img width="60px" height="60px" src='%# "images/" + Eval("photo") %>' />/td>
td>asp:LinkButton ID="btnDelete" runat="server" Text="刪除" CommandName='Delete' CommandArgument='%# Eval("sid") %>'>/asp:LinkButton>/td>
td>asp:LinkButton ID="btnEdit" runat="server" Text="編輯" CommandName='Edit' CommandArgument='%# Eval("sid") %>'>/asp:LinkButton>/td>
/tr>
/ItemTemplate>
AlternatingItemTemplate>
tr style="
td>%# Eval("sid") %>/td>td>%# Eval("sname") %>/td>
td>img width="60px" height="60px" src='%# "images/" + Eval("photo") %>' />/td>
td>asp:LinkButton ID="btnDelete" runat="server" Text="刪除" CommandName='Delete' CommandArgument='%# Eval("sid") %>'>/asp:LinkButton>/td>
td>asp:LinkButton ID="btnEdit" runat="server" Text="編輯" CommandName='Edit' CommandArgument='%# Eval("sid") %>'>/asp:LinkButton>/td>
/tr>
/AlternatingItemTemplate>
SeparatorTemplate>
tr>td colspan="5">hr />/td>/tr>
/SeparatorTemplate>
FooterTemplate>/table>/FooterTemplate>
/asp:Repeater>
/div>
/form>
/body>
/html>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//string status = e.CommandName;
if ((e.CommandName == "true")||(e.CommandName == "false"))
{
string str = ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString;
using (SqlConnection sqlCnn = new SqlConnection(str))
{
using (SqlCommand sqlCmm = sqlCnn.CreateCommand())
{
sqlCnn.Open();
sqlCmm.CommandText = "update student set status=@status where sid="
+ e.CommandArgument.ToString();
sqlCmm.Parameters.AddWithValue("@status",e.CommandName);
sqlCmm.ExecuteNonQuery();
}
}
this.BindStudent();
}
}
%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Debug="true" Inherits="Default2" %>
!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>/title>
/head>
body>
form id="form1" runat="server">
div>
asp:Repeater ID="Repeater1" runat="server"
onitemcommand="Repeater1_ItemCommand">
HeaderTemplate>table>tr>th>編號(hào)/th>th>姓名/th>th>狀態(tài)/th>th>nbsp;/th>/tr>/HeaderTemplate>
ItemTemplate>
tr>td>%# Eval("SID") %>/td>
td>%# Eval("sname") %>/td>
td>%# Convert.ToBoolean(Eval("status"))?"啟用":"禁用" %>/td>
td>asp:LinkButton ID="btnSetStatus" runat="server" CommandArgument='Eval("sid")' Text='%# Convert.ToBoolean(Eval("status"))?"禁用":"啟用" %>' CommandName='%# Convert.ToBoolean(Eval("status"))?"false":"true" %>'>/asp:LinkButton>/td>/tr>
/ItemTemplate>
FooterTemplate>/table>/FooterTemplate>
/asp:Repeater>
/div>
/form>
/body>
/html>