//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;
}
}