protected void DeleteRecordByID(int pj_id) { projects pj = new projects(); int ret = pj.insert_ProjectBackUp(pj_id.ToString()); if (ret > 0) { pj.delete_project(pj_id.ToString()); StringBuilder strSQL = new StringBuilder(); strSQL.Append("select pj_id, pj_code, d_id, pj_name, pj_budget, pj_complete_status, pj_category, "); strSQL.Append(" pj_approval_status, pj_lastupdate from projects "); strSQL.Append(" where pj_status = '" + radProjectType.SelectedValue + "' and "); strSQL.Append(" d_id = " + ddlDept.SelectedValue); SqlDataSource4.SelectCommand = strSQL.ToString(); SqlDataSource4.DataBind(); GridView1.DataSource = SqlDataSource4; GridView1.DataBind(); } }