With the high development of Internet and Web database technology, the system development based on B/S 3-tier architecture becomes more and more popular. And .NET architecture of MS is the better choice because it has such advantages as multi-language supporting, convenient deployment, high development efficiency, good system stability and powerful function, and etc.Firstly, this thesis introduced .NET platform and two key technologies: Commom Language Runtime (CLR) and Fundamental Class Libraries (FCL) of .NET framework. Then it discussed the development of system architecture, from C/S 2-tier then B/S 3-tier, to multi-layer distributed architecture, and compared their advantages and disadvantages. Secondly, it introduced the development of Web database and related access technology. Then it emphatically discussed the object model of ASP.NET and focused on how to access Web database by ADO.NET. After the system development environment was determined, through a real project the thesis researched on how to divide the three layers (Presentation layer, Business layer and Data layer) as per concrete system requirements, how to deploy 3-tier architecture using ASP.NET, how to implement the interaction of three layers and how to achieve the best performance by assigning the functions among these three layers properly. And it also completed the query and update manipulation on Web database using DataAdapter and Dataset, and did some optimization on those Web pages that need to bind many drop-down list boxes on first loading, which improved the loading speed and system stability greatly. Thirdly, as a Web system, the thesis proposed a solution about how to ensure system safety and control privilege assignment, how to deal with the database concurrency issue, and how to decrease the database connection resource, and etc. Finally, it summarized the main research fruits and foresaw the development prospect of .NET architecture. |