DataGrid的行的删除

protected void Page_Load(object sender, EventArgs e)
    {
        DataGridBind();
    }

    public void DataGridBind()
    {
        string sql;
        sql = "select A.ID, A.jobid ,A.Shendate,A.UserId,B.JobName,C.iname,C.Gender,C.iname,C.Diploma,C.school from Job_perapplyrec as A,job_zhaoping as B,job_person as C where A.JobId=B.[id] and A.UserID=C.[ID] ";

        DataGrid1.DataSource = DBQuery.OpenQuery(sql);
        DataGrid1.DataBind();
    }
    protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)   //在DataGrid的属性DataKeyField中输入ID
{
        int i = int.Parse(DataGrid1.DataKeys[e.Item.ItemIndex].ToString());  //获得DataGrid行中的id
        DBQuery.ExceuteNonQuery("delete from job_perapplyrec where id=" + i);
        DataGridBind();
    }