I am trying to insert,update delete in ultragrid(grouping) but I am not able to find any solution or any code or any official link for insert,update and delete in groupping.
please help
Groupby records cannot be deleted, only the rows within them can.
There are three properties off the override that control whether modifying rows as well as adding and deleting rows are allowed. If you set these properties on the Override off the DisplayLayout, then these settings apply to the whole UltraGrid.
this.ultraGrid1.DisplayLayout.Override.AllowUpdate = DefaultableBoolean.True; this.ultraGrid1.DisplayLayout.Override.AllowAddNew = AllowAddNew.No; this.ultraGrid1.DisplayLayout.Override.AllowDelete = DefaultableBoolean.False;
You can set them on a specific band as well. These settings override those set on the DisplayLayout's Override object for this band. this.ultraGrid1.DisplayLayout.Bands[0].Override.AllowUpdate = DefaultableBoolean.True; this.ultraGrid1.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No; this.ultraGrid1.DisplayLayout.Bands[0].Override.AllowDelete = DefaultableBoolean.False;
If a new row is added/updated you can call RefreshSort to refresh the grid while groupby is in-use. This can be called in AfterRowUpdate.