摘 要
本文首先闡述了基于.NET Framework平臺的圖書館管理信息系統的開發背景以及其實踐意義，其次說明了圖書館管理信息系統的功能以及相比同類軟件的創新之處。然后就圖書館管理系統開發中所使用的一些的技術進行研究探討。主要針對數據庫的設計技術、存儲過程技術、ADO.NET技術以及用SQL Server .NET Framework 數據提供程序訪問SQLserver2000數據庫技術四個方面進行了研究。最后還附上了圖書館管理信息系統的安裝說明、簡單使用說明和一些通用性的經典代碼。筆者化了大量的時間用于程序設計，這也是筆者工作的重點,所開發的軟件具有實用價值，所編寫的代碼對.NET程序員也有很好的參考性。在系統的開發過程中，筆者深刻體會到了.NET平臺的強大性、優越性以及存儲過程在提高數據訪問性能和增強數據訪問安全性上所起到的重要作用。此外,對于關系代數在數據庫科學里的應用，筆者在編程過程中也做了一定的研究。
關鍵詞: 數據庫；.NET Framework；ADO.NET；存儲過程；SQL Server .NET Framework 數據提供程序
ABSTRACT
The Management Information System of Library using .NET
This paper expatiate the Management Information System of Library using .NET, its background and the significance it has when application. Then, it presents the function of the Management Information System of Library and also discuss some technologies using when develop this system. Especially, it discuss the design technology of database, Stored Procedure, ADO.NET and control SQL Server 2000 using SQL Server .NET Framework Data Provider . In the end, it details the setup introduction and the user’s guide for the Management Information System of Library and also some classic code. The writer used a lot of time to design the program which is the keystone of all the works. The writer realized the importance of Stored Procedure for better performance and improving the security and also the advantage of .NET when programming. Moreover, the writer also investigates the applications of relational algebra in database science when programming.
Keywords: Database; NET Framework; ADO.NET; Stored Procedure; SQL Server .NET Framework Data Provider
