Silverlight Technology导入和导出Excel到数据库 [英] Silverlight Technology to import and export excel to database

问题描述

你好朋友，
我正在尝试使用gridview将excel文件导入和导出到数据库.任何人都告诉我如何使用silverlight进行此操作.

预先感谢

Hello friends,
I was trying to import and export excel file to database using gridview. Any anyone tell me how this can be carried out using silverlight.

Thanks in advance

推荐答案

您首先需要通过Web服务将数据获取到Silverlight应用程序中.
完成此操作后，您可以使用各种方法导出到excel-在Internet上搜索，您将找到一些方法.

例如，请看一下- Silverlight 4:使用COM对象与Excel的互操作性 [ ^ ].但是，使用COM并非绝对必要-还有其他方法.

Infragistics可以导出到excel控制.
或者，您可以仅循环访问服务返回的数据，然后自行导出到excel.

You will first need to get data into the Silverlight app via a web service.
Once this is done, you can export to excel using various methods - search on the internet and you shall find some approaches.

As an example, have a look at this - Silverlight 4: Interoperability with Excel using the COM Object[^]. However, using COM is not absolutely necessary - there are other ways too.

Infragistics has an export to excel control.
Or You ycould just loop through data returned by the service and export to excel on your own.

这篇关于Silverlight Technology导入和导出Excel到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！