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

[bienwell]

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.

 

[Grant Merwitz]

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]

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

Thanks

==========================================================