Dim itemX As ListItem
ListView1.ListItems.Clear
rs.Open "select * from " + tv1.SelectedItem.Text, conn
For icol = 0 To rs.Fields.Count - 1
Set itemX = ListView1.ListItems.Add(, , icol + 1)
itemX.SubItems(1) = rs.Fields(icol).Name
itemX.SubItems(2) = rs.Fields(icol).Type
itemX.SubItems(3) = rs.Fields(icol).DefinedSize
itemX.SubItems(4) = Iif(rs.Fields(icol).Attributes And adFldIsNullable , "Y", "N")
Next icol
rs.Close
ListView1.ListItems.Clear
rs.Open "select * from " + tv1.SelectedItem.Text, conn
For icol = 0 To rs.Fields.Count - 1
Set itemX = ListView1.ListItems.Add(, , icol + 1)
itemX.SubItems(1) = rs.Fields(icol).Name
itemX.SubItems(2) = rs.Fields(icol).Type
itemX.SubItems(3) = rs.Fields(icol).DefinedSize
itemX.SubItems(4) = Iif(rs.Fields(icol).Attributes And adFldIsNullable , "Y", "N")
Next icol
rs.Close
解决方案 »
- vb两个问题,请高手指点
- 我有FROM1和CMDLOGIN 2个窗体 我要将第2个窗体中的一个变量数值传递到第1个窗体中该如何操作?
- xp 菜单控件排名
- 谁数据库里的 Session 的资料,借看一下,小弟感激不尽。。。。。
- 急!100分求教,用StretchBlt怎么不能将一个picturebox上的图像拷贝到另一个picture上呢?
- 关于闸机的编程代码,有高手写过么?
- ====看不懂例程!!
- 记录修改后如何保存?
- 相对路径
- 针对Winsock控件的代码,放在模块里运行时,会出现“实时错误’-2147417848(80010108)”,然后VB程序就自己关闭了。
- 请教如何让textbox对keypress免疫?
- 求一个vb备份Access的代码的例子!
Dim itemx As ListItem
Set itemx = ListView1.SelectedItem
If itemx Is Nothing Then Exit Sub
If itemx.Index >= ListView1.ListItems.Count Then Exit Sub
ListView1.ListItems.Item(itemx.Index + 1).Selected = True
ListView1.SetFocus
End SubPrivate Sub Command2_Click()
Dim itemx As ListItem
Set itemx = ListView1.SelectedItem
If itemx Is Nothing Then Exit Sub
If itemx.Index <= 1 Then Exit Sub
ListView1.ListItems.Item(itemx.Index - 1).Selected = True
ListView1.SetFocus
End SubPrivate Sub Command3_Click()
ListView1.ListItems.Item(1).Selected = True
ListView1.SetFocus
End SubPrivate Sub Command4_Click()
ListView1.ListItems.Item(ListView1.ListItems.Count).Selected = True
ListView1.SetFocus
End SubPrivate Sub Form_Load()
Dim itemx As ListItem
With ListView1
.ColumnHeaders.Add , , "序号"
.ColumnHeaders.Add , , "文件路径及名称"
.FullRowSelect = True
.GridLines = True
Set itemx = .ListItems.Add(, , "1")
itemx.SubItems(1) = "c:\db.txt"
Set itemx = .ListItems.Add(, , "2")
itemx.SubItems(1) = "c:\1.bmp"
Set itemx = .ListItems.Add(, , "3")
itemx.SubItems(1) = "c:\db.txt"
Set itemx = .ListItems.Add(, , "4")
itemx.SubItems(1) = "c:\1.bmp"
Set itemx = .ListItems.Add(, , "5")
itemx.SubItems(1) = "c:\db.txt"
Set itemx = .ListItems.Add(, , "6")
itemx.SubItems(1) = "c:\1.bmp"
.View = lvwReport
End With
Command1.Caption = "下移"
Command2.Caption = "上移"
Command3.Caption = "置顶"
Command4.Caption = "置底"
End Sub
Private Sub Command1_Click()
Dim strTemp As String
If ListView1.ListItems.Count = 0 Then Exit Sub
If ListView1.SelectedItem.Index < ListView1.ListItems.Count Then
strTemp = ListView1.SelectedItem.Text
ListView1.SelectedItem.Text = ListView1.ListItems(ListView1.SelectedItem.Index + 1).Text
ListView1.ListItems(ListView1.SelectedItem.Index + 1).Text = strTemp
ListView1.ListItems(ListView1.SelectedItem.Index + 1).Selected = True
ListView1.SelectedItem.EnsureVisible
End If
End Sub'Previous
Private Sub Command2_Click()
Dim strTemp As String
If ListView1.ListItems.Count = 0 Then Exit Sub
If ListView1.SelectedItem.Index <> 1 Then
strTemp = ListView1.SelectedItem.Text
ListView1.SelectedItem.Text = ListView1.ListItems(ListView1.SelectedItem.Index - 1).Text
ListView1.ListItems(ListView1.SelectedItem.Index - 1).Text = strTemp
ListView1.ListItems(ListView1.SelectedItem.Index - 1).Selected = True
ListView1.SelectedItem.EnsureVisible
End If
End Sub'First
Private Sub Command3_Click()
Dim strTemp As String
If ListView1.ListItems.Count = 0 Then Exit Sub
If ListView1.SelectedItem.Index <> 1 Then
strTemp = ListView1.SelectedItem.Text
ListView1.SelectedItem.Text = ListView1.ListItems(1).Text
ListView1.ListItems(1).Text = strTemp
ListView1.ListItems(1).Selected = True
ListView1.SelectedItem.EnsureVisible
End If
End Sub'Last
Private Sub Command4_Click()
Dim strTemp As String
If ListView1.ListItems.Count = 0 Then Exit Sub
If ListView1.SelectedItem.Index <> ListView1.ListItems.Count Then
strTemp = ListView1.SelectedItem.Text
ListView1.SelectedItem.Text = ListView1.ListItems(ListView1.ListItems.Count).Text
ListView1.ListItems(ListView1.ListItems.Count).Text = strTemp
ListView1.ListItems(ListView1.ListItems.Count).Selected = True
ListView1.SelectedItem.EnsureVisible
End If
End SubPrivate Sub Form_Load()
ListView1.ColumnHeaders.Add , , "Fields"
ListView1.ListItems.Add , , "123"
ListView1.ListItems.Add , , "456"
ListView1.ListItems.Add , , "789"
ListView1.HideSelection = False
End Sub简单的写了一下,你自己完善吧。^_^
顶一下算了