.Net WebForm+DEV ASPxGridView后台绑定数据源，在新增、修改、删除时提示：不支持所指定的方法的解决方案

.Net WebForm+DEV ASPxGridView后台绑定数据源，在新增、修改、删除时提示：不支持所指定的方法的解决方案
在更新了SQL端后要跟上：

                e.Cancel = true;//重要
                (sender as ASPxGridView).CancelEdit();//重要

                temp_dt1 = SqlHelper.ExecuteDataTable("select * from 员工日记 where  用户名='" + yhm_str + "' order by 应该结束时间", new SqlParameter[] { });

                ASPxGridView1.DataSource = temp_dt1;
                ASPxGridView1.DataBind();
               
                //或者用下列代码也可以
                //temp_dt1 = SqlHelper.ExecuteDataTable("select * from 员工日记 where  用户名='" + yhm_str + "' order by 应该结束时间", new SqlParameter[] { });
                //(sender as ASPxGridView).DataSource = temp_dt1;
                //(sender as ASPxGridView).DataBind();

                //(sender as ASPxGridView).FilterExpression = "是否办结='未办结'"

举例说明：在RowInserting事件的处理方法

 protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
   {
            try
            {
                string yhm_str = Session["xx_user"].ToString().Trim();
                e.NewValues["修改人"] = yhm_str;
                DateTime sj = SqlHelper.fwq_datetime();
                e.NewValues["修改时间"] = sj;
                string bh_str = e.NewValues["编号"].ToString().Trim();
                string yhqc_str = e.NewValues["用户全称"].ToString().Trim();
                string bumen_str = e.NewValues["部门"] == null ? "" : e.NewValues["部门"].ToString().Trim();
                string xbsx_str = e.NewValues["需办事项"] == null ? "" : e.NewValues["需办事项"].ToString().Trim();
                string sfbj_str = e.NewValues["是否办结"] == null ? "" : e.NewValues["是否办结"].ToString().Trim();
                string sjbjsj_str = e.NewValues["实际办结时间"] == null ? "null" : "'" + e.NewValues["实际办结时间"].ToString().Trim() + "'";
                string cljg_str = e.NewValues["处理结果"] == null ? "" : e.NewValues["处理结果"].ToString().Trim();
                string ygjssj_str = e.NewValues["应该结束时间"] == null ? "null" : "'" + e.NewValues["应该结束时间"].ToString().Trim() + "'";
                Int32 xgcs_str = 1;
                string xgr_str = yhm_str;
                string xgsj_str = sj.ToLongDateString();
                string lrr_str = yhm_str;
                string lrsj_str = sj.ToLongDateString();



                StringBuilder sb = new StringBuilder();
                sb.Append("insert into 员工日记(用户名,用户全称,部门,需办事项,是否办结,实际办结时间,处理结果,应该结束时间,本行修改记录,修改次数,修改人,修改时间,录入人,录入时间) ");
                sb.Append("values('" + yhm_str + "','" + yhqc_str + "','" + bumen_str + "','" + xbsx_str + "','" + sfbj_str + "'," + sjbjsj_str + ",'" + cljg_str + "'," + ygjssj_str + ",'查看'," + xgcs_str + ",'" + xgr_str + "','" + xgsj_str + "','" + lrr_str + "','" + lrsj_str + "')");
                SqlHelper.ExecuteNoneQuery(sb.ToString().Trim(), new SqlParameter[] { });

                e.Cancel = true;
                (sender as ASPxGridView).CancelEdit();

                temp_dt1 = SqlHelper.ExecuteDataTable("select * from 员工日记 where  用户名='" + yhm_str + "' order by 应该结束时间", new SqlParameter[] { });

                ASPxGridView1.DataSource = temp_dt1;
                ASPxGridView1.DataBind();
                ASPxGridView1.FilterExpression = "是否办结='未办结'";
                //temp_dt1 = SqlHelper.ExecuteDataTable("select * from 员工日记 where  用户名='" + yhm_str + "' order by 应该结束时间", new SqlParameter[] { });
                //(sender as ASPxGridView).DataSource = temp_dt1;
                //(sender as ASPxGridView).DataBind();

                //(sender as ASPxGridView).FilterExpression = "是否办结='未办结'";
   }

秋风写淄博，业务联系与技术交流：QQ375172665