使用VB+SQL做C/S系统时.使用Adodc+DataGrid动态绑定数据表,不知道为什么只能在本机显示数据,在其它机上没有数据呢?其它数据都正常.就差这一个地方了.哪位高手帮帮俺.3Q~~`动态绑定:
adoLXX.ConnectionString = CN.ConnectionString
adoLXX.CommandType = adCmdText
adoLXX.RecordSource = "Select * From test Where lh='02480001' Order By id"
adoLXX.Refresh
adoLXX.ConnectionString = CN.ConnectionString
adoLXX.CommandType = adCmdText
adoLXX.RecordSource = "Select * From test Where lh='02480001' Order By id"
adoLXX.Refresh
dim strsql as string
if rs.state=adstateopen then rs.close
strsql=" select * from test where lh='02480001' order by id"
rs.open strsql,cn,adopenkeyset,adlockreadonly
set datagrid.datasource=rs
rs.close
set rs=nothing
con.CursorLocation = adUseClient
con.Open
Option ExplicitPrivate Sub Form_Load()
With Me.Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Man.mdb;Persist Security Info=False"
.RecordSource = "select * from Man"
Set Me.DataGrid1.DataSource = Me.Adodc1
End With
End Sub这样样子就可以了