Research And Implementation Of Web Database Access Technology Based On .NET Framework

With the developing rapidly of Internet, WWW (World Wide Web) has got the very big development. WWW is the most popular and leading information service method. WWW system and database are the foundations of network information service, the technique of Web has become the current focus of research with the database technique, the key is a Web database access technique. The traditional database access technique can't satisfy little by little the demand of high speed access, the data access on broken connection and Complete support of XML, etc. The study of database access technique based on Internet has become one of main direction of database research.Current basic database access technique primarily contain Open Database Connectivity (ODBC), Data Access Object (DAO) and Remote Data Object (RDO) based on ODBC, Java Database Connectivity (JDBC), Object Linking and Embedding Database (OLE DB)/ ActiveX Data Object (ADO), they appear separately on different period and used broadly, a lot of techniques are still very popular now. General Web database access implementation technique includes the Common Gateway Interface (CGI), Server Application Programming Interface (SAPI), Active Server Page (ASP), Professional HyperText Preprocessor (PHP), Java Server Pages (JSP) primarily, these techniques each have their advantages, shortcomings and the proper situations, still are extensive adopted to write the Web application program. Along with the Microsoft .NET releasing, the ASP.NET brings enormous varieties for writing a flood of Web application program. This paper investigates thoroughly the performance optimize of ADO.NET on Web application, which includes comparison, choice and performance optimize of four kinds of .NET data providers, applicable occasion and optimize of stored procedure, security, data consistency etc. In addition, it puts forward that how to develop efficiently database access application of facing to the Internet on .NET environment. These studies provide bigger practical values and guiding meaning for a great deal of the currentdevelopment of database application on Web.Based on the above studies of Web database access technique, according to actual need of Huangshi Road Administrative Office, a Information system of B/S mode has been designed and realized. That system on .NET platform is the implementation with VB language by adoption ADO.NET data access technique and related performance optimize technique. This system consists of browser, Web server and database server. The browser is placed in client anywhere supported by general browser. Business data logic as center agent is usually named Web server. The backstage is a SQL Server database server. The Web server of the system uses AD0.NET technique (such as SQL Server.NET data providers, stored procedures, security, data consistency) connecting and accessing database. Such things enhance consumedly data access efficiency and performance of application program.