Rad Grid and ASP Required Field Validator

[Soha]

I am using RadGrid, containing about 15 columns. Only one of them is editable, it is a text-box and i am using asp required field validator for it.
 when i export that grid to excel or pdf, another column appears containing the text included in the required field validator even if it is already not visible on the grid.

[Cori]

Hello Soha,

Is the RequiredFieldValidator part of the ItemTemplate for that column? That's the only way I can see it being exported.

[Soha]

Thanks for your reply.
Yeah, actually it is.
Where else should i put it to be beside the text?

[Princy]

Hello Soha,

One solution is to hide the RequiredFieldValidator before eporting . Sample code is given below.

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.ExportToExcelCommandName)
        {
            foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
            {
                RequiredFieldValidator validator = (RequiredFieldValidator)item.FindControl("RequiredFieldValidator1");// accessing RequiredFieldValidator
                validator.Visible = false;
            }
            RadGrid1.ExportSettings.OpenInNewWindow = true;
            RadGrid1.MasterTableView.ExportToExcel();
        }
    }

Thanks,
Princy.

[Soha]

but how shall i return it back to Visible = true after the export function finishes