| 基于ASP.net的SQLServer与文本应用程序数据交换的研究与实现 |
| |
| 引用本文： | 徐春雨.基于ASP.net的SQLServer与文本应用程序数据交换的研究与实现[J].科技信息,2011(3):66-66,6. |
| |
| 作者姓名： | 徐春雨 |
| |
| 作者单位： | 辽宁省交通高等专科学校信息系,辽宁沈阳110122 |
| |
| 摘 要： | SQL Server与文本应用程序之间的数据导入导出的实现主要有两种方法,一种是SQL Server本身提供的方法,另一种是通过编写客户端程序来实现数据的导入与导出功能;其中通过客户端程序来实现数据导入时采用的是ASP.net中提供的OLE DB Provider for Jet 4.0链接到Excel,将Excel数据读取到数据集对象中,数据导出是采用的是ASP.net中提供的StreamWriter类来实现的。
|
| 关 键 词： | 数据导入 数据导出 ASP.net SQLServer |
The Research and Implement of Data Exchange between SQL Server and Text Application Program Based on ASP.net |
| |
| XU Chun-Yu.The Research and Implement of Data Exchange between SQL Server and Text Application Program Based on ASP.net[J].Science,2011(3):66-66,6. |
| |
| Authors: | XU Chun-Yu |
| |
| Abstract: | There are two methods of data imposing and exporting between SQL Server and text application program. The one method is provided by SQL Server, the other is to write client programs. The OLE DB Provider for Jet 4.0 of ASP.net can implement data importing by writing client program. It can connect to Excel, and read the excel data to dataset object. The Stream Writer class of ASP.net can implement data exporting by writing client program. |
| |
| Keywords: | Data importing Data exporting ASP net SQL Server |
| 本文献已被 维普 等数据库收录！ |
