GridView的增删改查和分页排序

 个人笔记:

 

ExpandedBlockStart.gif 代码
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  GridView_Demo : System.Web.UI.Page
{
    
protected   void  Page_Load( object  sender, EventArgs e)
    {

        
if  ( ! IsPostBack)
        {
            ViewState[
" sort " =   " asc " ;

            Bind();
        }

     }
        
///   <summary>
        
///  绑定GridView控件
        
///   </summary>
         private   void  Bind()
        {
            SqlConnection conn 
=   new  SqlConnection( " Data Source=.;Initial Catalog=chapter5;Integrated Security=True " );
            conn.Open();
            SqlDataAdapter myda 
=   new  SqlDataAdapter( " select * from student " , conn);
            DataTable dt 
=   new  DataTable();
            myda.Fill(dt);

            GridView1.DataSource 
=  dt;
            GridView1.DataBind();
            conn.Close();
        }
    
private   void  Bind( string  sname)
    {
        SqlConnection conn 
=   new  SqlConnection( " Data Source=.;Initial Catalog=chapter5;Integrated Security=True " );
        conn.Open();
        
string  sql  =   string .Format( " select * from student order by {0} " ,sname);
        SqlDataAdapter myda 
=   new  SqlDataAdapter(sql, conn);
        DataTable dt 
=   new  DataTable();
        myda.Fill(dt);

        GridView1.DataSource 
=  dt;
        GridView1.DataBind();
        conn.Close();
    }
        
///   <summary>
        
///  实现分页 页面下面改变事件
        
///   </summary>
        
///   <param name="sender"></param>
        
///   <param name="e"></param>
         protected   void  GridView1_PageIndexChanging( object  sender, GridViewPageEventArgs e)
        {
            GridView1.PageIndex 
=  e.NewPageIndex;
            Bind();
        }
        
///   <summary>
        
///  编辑事件
        
///   </summary>
        
///   <param name="sender"></param>
        
///   <param name="e"></param>
         protected   void  GridView1_RowEditing( object  sender, GridViewEditEventArgs e)
        {
            GridView1.EditIndex 
=  e.NewEditIndex;
            Bind();
        }
        
///   <summary>
        
///  取消编辑事件
        
///   </summary>
        
///   <param name="sender"></param>
        
///   <param name="e"></param>
         protected   void  GridView1_RowCancelingEdit( object  sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex 
=   - 1 ;
            Bind();
        }
        
///   <summary>
        
///  更新事件
        
///   </summary>
        
///   <param name="sender"></param>
        
///   <param name="e"></param>
         protected   void  GridView1_RowUpdating( object  sender, GridViewUpdateEventArgs e)
        {
            
int  id  =   int .Parse(GridView1.Rows[e.RowIndex].Cells[ 0 ].Text);
            
string  name  =  ((TextBox)GridView1.Rows[e.RowIndex].Cells[ 1 ].Controls[ 0 ]).Text;
            
int  age  =   int .Parse(((TextBox)GridView1.Rows[e.RowIndex].Cells[ 2 ].Controls[ 0 ]).Text);
            
            SqlConnection conn 
=   new  SqlConnection( " Data Source=.;Initial Catalog=chapter5;Integrated Security=True " );
            conn.Open();
            
string  sql  =   string .Format( " update student set s_name = '{0}',s_age = {1} where s_id={2} " ,name,age,id);
            SqlCommand cmd 
=   new  SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            GridView1.EditIndex 
=   - 1 ;
            Bind();

           
//  Page.RegisterStartupScript("duihuakuang", "<script>alert('修改成功!')</script>");
        }
        
// 删除
         protected   void  GridView1_RowDeleting( object  sender, GridViewDeleteEventArgs e)
        {
            
int  id  =   int .Parse(GridView1.Rows[e.RowIndex].Cells[ 0 ].Text);
            SqlConnection conn 
=   new  SqlConnection( " Data Source=.;Initial Catalog=chapter5;Integrated Security=True " );
            conn.Open();
            
string  sql  =   string .Format( " delete student where s_id={0} " ,id);
            SqlCommand cmd 
=   new  SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            GridView1.EditIndex 
=   - 1 ;
            Bind();
        }

        
protected   void  GridView1_RowDataBound( object  sender, GridViewRowEventArgs e)
        {
            
if  (e.Row.RowType  ==  DataControlRowType.DataRow  &&  e.Row.RowState  !=  DataControlRowState.Edit)  // 判断行类型是否是数据行  行状态是否是处于编辑状态
            {

               
//  ((ImageButton)e.Row.Cells[4].FindControl("ImageButton1")).Attributes.Add("onclick", "return confirm('确定删除')");
                ((LinkButton)e.Row.Cells[ 5 ].Controls[ 0 ]).Attributes.Add( " onclick " " return confirm('确定删除') " );
                e.Row.Attributes.Add(
" onmouseover " " this.style.color='red' " );
                e.Row.Attributes.Add(
" onmouseout " " this.style.color='#000000' " );
            }
        }



    
protected   void  GridView1_Sorting( object  sender, GridViewSortEventArgs e)
    {
        
if  (ViewState[ " sort " ].ToString()  ==   " asc " )
        {
            ViewState[
" sort " ] =   " desc " ;
        }
        
else
        {
            ViewState[
" sort " =   " asc " ;
        }
        Bind(e.SortExpression);
    }
}

 

 

转载于:https://www.cnblogs.com/Simcoder/archive/2010/04/20/1715998.html

  • 0
    点赞
  • 0
    评论
  • 1
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
相关推荐
©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页