asp.net之DataList的使用方法，及分页（存储过程创建），编辑，更新，删除

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Configuration;

using System.Data.SqlClient;

using System.Data;

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

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if(!IsPostBack)

            BindProduct("1");

    }

    private void BindProduct(string pageindex)

    {

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

        using (SqlConnection sqlCnn = new SqlConnection(str))

        {

            SqlDataAdapter da = new SqlDataAdapter("sp_Student_Select_by_Page_rowNumber", sqlCnn);

            da.SelectCommand.Parameters.AddWithValue("@pageIndex", pageindex);

            da.SelectCommand.Parameters.Add("@pageCount", SqlDbType.Int).Direction = ParameterDirection.Output;

            da.SelectCommand.Parameters.AddWithValue("@pageSize", 2);

            da.SelectCommand.CommandType = CommandType.StoredProcedure;

            DataSet ds = new DataSet();

            da.Fill(ds);

            this.DataList1.DataSource = ds.Tables[0].DefaultView;

            this.DataList1.DataBind();

            this.HiddenField1.Value = pageindex;

            this.HiddenField2.Value = da.SelectCommand.Parameters["@pageCount"].Value.ToString();

        }

    }     //绑定数据 www.2cto.com

    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)

    {

        if(e.CommandName == "buy")

            Response.Write(e.CommandArgument.ToString());

    }

    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)

    {

        this.DataList1.EditItemIndex = e.Item.ItemIndex;

        this.BindProduct(this.HiddenField1.Value);

    }         //编辑

    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)

    {

        this.DataList1.EditItemIndex = -1;

        this.BindProduct(this.HiddenField1.Value);

    }           //取消

    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)

    {