我在使用vb,以下是向数据库添加记录的代码,Private Sub add_cmd_Click()
Dim cn As adodb.Connection Dim n As Long
Set cn = New adodb.Connection
cn.Open "PROVIDER=MICROSOFT.Jet.OLEDB.4.0;Data Source=D:\Version\VB_code\UDP-2\DataBase\Switch_Data.mdb;"
sql = "insert into 上传数据(数据) values ('" & Trim(Text1.Text) & "')"
cn.Execute sql, n
MsgBox "记录添加成功!", vbOKOnly + vbInformation, "提示"
Text1.Text = ""
cn.Close Set cn = NothingEnd Sub
现在想实现:
使用一个命令按钮,点击该命令按钮display,将这个数据库中的表显示在文本框display_text中。
该怎么实现呢
请高手指教!
Dim cn As adodb.Connection Dim n As Long
Set cn = New adodb.Connection
cn.Open "PROVIDER=MICROSOFT.Jet.OLEDB.4.0;Data Source=D:\Version\VB_code\UDP-2\DataBase\Switch_Data.mdb;"
sql = "insert into 上传数据(数据) values ('" & Trim(Text1.Text) & "')"
cn.Execute sql, n
MsgBox "记录添加成功!", vbOKOnly + vbInformation, "提示"
Text1.Text = ""
cn.Close Set cn = NothingEnd Sub
现在想实现:
使用一个命令按钮,点击该命令按钮display,将这个数据库中的表显示在文本框display_text中。
该怎么实现呢
请高手指教!
解决方案 »
- 已经获取其他程序的控件句柄,怎么根据句柄获取控件visible和enable属性
- 很奇怪的问题。关于msflexgrid显示excel!
- 为什么读日文时会有乱码?
- 现在论坛的积分要怎么才能增加呢,以前是一天登陆一次增加10分,现在呢,我怎么每次登陆分数都不变啊?谢谢
- MediaPlayer 控件 播放AVI文件 如何改变显示图像的长宽比例???(十万火急!!)
- 请帮我讲一下这段vbscript的含义?
- 大家讨论一下:如何把一个长字符串变成十六进制,散分--散分--散分--50
- 我来了
- 从设想开始(关于报表)
- 急,,help me !!!
- 使用winsock后退出程序很慢
- VBWinsock下载文件问题
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) http://feiyun0112.cnblogs.com/
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
'函数功能:连接指定的数据库
'参数说明:cnnP:数据库连接对象;
' :adoP:数据集存储对象;
' :strPath:数据库路径;
' :strPassword:数据库密码;
'返回说明:True:连接成功 False:连接失败
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Public Function funConnectDataBase(cnnP As ADODB.Connection, adoP As ADODB.Recordset, ByVal strPath As _
String, ByVal strPassword As String) As Boolean
On Error GoTo errFunction
Set cnnP = New ADODB.Connection
Set adoP = New ADODB.Recordset
cnnP.Provider = "Microsoft.Jet.OLEDB.4.0"
cnnP.Open "Data Source = " & strPath & ";jet oledb:database password=" & strPassword
funConnectDataBase = True
Exit Function
errFunction:
funConnectDataBase = False
End Function
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
'函数功能:关闭数据库连接对象和数据文件的关联
'参数说明:cnnP:数据库连接对象;
' :adoP:数据库存储对象;
'返回说明:True:关闭连接成功 False:关闭连接失败
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Public Function funCloseDataBase(cnnP As ADODB.Connection, adoP As ADODB.Recordset) As Boolean
On Error GoTo errFunction
Set adoP = Nothing
Set cnnP = Nothing
funCloseDataBase = True
Exit Function
errFunction:
funCloseDataBase = False
End Function
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
'过程功能:对指定的对象执行指定的SQL语句
'参数说明:cnnP:ADO连接对象
' :adoP:ADO记录集对象
' :strSql:SQL语句
' :bolQueryRecord:是否是查询记录集
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Public Sub subExcuteSQL(cnnP As ADODB.Connection, adoP As ADODB.Recordset, strSql As String, bolQueryRecord _
As Boolean)
If bolQueryRecord Then '如果是查询记录集
adoP.Open strSql, cnnP, adOpenStatic, adLockBatchOptimistic
Else
cnnP.Execute strSql
End If
End Sub
提示field没有必选参数
怎办呢
Dim strSQL As String
strSQL = "select 字段 from 数据表 where 字段='" + ??+ "'" '你要显示那个字段的数据
Obj.Open '连接数据库对象
If Obj.State = adStateOpen Then
RS.Open strSQL, Obj, adOpenDynamic, adLockBatchOptimistic ‘Rs是记录集
If RS.EOF Then
MsgBox "没有你想要的数据"
RS.Close
Else
Text1.Text = RS.Fields("字段").Value '关键就是这句
RS.Close
End If
End If
祝你成功!!!