Export Datagrid data to Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

et - 27 Jun 2005 19:34 GMT

How can I export data from a grid into Excel? Or from a datatable?

I don't have a query I am displaying the schema from a database using a
datatable, and now I want to export it to excel:
dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object()
{Nothing, Nothing, Nothing, Nothing})

dg.DataSource = dtfields

dg.DataBind

Reply to this Message

Elton Wang - 27 Jun 2005 19:57 GMT

Take look following url:

http://support.microsoft.com/default.aspx?scid=kb;en-us;317719

HTH

Elton Wang

> How can I export data from a grid into Excel? Or from a datatable?
>
[quoted text clipped - 6 lines]
>
> dg.DataBind

Reply to this Message

et - 27 Jun 2005 20:28 GMT

That will do it! Thanks.

> Take look following url:
>
[quoted text clipped - 14 lines]
>>
>> dg.DataBind

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...