Exporting ALL data into Excel file with Page Navigation in ASP.NET

Hi,

I have a question about exporting data from datagrid control into Excel file
in ASP.NET. On my Web page, I have a linkbutton "Export data". This link
will call a Sub Function to perform exporting ALL data from the datagrid
control. Exporting data works fine when I show all data on the datagrid
control.

I'd like to shows only 30 records on the datagrid control instead of ALL
data using page navigation, and perform exporting ALL data from this Link
button. Can I do that ? Is there any other ways that I can use besides
datagrid control for exporting ALL data in ASP.NET. Please give me your
advices.

Thanks in advance.

re: Exporting ALL data into Excel file with Page Navigation in ASP.NET

Yes,

when a user click "Export Data", you can retrieve the original dataset,
or pull down a new dataset with all the data.

With this,you can create your Excel file.

Does that help, or you need some code?

"bienwell" <bienwell@hotmail.com> wrote in message
news:eWNDn%23m%23FHA.3388@tk2msftngp13.phx.gbl...[color=blue]
> Hi,
>
> I have a question about exporting data from datagrid control into Excel
> file in ASP.NET. On my Web page, I have a linkbutton "Export data". This
> link will call a Sub Function to perform exporting ALL data from the
> datagrid control. Exporting data works fine when I show all data on the
> datagrid control.
>
> I'd like to shows only 30 records on the datagrid control instead of ALL
> data using page navigation, and perform exporting ALL data from this
> Link button. Can I do that ? Is there any other ways that I can use
> besides datagrid control for exporting ALL data in ASP.NET. Please give me
> your advices.
>
> Thanks in advance.
>[/color]

re: Exporting ALL data into Excel file with Page Navigation in ASP.NET

Some code samples are very helpful to me. I developed Web page using Visual
Basic.Net.

Thanks

================================================== ========
"Grant Merwitz" <grant@workshare.com> wrote in message
news:O$PBLMn%23FHA.160@TK2MSFTNGP12.phx.gbl...[color=blue]
> Yes,
>
> when a user click "Export Data", you can retrieve the original dataset,
> or pull down a new dataset with all the data.
>
> With this,you can create your Excel file.
>
> Does that help, or you need some code?
>
> "bienwell" <bienwell@hotmail.com> wrote in message
> news:eWNDn%23m%23FHA.3388@tk2msftngp13.phx.gbl...[color=green]
>> Hi,
>>
>> I have a question about exporting data from datagrid control into Excel
>> file in ASP.NET. On my Web page, I have a linkbutton "Export data".
>> This link will call a Sub Function to perform exporting ALL data from the
>> datagrid control. Exporting data works fine when I show all data on the
>> datagrid control.
>>
>> I'd like to shows only 30 records on the datagrid control instead of ALL
>> data using page navigation, and perform exporting ALL data from this
>> Link button. Can I do that ? Is there any other ways that I can use
>> besides datagrid control for exporting ALL data in ASP.NET. Please give
>> me your advices.
>>
>> Thanks in advance.
>>[/color]
>
>[/color]