1.建立连接ado 数据连接
2.建立ado的command对象
dim cmd as new adodb.command
cmd.commandtext="select * from customer"
datagrid1.datasource=cmd.execute
2.建立ado的command对象
dim cmd as new adodb.command
cmd.commandtext="select * from customer"
datagrid1.datasource=cmd.execute
解决方案 »
- 动态链接库EasyUSB23xx.dll调用问题
- 为什么这段代码抽出的题不是随机的?哪里有错误?
- 关于RichtextBox的格式输入
- vb里用INI配置文件,怎么连数据库呀,文件格式和连接代码该怎么写,给个例子
- 不知道是什么意思...
- 十万火急,送一百分!
- 客户端怎样调用服务器端的组件(MTS)?
- 读一个文件,想直接读最后一行最快的方法是什么呀?
- 把datagrid的数据打印出来
- DIM A,B As String 为什么有时可以有时又不行?
- 我子在VBA编程操作EXCEL时,遇到“运行时错误‘1004’,不能取得类Range的specialcell属性”的错误,如何解决呀?
- 修改菜单编辑器编辑的菜单的字体
sql 语句,想在datagrid 里显示数据集,怎么办?
再建一个模块。model代码如下:
public cn as new connection
public rs as new recorderset
Function cnDB() As Connection
Con1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=master;Data Source=NIIT_GUO"
Con1.Open
Set cnDB = Con1
End FunctionFunction rsDB(Con1, sql As String) As Recordset
Rst.Open sql, Con1, adOpenDynamic, adLockPessimistic
Set rsDB = Rst
End Function
窗口代码如下:
Private Sub Form_Load()
Set Con1 = cnDB()
Rst.CursorLocation = adUseClient
Set Rst = rsDB(Con1, "Select * From customer")
DataGrid1.ClearFields
Set DataGrid1.DataSource = Rst
End Sub
在windows sever 2000+sql sever 2000 下测试通过
把public cn as new connection 和 public rs as new recorderset
改为: public Con1 as new connection 和 public Rst as new recordset