aspx repeater 用法_ASP.NET中repeater控件用法实例

本文实例讲述了ASP.NET中repeater控件用法。分享给大家供大家参考。具体实现方法如下：

repeater绑定数据：

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();

}

}

}

删除数据：

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)

{

if (e.CommandName == "Delete")

{

string str = ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString;

using (SqlConnection sqlCnn = new SqlConnection(str))

{

using (SqlCommand sqlCmm = sqlCnn.CreateCommand())

{

sqlCnn.Open();

sqlCmm.CommandText = "delete from student where sid="

+ e.CommandArgument.ToString();

sqlCmm.ExecuteNonQuery();

}

}

this.BindStudent();

}

else if (e.CommandName == "Edit")

{

Server.Transfer("Edit.aspx?sid=" + e.CommandArgument.ToString());

}

}

前台：

---

---

--%>

onitemcommand="Repeater1_ItemCommand">

编号	姓名	图片

启用，禁用：

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();

}

}

onitemcommand="Repeater1_ItemCommand">

编号	姓名	状态

希望本文所述对大家的asp.net程序设计有所帮助。