On 19 Sep 2006 01:54:40 -0700, "am***********@gmail.com"
<am***********@gmail.comwrote:
>first of all thanks for the reply
Page 1 : fetches data from the database and assigns to a session object
which is accessed in page 2 for generating excel.
This data is bound to a datagrid on page 1.
page 2 is used so that in excel there is only data and not the other
controls which are there on page 2.
What i am trying currently is doing server.transfer to the same page1
so that page 1 has fresh data and then redirecting to page2 to generate
the excel.
OK lets see if this is what you want to do.
1 - page 1's data source is some db container
2 - page 2 puts the data into an Excel spreadsheet
3 - page 2 lets the user modify the data w/out writing the changes to
the database
4 - when page 1 gets reloaded its datasource should be the Excel doc
and not the original db container.
Does the problem involve moving the data from step 3 to step 4? If so
you might consider adding page 3 to display the temporary data and use
a cross-page post to let page 3 access page 2's data.
regards
A.G.
>lets see
plz reply
Registered User wrote:
>On 18 Sep 2006 21:52:18 -0700, "am***********@gmail.com"
<am***********@gmail.comwrote:
Please anyone can answer this question.
am***********@gmail.com wrote:
I have a page where i export to excel the content of Page 1
following code is written on page 2 to generate the excel
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment;
filename=dynamic.xls")
Now i on page 2 some db operation happens, so that data on page 1
should refresh which has datagrid.
i am unable to refresh the data on page1
please guide
How does page 1 get populated initially?
regards
A.G.