GridView使用总结

1、GridView无代码分页排序：

(1).AllowSorting设为True，aspx代码中是AllowSorting="True"；
(2).默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。
(3).默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

 

2.GridView选中，编辑，取消，删除：

前台代码：

<asp:GridView ID="GridView1" runat="server" Height="133px" Width="539px" AutoGenerateColumns="False" DataKeyNames="id"

OnRowEditing="GridView1_RowEditing" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3"

CellSpacing="1" GridLines="None" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"
 
OnRowDataBound="GridView1_RowDataBound"  OnRowDeleting="GridView1_RowDeleting" > 
        <Columns> 
            <asp:BoundField DataField="name" HeaderText="姓名" /> 
            <asp:BoundField DataField="id" HeaderText="编号" DataFormatString="{0:000#}" ReadOnly="True" /> 
            <asp:BoundField DataField="score" HeaderText="分数" /> 
            <asp:CheckBoxField DataField="member" HeaderText="是否会员" ReadOnly="True" /> 
            <asp:CommandField HeaderText="编辑" ShowEditButton="True" /> 
            <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> 
            <asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
        </Columns> 
        <RowStyle BackColor="#DEDFDE" ForeColor="Black" /> 
        <FooterStyle BackColor="#C6C3C6" ForeColor="Black" /> 
        <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" /> 
        <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" /> 
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" /> 
    </asp:GridView>


 
后台代码：
using System; 
using System.Data; 
using System.Configuration; 
using System.Collections; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Web.UI.HtmlControls; 
using System.Data.SqlClient; 
  
public partial class capital2_IDU : System.Web.UI.Page 
{ 
    protected void Page_Load(object sender, EventArgs e) 
    { 
        if (!Page.IsPostBack) 
        { 
            DataBindings(); 
        } 
    }

//数据绑定 
 public void DataBindings() 
 { 
     this.GridView1.DataSource = GetStudentInfo(); 
     this.GridView1.DataBind(); 
 } 
 public DataSet GetStudentInfo() 
 { 
     DataSet dt = null; 
     using (SqlConnection sqlcon = new SqlConnection(DBHelper.con)) 
     { 
         dt=DBHelper.GetStudentInfo(sqlcon, "select * from student"); 
         sqlcon.Close(); 
     } 
     return dt; 
 }

//编辑 
 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) 
 { 
     GridView1.EditIndex = e.NewEditIndex; 
     DataBindings(); 
 }

//更新 
 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) 
 { 
     //GridViewRow row = GridView1.Rows[e.RowIndex]; 
     //int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); 
     //string userName = ((TextBox)row.FindControl("UserName")).Text.ToString(); 
     //double Money = Convert.ToDouble(((TextBox)row.FindControl("Money")).Text.ToString()); 
     GridViewRow row = GridView1.Rows[e.RowIndex]; 
     //int ID=row.Cells[1].Text 
     int ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); 
     string name = ((TextBox)(row.Cells[0].Controls[0])).Text; 
     string score = ((TextBox)(row.Cells[2].Controls[0])).Text.Trim(); 
     using (SqlConnection sqlcon = new SqlConnection(DBHelper.con)) 
     { 
         SqlDataReader dr; 
         string sql = "Update student Set name='" + name + "',score='" + score + "' Where ID=" + ID + ""; 
         SqlCommand myCommand = new SqlCommand(sql, sqlcon); 
         sqlcon.Open(); 
         dr = myCommand.ExecuteReader(); 
         //获取或设置要编辑的行的索引。默认值为 -1，指示没有正在编辑的行 .取消编辑状态。  
         //将gridview从编辑模式切换成浏览模式 
 
         GridView1.EditIndex = -1; 
         sqlcon.Close(); 
     } 
     DataBindings(); 
 }

//删除 
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) 
    { 
        GridViewRow row = GridView1.Rows[e.RowIndex]; 
        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString().Trim(); 
        using (SqlConnection sqlcon = new SqlConnection(DBHelper.con)) 
        { 
            SqlDataReader dr; 
            string sql = "delete from student where  ID=" + ID; 
            SqlCommand myCommand = new SqlCommand(sql, sqlcon); 
            sqlcon.Open(); 
            dr = myCommand.ExecuteReader(); 
            sqlcon.Close(); 
        } 
        Response.Write("<script type='text/javascript'>window.alert('删除成功')</script>"); 
        DataBindings(); 
    }

//取消编辑 
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 
    { 
        this.GridView1.EditIndex = -1; 
        DataBindings(); 
    }

//取消编辑 
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 
    { 
        this.GridView1.EditIndex = -1; 
        DataBindings(); 
    }