一段vb程序,两个问题,一个是DataGrid的邦定,一个是连接远程数据库
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写数据库程序,很多还不是很明白,请大家帮帮忙