This is a migrated thread and some comments may be shown as answers.

Saving multiple items

5 Answers 135 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Konstantin asked on 27 Jul 2008, 08:02 PM

Could you please advise how to save multiple items with the Grid?

I have created a grid with 2 read-only columns and 2 writeable check box columns, enabled MultiRowEdit, put the whole grid into the Edit mode and wanted to set check boxes and save the whole grid when I click Save.

However, I am having couple of problems:
1. Changing pages or sorting removes all changes (probably it rebinds the grid)
2. Without rebind, I can't find how to get a primary key for the row (I added an invisible column to the grid)
3. Without rebind, I can't put Grid into Edit Mode.

Also, I have a couple of side questions (not too critical):
4. If I enable grouping by column, I can't put a grid into edit mode at all (found couple of ways on the site, none of them worked, throwing exception). Or is there a way?
5. Filtering with auto suggestions - is there a way to set it up in easy way, like asking grid to traverse all rows for specific columns, find all values and then showing them in drop downs on under selected columns?

Thank you

5 Answers, 1 is accepted

answered on 28 Jul 2008, 06:24 AM

Hi Konstantin,

1. Go through the following help articles and see whether it helps.
      Saving grid settings on a per user basis
      Persisting CheckBox control state in GridTemplateColumn on rebind
     Persisting the selected rows on sorting/paging/filtering/grouping

2. Try setting the DataField of the invisible column as the DataKeyName and try accessing it in the ItemDataBound event as shown below.

CS:

    
            protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) 
        
                { 
        
                    if (e.Item is GridDataItem) 
        
                    { 
        
                        GridDataItem item = (GridDataItem)e.Item; 
        
                        string strKey = item.GetDataKeyValue("ProductName").ToString(); 
        
                    } 
        
                }

Thanks
Shinu