Exporting data from (All columns in data grid EXCEPT THE 1st) to E

[pmud]

Hi,

I am exporting data from an EDITABLE DATA GRID EXCEL. But the 1st column
in data grid is Edit Column. I want to display all columns in Excel except
for the Edit column.

The following code which I am using allows exporting only from text data
from data grid & not from Edit columns which are link buttons. How to leave
this column while displaying data from data grid in Excel?

Code:
public void PerformExcelVie w()
{
Response.Clear( );
Response.Buffer = true;
Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Charse t = "";
this.EnableView State = false;

System.IO.Strin gWriter SW = new System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter HTW = new System.Web.UI.H tmlTextWriter(S W);
DataGrid1.Rende rControl(HTW);
Response.Write( SW.ToString());
Response.End();
}

// From button click I am calling this function

private void btnExcel_Click( object sender, System.EventArg s e)
{
PerformExcelVie w();
}

Also, I tried to REMOVE theEDIT COLUMN on button click
.....DataGrid1. Columns.Remove( DataGrid1.Colum ns[0]);
& then calling the function PerfromExcelVie w() but I got the error:
"Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index ".

How to get over this problem?
Any help will be appreciated .

Thanks
--
pmud

[Raterus]

Check this out,
http://weblogs.asp.net/dneimke/archi.../27/63348.aspx

There are some comments by some people who have your problem, and a solution

--Michael

"pmud" <pm**@discussio ns.microsoft.co m> wrote in message news:30******** *************** ***********@mic rosoft.com...

Hi,

I am exporting data from an EDITABLE DATA GRID EXCEL. But the 1st column
in data grid is Edit Column. I want to display all columns in Excel except
for the Edit column.

The following code which I am using allows exporting only from text data
from data grid & not from Edit columns which are link buttons. How to leave
this column while displaying data from data grid in Excel?

Code:
public void PerformExcelVie w()
{
Response.Clear( );
Response.Buffer = true;
Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Charse t = "";
this.EnableView State = false;

System.IO.Strin gWriter SW = new System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter HTW = new System.Web.UI.H tmlTextWriter(S W);
DataGrid1.Rende rControl(HTW);
Response.Write( SW.ToString());
Response.End();
}

// From button click I am calling this function

private void btnExcel_Click( object sender, System.EventArg s e)
{
PerformExcelVie w();
}

Also, I tried to REMOVE theEDIT COLUMN on button click
....DataGrid1.C olumns.Remove(D ataGrid1.Column s[0]);
& then calling the function PerfromExcelVie w() but I got the error:
"Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index ".

How to get over this problem?
Any help will be appreciated .

Thanks
--
pmud

[pmud]

Thanks Raterus. This was helpful.

"Raterus" wrote:

Check this out,
http://weblogs.asp.net/dneimke/archi.../27/63348.aspx

There are some comments by some people who have your problem, and a solution

--Michael

"pmud" <pm**@discussio ns.microsoft.co m> wrote in message news:30******** *************** ***********@mic rosoft.com...

Hi,

I am exporting data from an EDITABLE DATA GRID EXCEL. But the 1st column
in data grid is Edit Column. I want to display all columns in Excel except
for the Edit column.

The following code which I am using allows exporting only from text data
from data grid & not from Edit columns which are link buttons. How to leave
this column while displaying data from data grid in Excel?

Code:
public void PerformExcelVie w()
{
Response.Clear( );
Response.Buffer = true;
Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Charse t = "";
this.EnableView State = false;

System.IO.Strin gWriter SW = new System.IO.Strin gWriter();
System.Web.UI.H tmlTextWriter HTW = new System.Web.UI.H tmlTextWriter(S W);
DataGrid1.Rende rControl(HTW);
Response.Write( SW.ToString());
Response.End();
}

// From button click I am calling this function

private void btnExcel_Click( object sender, System.EventArg s e)
{
PerformExcelVie w();
}

Also, I tried to REMOVE theEDIT COLUMN on button click
....DataGrid1.C olumns.Remove(D ataGrid1.Column s[0]);
& then calling the function PerfromExcelVie w() but I got the error:
"Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index ".

How to get over this problem?
Any help will be appreciated .

Thanks
--
pmud