Dim mySql As String
Set myConn = New ADODB.Connection
myConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Pwd=laputa;Initial Catalog=qf_sdwj;Data Source=\\192.168.1.33\laputa;packet size=4096"
myConn.Open
Set myRecord = New ADODB.Recordset
mySql = "select ID,UserName,Company,Address,Postalcode,Network,B1,ReadDate,LoginName,Password,ValidDate,pc from u_user_sdwj where " & Combo1.Text & " like '" & Trim(searchtext.Text) & "'"
myRecord.Open mySql, myConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = myRecord
DataGrid1.Refresh
myConn.Close
数据库在服务器上,我这个样子写Data Source=\\192.168.1.33\laputa访问不到数据库,想问一下,远程连接数据库怎么做。
Set DataGrid1.DataSource = myRecord,DataGrid绑定不显示,提示实时错误“7004”,行集合不能作为标签,想请教一下DataGrid的绑定怎么写。谢谢
我第一次用vb6写数据库程序,很多还不是很明白,请大家帮帮忙
Set myConn = New ADODB.Connection
myConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Pwd=laputa;Initial Catalog=qf_sdwj;Data Source=\\192.168.1.33\laputa;packet size=4096"
myConn.Open
Set myRecord = New ADODB.Recordset
mySql = "select ID,UserName,Company,Address,Postalcode,Network,B1,ReadDate,LoginName,Password,ValidDate,pc from u_user_sdwj where " & Combo1.Text & " like '" & Trim(searchtext.Text) & "'"
myRecord.Open mySql, myConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = myRecord
DataGrid1.Refresh
myConn.Close
数据库在服务器上,我这个样子写Data Source=\\192.168.1.33\laputa访问不到数据库,想问一下,远程连接数据库怎么做。
Set DataGrid1.DataSource = myRecord,DataGrid绑定不显示,提示实时错误“7004”,行集合不能作为标签,想请教一下DataGrid的绑定怎么写。谢谢
我第一次用vb6写数据库程序,很多还不是很明白,请大家帮帮忙
myConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Pwd=laputa;Initial Catalog=qf_sdwj;Data Source=192.168.1.33;packet size=4096"
----------------------
绑定的代码没错,不过用DataGrid来显示数据时,需要设置客户端游标,否则会报你所描述的错误:......
myRecord.CursorLocation=adUseClient '打开记录集前先设置客户端游标
myRecord.Open mySql, myConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = myRecord
DataGrid1.Refresh
'myConn.Close '<---------注意,这句必须注释掉,否则你是看不到数据的
......DataGrid显示数据的时候,不能把记录集关闭,也不能把数据库连接关闭,否则DataGrid不显示数据
myConn.ConnectionString = "Provider=SQLOLEDB.1;Password=laputa;Persist Security Info=False;User ID=sa;Initial Catalog=qf_sdwj;Data Source=192.168.1.33"
Dim Rs As New ADODB.Recordset
Dim ConnStr, SSql As String
Dim I As Integer
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\192.168.1.1\共享文件夹名\Test.mdB" & ";Persist Security Info=False"
'Conn.Open
Rs.CursorLocation = adUseClient
Rs.Open "Select * From TB", ConnStr, adOpenStatic, adLockOptimistic, adCmdText