Repeater控件的应用

 

 

 

 

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;

 

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if(!IsPostBack)

        Bindfangfa();

    }

 

    private void Bindfangfa()

    {

        string str = ConfigurationManager.ConnectionStrings["strcnn"].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.DataBind();

            }

        }

    }

    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)

    {

        if (e.CommandName=="Delete")

        {

        string str=ConfigurationManager.ConnectionStrings["strcnn"].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();

                     }

        }

        Bindfangfa();

        }

        else

            if (e.CommandName=="Edit")

            {

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

            }

    }

}