vb 连接sql2000是不是一定要使用odbc ,使用了odbc有什么好处,是不是就可以访问不同的商业数据库了?谢谢大家!
解决方案 »
- VB6.0中怎样对网页源代码中的网址进行模糊匹配?
- 如何用VB6删除其它程序留在任务栏的图标!
- vb调用编辑word文档的问题
- 有哪位大哥用过VSFlexGrid控件么?听说很不错,但是我用的时候发现有个很不方便的地方,不知道是不是它本身的缺陷!
- 高手大哥们,帮我看看看这好玩意!!大家肯定很感兴趣.....
- [[[[[[[[[ 菜菜问题 ]]]]]]]]]]]
- vb如何连db2接数据库?在线等。
- 为什么我发的帖子在论坛上看不到?而且两天都没有人回答?这不可能吧
- 请问在VB中如何实现让程序定时自动运行?
- VB 如何 创建数据库用户帐号!
- SetupFactory的文件注册问题
- 急啊,关于水晶报表的问题!
Dim rs As New ADODB.Recordset, cn As New ADODB.Connection'在MSHFLEXGRID表格控件中显示查询到的内容
Private Sub Command1_Click()
If rs.State = adStateOpen Then rs.Close
rs.Open "SELECT * FROM USERPASSWORD", cn, adOpenDynamic, adLockOptimistic
Set MSHFlexGrid1.DataSource = rs
End Sub'向数据库中添加数据
Private Sub Command2_Click()
If rs.State = adStateOpen Then rs.Close
rs.Open "SELECT * FROM USERPASSWORD", cn, adOpenDynamic, adLockOptimistic
rs.AddNew
rs!UID = txtUid.Text
rs!PWD = txtPwd.Text
rs!TRUENAME = txtName.Text
rs!CREATEDATE = Format(Now, "YYYY/MM/DD")
rs.Update
Command1.Value = True
End Sub'从数据库中删除数据
Private Sub Command3_Click()
cn.Execute "DELETE FROM USERPASSWORD WHERE UID = '" & txtUid.Text & "'"
Command1.Value = True
End SubPrivate Sub Command4_Click()
With MSHFlexGrid1
Clipboard.SetText .Text
End With
End SubPrivate Sub Command5_Click()
With MSHFlexGrid1
.Text = Clipboard.GetText
End With
End SubPrivate Sub Form_Load()
cn.ConnectionString = "DBQ=" & App.Path & "\TelePhone.mdb;DefaultDir=" & _
App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & _
"DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & _
"MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & _
"Threads=3;UID=ADMIN;UserCommitSync=Yes;PWD=admind1234;"
cn.Open
'查询字符串可以上这里查
'http://www.connectionstrings.com/
End SubPrivate Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
On Error Resume Next
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End SubPrivate Sub MSHFlexGrid1_RowColChange()
With MSHFlexGrid1
'MsgBox .TextMatrix(.Row, .Col)
End With
End Sub