摘  要：现在的各大高校，学生人数在不断增加，学生的生活条件变好了，与此同时，学生宿舍的设备也在不断优化。在过去，人工的宿舍管理模式可以简单管理学生的宿舍生活，但是随着时代的发展，这种人工管理模式的弊端也在慢慢显露，操作方法繁杂，效率低下，保密性极差等等。这样落后的管理模式已经不能适应当代社会的需求。因此需要一个功能更完善，操作更方便，容量更大的管理信息系统。本学生宿舍管理系统强化了学生管理的职能，该系统提供了6个大模块，功能分别为：宿舍基本信息模块、学生入住模块、卫生检查模块、水电收费模块、房屋报修模块、外来人员登记模块，这些功能基本上覆盖了学生公寓管理的主要部分。68889

本系统以Visual Studio为开发平台，C#为开发语言，后台数据库采用SQL Server。本宿舍管理信息系统实现了在全校范围内查找一名学生所在公寓的功能，只需要通过查询，输入该学生的学号或姓名，就可以很容易的找到该生所在的公寓，同时也可以了解到其他的一些基本信息。而且现在数据库操作越来越深入人心，各行各业也几乎都涉及到数据库的应用和操作。用数据库来统计学生的基本信息大大提高了宿舍管理的效率。

毕业论文关键词： C#；SQL；宿舍管理；信息管理系统 

The development of the dormitory management system

 based on c # and  SQL Server

Abstract: Now of colleges and universities, the number of students is increasing, student's living conditions better, at the same time, optimization in a student dormitory.In the past, the artificial management of dormitory management mode can be simple student dorm life, but with the development of The Times, the disadvantages of the artificial management mode are also shown slowly, operation method and complex, low efficiency, poor confidentiality, etc.So the backward management pattern already can not adapt to the contemporary social needs.So we need a more complete, more convenient operation, larger capacity management information system.The student dormitory management system to strengthen the function of student management, the system provides six big modules, functions are: basic information module, the student dormitory registration module, sanitary inspection module, water and electricity charging module, housing repair service module, external personnel registration module, these functions are basically covers the main part of the student apartments management.This system with Visual Studio as the development platform, c # as development language, background database using SQL Server.The dormitory management information system realizes the scope to find a student in the school's apartment, only need through the query, enter the student's student id or name, you can easily find the student's apartments, at the same time also can learn some of the other basic information.And database operations now more and more deeply rooted in the hearts of the people, from all walks of life are almost always involves the database application and operation.Use a database to statistics the students the basic information of the greatly improved the efficiency of the dormitory management.

Keywords: C #;SQL;Dormitory management;Management system 

目  录

第1章  绪论 1

1.1系统研究背景和目的 1

1.2 系统研究意义 1

1.3 主要任务 2

第2章 引言 3

2.1 C#语言介绍 3

2.2 SQL数据库介绍 3

2.2.1 SQL简介