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" <bi******@hotmail.com> wrote in message
news:eW******************@tk2msftngp13.phx.gbl...

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.

[bienwell]

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

Thanks

================================================== ========
"Grant Merwitz" <gr***@workshare.com> wrote in message
news:O$***************@TK2MSFTNGP12.phx.gbl...

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" <bi******@hotmail.com> wrote in message
news:eW******************@tk2msftngp13.phx.gbl...

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.