基于C#的WinForm开发中存储过程应用研究  

How to use Stored Procedure in WinForm application development based on C#

作　　者：于磊[1] YU Lei(School of Continuing Education,Guizhou University,Guiyang 550001,China)

机构地区：[1]贵州大学继续教育学院,贵州贵阳550001

出　　处：《软件导刊》2018年第4期178-179,183,共3页Software Guide

摘　　要：在基于C#的WinForm+SQL数据库应用开发中,存在着大量数据库操作,直接使用命令字符串进行操作的常规方式存在执行速度低、增加网络通信量、修改困难等问题。改善上述问题的有效方法是利用SQLServer提供的存储过程进行数据库操作。在实际开发中应用存储过程,采用不同方法进行对比测试,结果表明,在开发中合理应用存储过程能有效地将应用与数据操作分离,提高运行效率,提高数据库访问的安全性并增加灵活性。In C#based WinForm+SQL application development,there is a large number of database operations.In general,we use command strings to perform database operations,but this method will reduce execution speed,increase network traffic and cause difficulty of modification.In order to improve the above problems,one efficient method is proposed to use the stored procedure of SQL Server to complete database operations.Through the use of stored procedure and the different methods in the development,the results show that applying stored procedure rationally in development rational employment of the stored procedure in develoment can effectively separate application implementation from data operation,improve operation efficiency and database access security and enhance flexibility.

关 键 词：C# WINFORM SQL 存储过程 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]