Prev: gridview inside updatepanel
Next: System.Web.IHttpHandler works on local machine but not on webhost
From: JohnE on 11 Mar 2010 23:23
Hello. I have a gridview that has a nested gridview. I want to export the
main gridview information. I have been able to export other gridviews but
none had a nested gridview. My first thought was to export the underlying
sqldatasource rather then the gridview. Also, the information is already
available so a trip to the server would not be necessary. I have googled and
found some but couldn't get then to work properly. By that I mean
formatting, etc. What I am trying now is the following;

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
gvwChangeRequestList.DataSourceID = "ChangeRequestListSqlDataSource";
DataTable table = new DataTable();
gvwChangeRequestList.DataBind();
gvwChangeRequestList.AllowPaging = false;
gvwChangeRequestList.AllowSorting = false;
gvwChangeRequestList.AutoGenerateEditButton = false;
gvwChangeRequestList.Columns[0].Visible = false;
PrepareGridViewForExport(gvwChangeRequestList);
//ExportToExcel();
ExportToSpreadsheet(table,"ChangeList");
}


public static void ExportToSpreadsheet(DataTable table, string name)
{
HttpContext context = HttpContext.Current;
context.Response.Clear();
foreach (DataColumn column in table.Columns)
{
context.Response.Write(column.ColumnName + ";");
}
context.Response.Write(Environment.NewLine);
foreach (DataRow row in table.Rows)
{
for (int i = 0; i < table.Columns.Count; i++)
{
context.Response.Write(row[i].ToString().Replace(";",
string.Empty) + ";");
}
context.Response.Write(Environment.NewLine);
}
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.AppendHeader("Content-Disposition",
string.Format("attachment; filename=" + name + ".xls"));
context.Response.End();
}

This is not returning anything back. I get no error, just no information.
Is someone willing to review and see if I missed something? I'm also open to
ideas of a better way to export.

Thanks.
John



From: JohnE on 12 Mar 2010 23:35
Nevermind. I got it figured on the exporting of the sqldatasource rather the
the gridview with the nested gridview.



"JohnE" wrote:

> Hello. I have a gridview that has a nested gridview. I want to export the
> main gridview information. I have been able to export other gridviews but
> none had a nested gridview. My first thought was to export the underlying
> sqldatasource rather then the gridview. Also, the information is already
> available so a trip to the server would not be necessary. I have googled and
> found some but couldn't get then to work properly. By that I mean
> formatting, etc. What I am trying now is the following;
>
> protected void btnExportToExcel_Click(object sender, EventArgs e)
> {
> gvwChangeRequestList.DataSourceID = "ChangeRequestListSqlDataSource";
> DataTable table = new DataTable();
> gvwChangeRequestList.DataBind();
> gvwChangeRequestList.AllowPaging = false;
> gvwChangeRequestList.AllowSorting = false;
> gvwChangeRequestList.AutoGenerateEditButton = false;
> gvwChangeRequestList.Columns[0].Visible = false;
> PrepareGridViewForExport(gvwChangeRequestList);
> //ExportToExcel();
> ExportToSpreadsheet(table,"ChangeList");
> }
>
>
> public static void ExportToSpreadsheet(DataTable table, string name)
> {
> HttpContext context = HttpContext.Current;
> context.Response.Clear();
> foreach (DataColumn column in table.Columns)
> {
> context.Response.Write(column.ColumnName + ";");
> }
> context.Response.Write(Environment.NewLine);
> foreach (DataRow row in table.Rows)
> {
> for (int i = 0; i < table.Columns.Count; i++)
> {
> context.Response.Write(row[i].ToString().Replace(";",
> string.Empty) + ";");
> }
> context.Response.Write(Environment.NewLine);
> }
> context.Response.ContentType = "application/vnd.ms-excel";
> context.Response.AppendHeader("Content-Disposition",
> string.Format("attachment; filename=" + name + ".xls"));
> context.Response.End();
> }
>
> This is not returning anything back. I get no error, just no information.
> Is someone willing to review and see if I missed something? I'm also open to
> ideas of a better way to export.
>
> Thanks.
> John
>
>
>
 | 
Pages: 1
Prev: gridview inside updatepanel
Next: System.Web.IHttpHandler works on local machine but not on webhost