利用GridView完成增删改及排序（不用数据源）

 

 

如图为GridView:

 

 

字段设置：

后台代码：

protected void Page_Load(object sender, EventArgs e) { UpdateDataSource(); }　 /// <summary> /// 更新数据 /// </summary> private void UpdateDataSource() { GridView1.DataSource = UserStateMamager.GetAllStates(); this.GridView1.DataBind(); } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { //页索引改变时发生 this.GridView1.PageIndex = e.NewPageIndex; UpdateDataSource(); } protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { //选择前激发．．． } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { //删除前激发．．． int id =Convert .ToInt32 ( GridView1.DataKeys[e.RowIndex].Value.ToString()); UserStateMamager.DeleteUserStateById(id); UpdateDataSource(); } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { //编辑时激发．．． GridView1.EditIndex = e.NewEditIndex; UpdateDataSource(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //执行update前激发．．． int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);//获取原值 string stateName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;//获取更新后的值 //封装修改时需要的参数 UserState userstate = new UserState(); userstate.Id = id; userstate.StateName = stateName; UserStateMamager.ModifyUserState(userstate); GridView1.EditIndex = -1;//取消编辑 UpdateDataSource(); //更新数据 } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { //在编辑状态下，点取消按钮时发生.... GridView1.EditIndex = -1; UpdateDataSource(); //更新数据 } protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) { //创建表的视图 DataView sortedDV = new DataView(UserStateMamager.GetAllUserStateTable()); sortedDV.Sort = "id" + " " + "desc";//设置视图按什么排序 GridView1.DataSource = sortedDV;//绑定设置好的视图 GridView1.DataBind(); }