using ItemCommand

来源:互联网 发布:yy网络主播赵哈哈 编辑:程序博客网 时间:2024/04/30 05:49

//first add following  delegate in the  private void InitializeComponent()

this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);

public void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {   
   
   switch(((LinkButton)e.CommandSource).CommandName)
   {

    case "Delete":
     try
     {
      string str = e.Item.Cells[0].Text.Trim();//get the pk of  the current row
      string strSql1="select ....";
      if(int.Parse(mySQL.ExecuteScalar(strSql1).ToString())>=1)
      {
       Response.Write("<script language=javascript>alert('exist somebody in this department!');</script>");
       return;
      }
      else
      {
       string strSql = "delete...'";
       mySQL.ExecuteNonQuery(strSql);
       this.DataGrid1.CurrentPageIndex=0;
       this.Bind_Dg();
      }
     }
     catch
     {return;}
     Response.Write("<script language=javascript>alert('Already delete it!');</script>");
     break;

     // Add other cases here, if there are multiple ButtonColumns in
     // the DataGrid control.
    case "Edit":
     try
     {
    
      this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
      this.Bind_Dg();
     }
     catch
     {}
     break;
    default:
     // Do nothing.
     break;

   }  
  }

原创粉丝点击