请问:datarepeater控件的DataSouce属性一定要设置成Adodc1吗,我想将DataSouce属性设置成Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
SQLtxt = "Select * from pub_info"
rs=Connect(SQLtxt)set DataRepeater1.DataSouce = rs
但是得不到显示的数据如果增加控件Adodc1,设置好连接后
set DataRepeater1.DataSouce = Adodc1
就可以显示数据为什么?而且我用前面的
SQLtxt = "Select * from pub_info"
rs=Connect(SQLtxt)方式可以将数据读到text这类的控件里
Set rs = New ADODB.Recordset
SQLtxt = "Select * from pub_info"
rs=Connect(SQLtxt)set DataRepeater1.DataSouce = rs
但是得不到显示的数据如果增加控件Adodc1,设置好连接后
set DataRepeater1.DataSouce = Adodc1
就可以显示数据为什么?而且我用前面的
SQLtxt = "Select * from pub_info"
rs=Connect(SQLtxt)方式可以将数据读到text这类的控件里
set DataRepeater1.DataSouce = rs
db.CursorLocation = adUseClient
db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=newdb;uid=shenghuo;pwd=shenghuo" Set rs = New ADODB.Recordset
strsql = "select * from table"
rs.Open strsql, db, adOpenDymanic, adLockBatchOptimistic
set DataRepeater1.DataSouce =rs
Dim con As adodb.Connection
Dim rs As adodb.RecordsetPrivate Sub Form_Load()
Set rs = New adodb.Connection
Set con = New adodb.Recordset[[con.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=mrmt;Data Source=N091"
con.CursorLocation = adUseClient
con.Open]]rs.Open "select name from yuangong where bianhao ='" & Text1.Text & "'", con, adOpenKeyset, adLockOptimisticSet Datagrid.dataSource = rs
End Sub注意括号里面的代码, ""里面的代码可以不用写, 你加一个ado控件上去连接上数据库然后把那段代码copy下来