コード例 #1
0
    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();
        }
    }