1,216
社区成员
发帖
与我相关
我的任务
分享
Private Sub Form_Load()
Dim conn As New ADODB.Connection
Dim rs As New Recordset
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=database;Initial Catalog=Winnie;Data Source=192.168.18.195"
rs.Open "select empname from whemployeeinfor", conn
rs.MoveFirst
Do While Not rs.EOF
Combo1.AddItem rs.Fields("empname").Value
rs.MoveNext
Loop
rs.Close
End Sub
[code=VB]FrmOverTime.Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=database;Initial Catalog=winnie;Data Source=192.168.18.195"
FrmOverTime.Adodc1.RecordSource = "sql"
FrmOverTime.Adodc1.Refresh
Set MSHFlexGrid1.DataSource = Adodc1
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=database;Initial Catalog=winnie;Data Source=192.168.18.195"
Set rs = conn.Execute("sql")
Set MSHFlexGrid1.DataSource = rs
MSHFlexGrid1.Refresh
[/code]