Public Elective Courses Based On Asp.net + Sql Web-based System

There are a lot of public electives during the university period.the traditional method of course choosing lack prescience, and there are no prior coordination.This is a very physically sexual problem in the university campus of teaching manage. With the help of the Public elective on-line select system, every students' courses can be determined before the beginning of the term, saving physical force and reasonably distributing teaching resources.The method which carries out the elective on-line select system includes a lot and mainly have JSP+MySql+Tomcat, PHP+MySql+Apache, ASP+SQL Server+IIS and ASP.NET+SQL Server+IIS etc.The development languages of these free methods are all be HTML. nondisjunction between Design code and backstage code makes code not easy to understand and support behind.This text carries on a research to above problem:1.Using ASP.NET as a develop tool, carried out the separation design code between backstage code.2. According to the consideration of the classmates select elective courses usually using Windows system and the easiness to support code of ASP.NET+SQL,we determined to use ASP.NET +SQL Server+t IIS.3. The database accessing of most systems directly write a SQL language sentence in the code to carry on a database search.In this system, the overwhelming majority functions all use saving process to complete the work of database interview.4. It increased flexibility and protected the safety of database that the through coding encrypt string of conjunction database can modify in the web.config at any time.5. It passes the Session in the usage progress, as far as possible uses saving process and as far as possible reduces the etc. means in time of open of database conjunction to lift a high performance in the code.This paper gives the basic design idea of the B/S—based online course elect system by analyzing the characteristic of the B/S structure and combining with the actual public elective courses conditions of our school.It introduces the function module and database design briefly,followed by a discussion on database accessing technology and the active page technology of the course elect system based on ASP.NET and SQL Server 2000 and gives a part of carring code.