基于ADO远程数据访问的设备管理信息系统的开发

The Development of Equipment Management Information System Based on ADO Remote Data-accessed

介绍了企业设备管理信息系统的结构、功能设计和实现方法,并用SQLServer实现数据库。以VB为开发平台建立用户应用通讯接口,用ADO接口技术实现SQLServer数据库的远程访问,获取用户所需的数据和对用户数据进行必要的更新,并用EXCEL实现用户数据集的报表。该系统提高了企业信息化程度。

The system structure,function design and implement methods of equipment management information system implemented by SQL Server were introduced.On the platform of Visual Basic,user interface procedure was setted up using ADO to access MS SQL database,get data needed by users and update data needed changing. At last user’s data-recordset can be exported to EXCEL.This system promotes the enterprise information process.