Design of Remote Grain and Oil Data Updating Based on .NET Platform

Abstract

From a simple and practical point of view, a method of updating remote grain and oil data by stored procedure is proposed. This paper mainly explains how to establish the stored procedure in SQL Server and problems which were encountered when data updating was being implemented in ASP.NET, besides, also gives the key program of the method to realize the code analysis. The experience shows that the method adopting stored procedure to manipulate data not only improves the speed of data access, but also shields the logic of database table well. It has a good reference value for the development of whatever management information system with three-layer B/S structure.