CN.ConnectionString = "Provider=sqloledb;Data Source=SYSTEM;Initial Catalog=tagj_mis;User Id=sa;Password=1;"
CN.Open rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
Set rs = CN.Execute("EXEC GETLINE_INFO")
Set TDBCombo1.RowSource = rs
TDBCombo1.ReBind
TDBCombo1.Refresh
为何结果不显示,我发现如果RS的记录集类型不是存储过程,而是SELECT *FROM LINE_INFO就可以,WHY,请帮帮忙
是不是存储过程的记录集的类型不同
CN.Open rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
Set rs = CN.Execute("EXEC GETLINE_INFO")
Set TDBCombo1.RowSource = rs
TDBCombo1.ReBind
TDBCombo1.Refresh
为何结果不显示,我发现如果RS的记录集类型不是存储过程,而是SELECT *FROM LINE_INFO就可以,WHY,请帮帮忙
是不是存储过程的记录集的类型不同
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=abrams;Initial Catalog=salestesttmp;User Id=sa;Password=test;"
CN.Open Rs.CursorLocation = adUseClient
Rs.CursorType = adOpenDynamic
Rs.LockType = adLockOptimistic
Set Rs = CN.Execute("EXEC spGetTreeVar 1")
Set DBCombo1.DataSource = Rs
DBCombo1.DataField = Rs.Fields(0).Name
DBCombo1.ReFill