[Solved] Save all values from a grid

[kollam2003]

I want to save all the values from a grid.
I have 100 records in a grid.
The page count is 10.
Each row has radio buttons in it.
I want to save all the changes in one button click.
How to achieve it.

[Princy]

Hello,

A suggestion would be to set AllowPaging to false and then update the records on the button click event as shown below:
cs:

protected void Save_Click(object sender, EventArgs e)
    {

        RadGrid1.MasterTableView.AllowPaging = false;
        RadGrid1.Rebind();
        foreach (GridDataItem item in RadGrid1.Items)
        {
            string strtxt = item.GetDataKeyValue("DataKeyName").ToString();
        }

        //update query

        RadGrid1.MasterTableView.AllowPaging = true; // set paging back to true after updating
        RadGrid1.Rebind();
    }

Thanks
Princy.

[kollam2003]

But if I rebind it i will loss the state.
Each row is having radio buttons.
The radio buttons selection is made & then only i have to save.

[Shinu]

Hi kollam2003,

Here is a help article which explains how to persist the state of CheckBox in a GridTemplateColumn on Rebind. You can apply the same logic with RadioButton also.
Persisting CheckBox control state in GridTemplateColumn on rebind

Thanks
Shinu.

[kollam2003]

Hai Shinu,
It didnt help me.
Can you plz upload a working example.

[kollam2003]

any one solved the problem?

[kollam2003]

To maintain the state I have done it by using the following code.
But I have a doubt if i have more controls in the grid, should I use seperate Viewstates for each control?. Is it the right way?

  

   private void RememberOldValues()
    {
        ArrayList _rbPresent = new ArrayList();


        int index = -1;
        foreach (GridDataItem _GridDataItem in radGVStudents.Items)
        {
            index = Convert.ToInt32(_GridDataItem.OwnerTableView.DataKeyValues[_GridDataItem.ItemIndex]["StudentID"].ToString());
            bool _rbPresentChecked = ((RadioButton)(_GridDataItem.FindControl("rbPresent"))).Checked;

            // Check in the ViewState
            if (ViewState[CHECKED_rbPresent] != null)
                _rbPresent = (ArrayList)ViewState[CHECKED_rbPresent];

            if (_rbPresentChecked)
            {
                if (!_rbPresent.Contains(index))
                    _rbPresent.Add(index);
            }

            else

                _rbPresent.Remove(index);




        }


        if (_rbPresent != null && _rbPresent.Count > 0)
            ViewState[CHECKED_rbPresent] = _rbPresent;

    }
     private void RePopulateValues()
    {
        ArrayList _rbPresent = (ArrayList)ViewState[CHECKED_rbPresent];
        if (_rbPresent != null && _rbPresent.Count > 0)
        {
            foreach (GridDataItem _GridDataItem in radGVStudents.Items)
            {
                int index = Convert.ToInt32(_GridDataItem.OwnerTableView.DataKeyValues[_GridDataItem.ItemIndex]["StudentID"].ToString());
                if (_rbPresent.Contains(index))
                {
                    ((RadioButton)(_GridDataItem.FindControl("rbPresent"))).Checked = true;
                }
            }
        }
        }
    protected void radGVStudents_PageIndexChanged(object source, GridPageChangedEventArgs e)
    {
        // Put old values in a ViewState
        RememberOldValues();
        radGVStudents.CurrentPageIndex = e.NewPageIndex;
        radGVStudents.Rebind();
        RePopulateValues();
    }
    protected void radGVStudents_PreRender(object sender, EventArgs e)
    {
        if (ViewState[CHECKED_rbPresent] != null)
        {
            RePopulateValues();
        }
    }