如何将sqldata导出到Microsoft Excel [英] how to export sqldata to microsoft excel

问题描述

hi的标签为name，age，add和相应的文本框，第2个按钮为
iinsert并导出.我希望在用户单击插入数据"时将其存储在
sql数据库，这很好.我现在已经执行了此操作，我想要的是用户单击导出数据应显示在Microsoft Excel工作表中.我搜索了google，但在我的project中却找到了一些代码.plzhelp

hi have label as name ,age ,add and corresponding textbox and 2 button as
iinsert and export .i want that when user click insert data wll store in
sql database thats fine .i have done this now what i want is that user click export data should display in microsoft excel sheet. i search the google got some code but not able to do so in my project.plz help

推荐答案

Excel理解.csv.许多数据库允许.csv导出.试试吧;)

Excel understands .csv. Many databases allow .csv export. Try it ;)

嗨sahuanil，

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet80%% 93Gridview_to_Excel_DataTable_to_Excel.aspx [^ ]


http://www.codersource. net/asp-net/asp-net-miscellaneous/exporting-data-grid-to-excel-using-c.aspx [

Hi sahuanil,

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx[^]


http://www.codersource.net/asp-net/asp-net-miscellaneous/exporting-data-grid-to-excel-using-c.aspx[^]

These links are useful to you.

Thanks,
T.Saravanan :)

这篇关于如何将sqldata导出到Microsoft Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！