数据库JP_sTrainSite中TSiteName字段的值要写入combo1中
我的代码是
Private Sub Combo1_Click()
Dim ConnTemp As New ADODB.Connection
Dim RsTemp As New ADODB.Recordset
Dim StrTemp As String
'Set ConnTemp = New ADODB.Connection
ConnTemp.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=JiapeiSys;Data Source=SOFTSERVER"
ConnTemp.Open
StrTemp = "select TSiteName from JP_sTrainSite"
Set RsTemp = New ADODB.Recordset
With RsTemp
.CursorType = 3
.LockType = 3
.Open StrTemp, ConnTemp
End With
Combo1.Clear
Do Until RsTemp.EOF
StrTemp = RsTemp.Fields("TSiteName")
Combo1.AddItem StrTemp
RsTemp.MoveNext
Loop
End Sub运行以后点击combo1的按钮不激发这个事件,是什么原因呢?
我的代码是
Private Sub Combo1_Click()
Dim ConnTemp As New ADODB.Connection
Dim RsTemp As New ADODB.Recordset
Dim StrTemp As String
'Set ConnTemp = New ADODB.Connection
ConnTemp.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=JiapeiSys;Data Source=SOFTSERVER"
ConnTemp.Open
StrTemp = "select TSiteName from JP_sTrainSite"
Set RsTemp = New ADODB.Recordset
With RsTemp
.CursorType = 3
.LockType = 3
.Open StrTemp, ConnTemp
End With
Combo1.Clear
Do Until RsTemp.EOF
StrTemp = RsTemp.Fields("TSiteName")
Combo1.AddItem StrTemp
RsTemp.MoveNext
Loop
End Sub运行以后点击combo1的按钮不激发这个事件,是什么原因呢?
你可以单独写一个过程然后在窗口的load事件中调用
可以用窗休的load事件。