SQL Server与文本应用程序之间的数据导入导出的实现主要有两种方法,一种是SQL Server本身提供的方法,另一种是通过编写客户端程序来实现数据的导入与导出功能;其中通过客户端程序来实现数据导入时采用的是ASP.net中提供的OLE DB Provider for Jet 4.0链接到Excel,将Excel数据读取到数据集对象中,数据导出是采用的是ASP.net中提供的StreamWriter类来实现的。
The Research and Implement of Data Exchange between SQL Server and Text Application Program Based on ASP.net
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
NETL
NSTL
万方数据
