strSelect = "SELECT Model,Capacity,Price,Unit,Telephone From UPSsupply WHERE Name= " & TxtName & " "
解决方案 »
- vb 如何加入各种格式背景音乐(包括mp3)
- 随便问问,知道麻烦告诉一下?
- 我下载了一个OCX,但在VB中使用时提示:Class not Registered... 谁能告诉我怎么解决啊?
- 请教:如何将变量值作为表单名,以打开表单
- VB自带的datareport如何在程序中设置预览时的缩放比例?
- 有关报表设计问题在于 100分
- 急寻:vb如何实现控制其他程序控件对其进行操作,如click!!
- 菜鸟求助:EXCEL里怎样在同一张sheet中实现一下3个功能
- 换行_&?
- 关于连接的问题??~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~!!!!!!!!!!!!!!!!!
- 用XML文件保存字符串对,值为空格如何保存?
- 再次请教CSDN各位大神
With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=db2.mdb;" & "Persist Security Info=False" .CursorType = adOpenDynamic
.CommandType = adCmdText '将Source作为命令
.RecordSource = "SELECT * FROM UPSsupply where NAME='" & Text1.Text & "'"
.Refresh End With
Set DataGrid1.DataSource = Adodc1
End SubPrivate Sub Form_Load() With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=db2.mdb;" & "Persist Security Info=False" .CursorType = adOpenDynamic
.CommandType = adCmdText '将Source作为命令
.RecordSource = "SELECT * FROM UPSsupply ORDER BY ID"
.Refresh End With
Set DataGrid1.DataSource = Adodc1
End Sub
已经测试成功