Removing buttons in Gridview

[Bob Ross]

I have a GridView with some ButtonFields in it. I want to be able to export this grid into excel but I need to remove the the buttons from the buttonfields.

Is there any way to easily disable/remove the buttons from a ButtonField or ButtonFieldCell? Or I am going to have to remove the column and add it again as a BoundFeild?

[kenobewan]

I would probably use a datatable instead to create the excel, normally this involves reusing the dataset. HTH.

[radcaesar]

Hey Bob, U ask this ?

for (int i = 0; i < gv.Controls.Count; i++)

{

if (gv.Controls[i].GetType() == typeof(LinkButton))

{

l.Text = (gv.Controls[i] as LinkButton).Text;

gv.Controls.Remove(gv.Controls[i]);

gv.Controls.AddAt(i, l);

}

}

[radcaesar]

Sorry Bob, I have took that vice versa...

[Bob Ross]

Thats what I have done in the past. But my college has just rewritten the way it is done for another part of the site and I am trying to reuse his code as much as I can.

I have managed to get it workinf by removing the link from the cells controls and adding a label instead. Not an ideal solution but it seems to work.

[Bob Ross]

Thanks for that radcaesar!
The way I managed to do it is pretty much the same as your method but I think yours slightly better so I will copy it from you.

Thanks again

[radcaesar]

Hey Bob, Mine is not an optimistic solution, Thats why i have post another message saids sorry.

But it can be used, I don't think no performance issues since we must navigate and search for controls in both the cases either in Grid or in Excel.


:)

[hakeemkazmi]

hey Bob,are you able to remove buttonfield from the gridview before exporting it to excel,if yes plz tell me how,for the the code is working fine but i am unable to remove those buttons.plz help me.if you want i can send you the script.
i already post the script in forum " good code to expot to excel sheet but need lil help " plz check that question in forum.

thanks in advance Bob


QUOTE=Bob Ross]I have a GridView with some ButtonFields in it. I want to be able to export this grid into excel but I need to remove the the buttons from the buttonfields.

Is there any way to easily disable/remove the buttons from a ButtonField or ButtonFieldCell? Or I am going to have to remove the column and add it again as a BoundFeild?[/quote]