Technology Research And Application. Net Framework-based Web Database Access

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 ODBC, DAO and RDO based on ODBC, JDBC, OLE DB/ ADO, they appear separately on different period and used broadly, a lot of techniques are still very popular now. General web database access realizing technique includes the CGI, ISAPI, ASP, PHP, 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 provider, applicable occasion and performance analysis of RecordSet, DataReader and DataSet, Connection Pool optimize, optimize of stored procedure, security etc and gives a related test data with analysis. In addition, it discusses .NET structure,ASP.NET core and session state foundation technique and 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 current development of database application on WEB.Based on the above Web database access technique studies, according to actual need of TianGuang Science & Technology Company, a electronics reading room system of B/S mode has been designed and realized. That system on .NET platform is realized with C# language by adoption ADO.NET data access technique and related performance optimize technique. This system consists of presentation layer,data logic layer and data layer. The presentation layer is placed in client anywhere supported by general browser. Business data logic layer as center agent is usually named applied server. The backstage is a SQL Server database server. The business logic layer of the system uses ADO.NET technique connecting and accessing database, it runs at the Web server, makes use of connection pool technique and adopts SQL Server.NET data providers, the large quantity stored procedures is adopted to refresh data, the DataReader and DataSet are mixed to use, safe data conjunction, application program code and database account Body a verification and Legal power management etc technique are used. Such things enhance consumedly data access efficiency and performance of application program .The finally ADSI and its application in the system are discussed too.In the process of designing and realization of the electronics reading room system, I completely am responsible for the whole system development of planning, putting into practice and controlling. I primary analyze the request the system, the design of the system, database design and 80% coding work.