How to Bind Dataset return directly to Excel in VB .Net.?

[Balagurunathan S]

Hi Friends.. I need to bind the dataset return value to excel.The thing is ..if i bind to a datagrid and then if i import to excel it works..But what i need is to bind the dataset directly to excel without the intervention of datagrid..Someone help in this regard as early as possible. Thanks In Advance..

Balaguru

[Dave Kreskowiak]

You can't bind an Excel worksheet directly to a DataTable in .NET. Excel doesn't know anything about .NET classes so can't directly interface with them. You'd have to build the worksheet cell-by-cell from the DataTable. You can checkout this[^] and this[^] for examples.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007