摘 要
計算機誕生以來，對數據的管理一直是計算機應用中最為重要的環節，數據庫管理系統便是這一環節中堅力量。在.NET平臺推出以后，由于其通用語言基礎結構和規范性，讓不同語言開發的程序員們都能得心應手地在.NET平臺下進行高效的程序開發，ADO.NET框架對數據庫管理系統的訪問控制是相當的靈活和方便，減少了程序員們操作數據庫底層代碼，讓程序員的精力完全集中到邏輯代碼開發之中。因此，采用.NET平臺開發管理信息系統是一個明智的選擇。
某店積分更新記錄管理前臺采用.NET,后臺采用SQL 2000，語言使用C#。實現的系統功能是對用戶消費和追加的積分進行更新，并對積分變化進行記錄。程序模塊讀取臨時積分表，通過返回臨時積分表的數據對積分表，用戶狀態表，積分獎勵記錄表進行更新，并對積分累積記錄表進行更新，系統著重于對更新失敗和程序異常時進行處理。
關鍵詞：計算機應用；數據庫管理系統；積分更新記錄；.NET平臺；ADO.NET；C#；SQL2000
The Shop’s Integral Update Record Management
Abstract
Data management is always the most important link of the computer’s application, since the invention of the computer, and the database management system is a very important in this link. After the .NET was launched, for its common language structure and standard, programmers of all languages carry on the procedure high effectively under the .NET platform. The structure of ADO.NET give a flexible and suitable manage to the access control of database management system, this reduce the chance of operating lower layer code, and make programmer pay more attention to logical code development. Therefore it is wise to choice the .NET platform to development management information.
.NET is used as onstage，SQL 2000 is used as backstage and C# is used as developing language in the Integral to update records management. The function of system is to update the integral of consuming and producing, and carries on the record of the integral changing information. When the program module read the temporary integral table, it updated the integral table, the user condition table, the integral reward data sheet through returns the data of temporary integral table. This system pay more attention to dealing with update failure and procedure exceptionally when carried on processing.
