?a òa
?ú?a??è?D???òìμ?D??￠????ê±′ú￡??????úò?3é?a?ò??éú???D2??é?òè±μ?ò?2?·??￡′?í3μ?????1üàí·?ê?￡?ò??￥?￥?T·¨êêó|é??áμ?·￠?1￡??üòa?óóD?ü·?±?oíè?D??ˉμ?1üàí·?ê?￡?òò′??íóDá??a??????1üàí?μí3?￡
±??μí32éó?ASP.NET??ê?oíèy2??ü11??ê???DDéè??oí?a·￠￡?2￠í¨1yê1ó?SQL Server 2005êy?Y?aà′??êy?Y??DD1üàí?￡???μí3?÷òaê??ú×??§éúoí?ìê|μ???μμ???ó?￠2é?ˉoíéóo?1üàíμè￡?2￠?ò?ìê|?1?éò?í¨1y?￥áaí????§éúμ?????￡¨éè??￡?oí′e±??é??×?3??à?¨￡????§éúμ???????ê???DD?ì2é￡?2é?′×??o?ù′?μ??§éúμ?′e±?3é?¨?°1üàí?§éúμ??à1???μμ?￡1üàí?±?ú????1y3ì?D???éò?2é?′?§éúμ??à1?D??￠2￠???§éúìá??μ?óD1???μμ??DD1üàí￡??1?éò?2é?′?ùóD?§éúμ?′e±?3é?¨oíêμ?°?é??D??￠μè?￡

1??ü′ê￡oASP.NET￡?èy2??ü11￡?SQL Server 2005

Abstract
In this era of rapid development of science and technology, the computer has become an important part of our lives. The management of paper has gradually can not adapt to social development. It requires a more convenient and human-oriented management, so we will have a management of the paper.
The system uses ASP.NET technology and three-tier technology to design and develop, and by using SQL Server 2005 database for data management. The system is mainly to meet the students and teachers?ˉ demand to submit, audit and manage documents. Besides teacher can also assess the student's paper (design) and the oral defense through the internet, therefore, they are able to research the performance of their students to reply, and teachers can check their students?ˉ the format of paper and research the score of their students?ˉ reply their paper and manage their students?ˉ documents. Similarly, administrators can research the results of all students to reply and Practice situation online and manage all students?ˉ documents.

Key words￡oASP.NET , Three-tier , SQL Server 2005

????

1 òy?? 1
1.1??ìaμ??D??òaò? 1
1.2??ìaμ?éè????±ê 1
1.3????μ????ú°2?? 2
2 ?a·￠?·?3oí?à1???ê??ò?é 2
2.1?a·￠ó??? 2
2.2 SQL Server 2005 3
2.3 B/Sì??μ?á11 3
2.4 .NETèy2??ü11 4
2.5 ?a·￠?°??DD?·?3 5
3 ?μí3Dè?ó·??? 5
3.1?μí3?éDDD?·??? 5
3.2?μí3Dè?ó·??? 6
3.2.1?μí31|?üDè?ó 6
3.2.2?μí3D??üDè?ó 7
3.3?μí3êy?Yá÷í? 7
3.4?μí3êy?Y×?μ? 9
4 ?μí3éè?? 10
4.1?μí3×üì?1|?ü?á11 10
4.2?μí3?ê??éè?? 10
4.3êy?Y?aéè?? 13
4.3.1êy?Y?aE-Rí? 13
4.3.2êy?Y?a±íμ?éè?? 13
5 ?μí3êμ?? 18
5.1?μí3μ???????êμ?? 18
5.2?§éú1|?ü?￡?é 21
5.2.1′e±?????±í?￡?éêμ?? 21
5.2.2êμ?°D??￠?￡?éêμ?? 24
5.2.3??μμé?′? 26
5.3?ìê|?￡?éêμ?? 29
5.3.1??????ê?éè???￡?éêμ?? 30
5.3.2??????ê??ì2é?￡?éêμ?? 38
5.3.3??μ??ìê|3é?¨?à?¨?￡?é??ì?êμ?? 41
5.3.4?à???ìê|?à?¨?￡?éoí′e±?3é?¨?à?¨?￡?éμ???ì?êμ?? 46
5.3.5?μ??òéêé?à?¨μ???ì?êμ?? 46
5.3.6êμ?°3é?¨?à?¨?￡?é??ì?êμ?? 47
5.3.7?￡°?1üàí?￡?éμ???ì?êμ?? 47
5.3.8êμ?°±¨??1üàí?￡?éμ???ì?êμ?? 48
5.3.9′e±?????±í1üàí?￡?éμ???ì?êμ?? 48
5.41üàí?±1|?ü?￡?é 50
5.4.1????3é?¨±¨±í??ì?êμ?? 50
6 ?áê?ó? 53
2??????× 54
?? D? 55

