protected void grdWorkflowMaster_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxPageControl pageControl = grid.FindEditFormTemplateControl("WorkflowMasterPageControl") as ASPxPageControl; ASPxDateEdit effectDate = pageControl.FindControl("EffectDate") as ASPxDateEdit; ASPxComboBox entCode = pageControl.FindControl("EntCode") as ASPxComboBox; ASPxComboBox buCode = pageControl.FindControl("BUCode") as ASPxComboBox; ASPxComboBox buHead = pageControl.FindControl("BUHead") as ASPxComboBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string PK = e.Keys[0].ToString(); string entCodeDesc = GlobalClass.EntityCodeDescription(entCode.Value.ToString()); string buCodeDesc = GlobalClass.BUCodeDescription(buCode.Value.ToString()); string buHeadName = AccountClass.UserCompleteName(Convert.ToInt32(buHead.Value.ToString())); string sLastModified = DateTime.Now.ToString(); string update_MRP = "UPDATE tbl_System_Workflow " + " SET [EffectDate] = @EffectDate, " + " [EntCode] = @EntCode, " + " [BUCode] = @BUCode, " + " [BUHead]= @BUHead, " + " [LastModified] = @LastModified " + " WHERE [PK] = @PK"; SqlCommand cmd = new SqlCommand(update_MRP, conn); cmd.Parameters.AddWithValue("@PK", PK); cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString()); cmd.Parameters.AddWithValue("@EntCode", entCode.Value.ToString()); cmd.Parameters.AddWithValue("@BUCode", buCode.Value.ToString()); cmd.Parameters.AddWithValue("@BUHead", buHead.Value.ToString()); cmd.Parameters.AddWithValue("@LastModified", sLastModified); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); conn.Close(); BindWorkflow(); e.Cancel = true; grid.CancelEdit(); }