Library management system is a typical management residence system (MIS ), its library to improve the service quality, scientific management, improve the overall level of development of library automation in China has important significance. According to the design requirement of open library, the completion of the main library management system requirements analysis, functional modules and data for the analysis of patterns, and in some basis to design data for structure and the application procedure, the database application system development and library management system for a concise introduction, analysis of the development of Library management system should be carried out in the eight. On this basis, using Visual Studio 2005 as a development tool, SQL Server 2005 database, the administrator to borrow, return, book information query and other functions. The system uses C # technology as front desk, so that the function of the system to the needs of users, easy to use. The background of the use of SQL Server 2005, effective to ensure data integrity and effectiveness, improve the safety of the system, and the system maintenance management and simple.