1 òy??
??×?é??áμ???2?oí·￠?1￡??????ú?ú?ò??è?3￡éú???Dò??-3é?a2??é?òè±μ?2?·??￡?ü?úè?ààé??áμ??÷??áìóò??·￠?ó×???òaμ?×÷ó??￡×÷?a?????úó|ó?μ?ò?2?·?,ê1ó??????ú??????D??￠??DD1üàí,??óD×?ê?1¤1üàí?ù?T·¨±è?aμ?ó?μ??￡?ú?ì?ù??±??Yμ?í???é??áà?￡??T2?′ùê1ê|éú??á÷ó?1μí¨′ó??????±?3éí¨1y????1üàí?μí3à′êμ???￡±??μí3ê?ò????ùóú.NET??ê?￡??áo?êμ?ê?é???a·￠μ?????1üàí?μí3?￡í¨1yí???à′íê3é′ó?§éú??μ?ê|μ??????D?ú?ì2éμ?????μ?3é?¨?à?¨oí×?oóμ?????ìá??????1y3ì￡??aê|éúìá1?á?±?à??￡
1.1??ìaμ??D??òaò?
?úè?????D§??ó??ì?ú×àμ???′úé??áà?￡??ò???§D￡μ?±?òμéú?????à1?×êá??1ê?ê1ó?′?í3è?1¤μ?·?ê?à′??DD1üàí￡??a?ù2???1¤×÷D§?êμí￡????òê±????á??á2úéú′óá?μ????t￡?òa???aD????t??DDè?3￡μ?1üàí???á′?à′???àμ?2?±?￡?2éó??a??′?í3μ?·?ê??1óD?é?@@???×êá??aê§￡?D1??μèμè???à2?°2è?òò???￡
?ù??????μ?′ó2?·?±?òμéú￡?óéóú??ê??′??±?òμμ??§éú￡??é?üoü?àè??ú×?±?òμéè??ê±??2??ú?§D￡￡???ê??úêμ?°μ￥???￡òò???a?ùμ??°òa??oí×??oμ?μ?ê|1μí¨?í?á??μ?±è??à§??￡??a?ùμ?ê|ò2?í2??üoüo?μ?á??a×??oμ??§éú???èè?o?￡?????ò2?í2?o?ìá1?±è??óD????D?μ???μ??￡?aá?·?±??§D￡?ü1??üo?μ???±?òμ?????à1?×êá???DD1üàíò??°μ?ê|ó??§éú?????ü1??üo?μ???á÷￡?òò′????¨?a·￠ò?ì×±?òμ????1üàí?μí3?￡±??μí3?éò?oü′ó3ì?è??é?é???ìáμ?μ??êìa￡?2????ü1?ìá???§D￡1¤×÷è??±??±?òμ????1üàíμ?D§?ê￡?í?ê±ò2?aμ?ê|ó?±?òμéú????ìá1?á?ò???oüo?μ???á÷ó???μ?μ???ì¨?￡
2??????×
[1] ???÷1¤×÷êò±à, MIS?μí3?a·￠ó?ó|ó?￡¨ASP.NET+SQL Server°?￡?,è???óêμ?3?°?é?, 2005-8-1
[2] ??á￠?? ??, ó?êμày?§ASP.NET?a?aê1ó?C#ó?ADO.NET, μ?×ó1¤òμ3?°?é?, 2004-1-1
[3] o??? ?÷±à￡???óà??￡?????1ú￡?o?ó?1a ±à??, ASP.NET 2.0?a·￠????,è???óêμ?3?°?é?, 2006-5-1
[4] [?à]°??á?÷ ??￡?ê??μ ò?, ASP.NET?ù′??ì3ì?a?aC#°?ày°? , ???a′ó?§3?°?é?, 2003-10-1
[5] (?à)Steven Wort; Christian Bolton, SQL Server 2005D??üμ÷ó? , ???a′ó?§3?°?é?, 2009-5-1