| Excel与数据库交互的一些问题 |
| |
| 引用本文： | 李乐,王雪平,林剑,杨英姿,刘兵.Excel与数据库交互的一些问题[J].计算机时代,2010(7):31-33. |
| |
| 作者姓名： | 李乐 王雪平 林剑 杨英姿 刘兵 |
| |
| 作者单位： | 1. 湖南科技大学知识处理与网络化制造重点实验室,湖南,湘潭,411201
2. 湖南省水库移民开发管理局 |
| |
| 摘 要： | 介绍了在ASP.NET中实现Excel表格与SQL Server交互的方法,并提供了源代码。使用sqlbulkcopy.Column-Mappings.Add）（和sqlbulkcopy.WriteTOServer）（方法解决导入数据的匹配和效率问题;用添加CSS代码和控制控件的属性来解决导出数据的预处理问题,并以湖南省水库移民数据库系统为例进行了实验。实验表明,所采用的方法能很好地解决Excel与数据库的交互问题,有较好的实用性。
|
| 关 键 词： | Excel SQL Server 数据交互 ASP.NET |
Some Problems of Interaction between Excel and Database |
| |
| LI Le,WANG Xue-ping,LIN Jian,YANG Ying-zi,LIU Bing.Some Problems of Interaction between Excel and Database[J].Computer Era,2010(7):31-33. |
| |
| Authors: | LI Le WANG Xue-ping LIN Jian YANG Ying-zi LIU Bing |
| |
| Affiliation: | 1. Key Laboratory of Knowledge Processing and Network Manufacturing,Hunan University of Science and Technology,Xiangtan,Hunan 411201,China; 2. Hunan Reservoir Resettlement Development Administration) |
| |
| Abstract: | The method of implementing the interaction between Excel form and SQL Server in ASP.NET is introduced and the source code is provided. The matching and efficiency problems of importing data are solved by using the methods of sqlbulkcopy.ColumnMappings.Add（） and sqlbulkcopy.WriteTOServer（）,the preprocessing problem of exporting data is solved by adding CSS code and control attributes,and the experiments are done in the example of Hunan province reservoir resettlement database system. The experiments show that the method can solve the problem of interaction between Excel and database well,and has good practicability. |
| |
| Keywords: | Excel SQL Server ASP NET |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
