1,451
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
frankwong 2003-08-18
- 打赏
- 举报
符合以上两个条件应该是msflexgrid控件,listview和list没有绑定
lihonggen0 2003-08-18
- 打赏
- 举报
用listview或者list
作多选
Dim Item As ListItem
ListView1.CheckBoxes = True
ListView1.View = lvwReport
ListView1.ColumnHeaders.Add , , "代码", ListView1.Width / 2
ListView1.ColumnHeaders.Add , , "真实值", ListView1.Width / 2
Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=Report;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from table1", CN, adOpenDynamic, adLockBatchOptimistic
Rs.MoveFirst
Do While Not Rs.EOF
Set Item = ListView1.ListItems.Add(, , Trim(Rs.Fields("lno")))
Item.ListSubItems.Add , , Trim(Rs.Fields("lname"))
Rs.MoveNext
Loop
作多选
Dim Item As ListItem
ListView1.CheckBoxes = True
ListView1.View = lvwReport
ListView1.ColumnHeaders.Add , , "代码", ListView1.Width / 2
ListView1.ColumnHeaders.Add , , "真实值", ListView1.Width / 2
Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=Report;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from table1", CN, adOpenDynamic, adLockBatchOptimistic
Rs.MoveFirst
Do While Not Rs.EOF
Set Item = ListView1.ListItems.Add(, , Trim(Rs.Fields("lno")))
Item.ListSubItems.Add , , Trim(Rs.Fields("lname"))
Rs.MoveNext
Loop
