如何在c＃中单击按钮后在excel表中获取sql表列 [英] How to get sql tables columns in excel sheet after click button in c#

问题描述

Hai，





我有一个网页。它有控制名称和城市标签框和 txtName和TxtCity文本框和BtnSubmit按钮控件。如果我们点击按钮，它将打开一个excel表并显示输入名称的所有可能列，并且应该从sql server table显示城市。任何人都可以帮助我



提前谢谢

解决方案

请你查一下这个链接，它会恶魔海峡如何导出数据脱颖而出。对于您的解决方案，您需要执行以下步骤。



1）在网页上输入文本框中的值

2）用户点击按钮，在您的sql服务器数据库上激活选择查询，根据您的文本框值过滤您的记录，并根据您的结果数据填写数据表或数据集

3）使用export to excel功能给定链接（您需要根据您的要求修改导出到excel的代码）





导出到excel的参考链接



导出到Excel [ ^ ]



从Gridview和数据表导出到Excel [ ^ ]

我建​​议使用ADO.NET。



使用ADO.NET处理Excel文件 [ ^ ]

使用ADO和ADO.NET与EXCEL：资源和已知问题 [ ^ ]

使用Foreach循环容器浏览Excel文件和表格 [ ^ ]

如何使用ADO.NET在Visual Basic .NET的Excel工作簿中检索和修改记录 [ ^ ] - 我的最爱！没错，它不是C＃，但它很容易理解，因为VB.NET语言类似于C＃



欲了解更多信息，请参阅：

ADO.NET [ ^ ]

ADO.NET代码示例 [ ^ ]

参考这个.. :)



如何到出口SQL的数据到Excel-使用微软办公-互操作 [<一个href =http://dotnetmentors.com/c-sharp/how-to-export-sql-data-to-excel-using-microsoft-office-interop.aspxtarget =_ blanktitle =New Window > ^ ]

Hai,


I have a web page.It is having control "Name" and "City" label boxes and "txtName" and "TxtCity" textboxes and "BtnSubmit" button control.If we click button it will open an excel sheet and display all the possible columns for the entered name and city should be displayed from sql server table.Can anybody plz help me

Thanks in advance

解决方案

Can you please review this links, it will demon strait how to export data to Excel. for your solution, you need to do this steps.

1) on web page enter value in text boxes
2) as user click on button, fire select query over your sql sever database which filter your records based on your text boxes value and filled out data table or data set as per your resulted data
3) use export to excel functionality from given links (you need to modified code for export to excel as per your requirement)


reference links for export to excel

Export to Excel[^]

Export to Excel from Gridview and Data Table[^]

I would suggest to use ADO.NET.

Using ADO.NET to work with Excel files[^]
USING ADO AND ADO.NET WITH EXCEL: Resources and Known Issues[^]
Loop through Excel Files and Tables by Using a Foreach Loop Container[^]
How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^] - my favorite!; True, it's not C#, but it's easy to understand because VB.NET language is similar to C#

For further information, please see:
ADO.NET[^]
ADO.NET Code Examples[^]

refer this..:)

how-to-export-sql-data-to-excel-using-microsoft-office-interop[^]

这篇关于如何在c＃中单击按钮后在excel表中获取sql表列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！