摘要
文章介绍了在VB中用ADO控件、DataGrid控件对SQL Server数据库调用的方法以及ADO控件中两个关键属性连接字符串和记录源的设定方法。通过用VB设计C/S模式单表管理系统的实例,说明了如何用ADO控件实现对数据库记录的添加、修改、删除和查询。
This paper presents the way to connect SQL server database with ADO control and DataGrid control in VB,and setting of connection string and record source,which are two key properties in ADO control.At last,by constructing a single table management system of C/S model with VB,the paper also expounds how to add,update,delete and query records in a database with ADO control.