浏览.vb

这是本人设计的一个软件

Imports System.Data.SqlClient
Public Class 浏览
    Inherits System.Windows.Forms.Form

    Dim mytab As New DataTable
#Region " Windows 窗体设计器生成的代码 "

    Public Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()

        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写 dispose 以清理组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Windows 窗体设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意: 以下过程是 Windows 窗体设计器所必需的
    '可以使用 Windows 窗体设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents ContextMenu1 As System.Windows.Forms.ContextMenu
    Friend WithEvents bigicon As System.Windows.Forms.ImageList
    Friend WithEvents smallicon As System.Windows.Forms.ImageList
    Friend WithEvents ListView1 As System.Windows.Forms.ListView
    Friend WithEvents MenuItem1 As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem2 As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem3 As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem4 As System.Windows.Forms.MenuItem
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container
        Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(浏览))
        Me.bigicon = New System.Windows.Forms.ImageList(Me.components)
        Me.smallicon = New System.Windows.Forms.ImageList(Me.components)
        Me.ContextMenu1 = New System.Windows.Forms.ContextMenu
        Me.MenuItem1 = New System.Windows.Forms.MenuItem
        Me.MenuItem2 = New System.Windows.Forms.MenuItem
        Me.MenuItem3 = New System.Windows.Forms.MenuItem
        Me.MenuItem4 = New System.Windows.Forms.MenuItem
        Me.ListView1 = New System.Windows.Forms.ListView
        Me.SuspendLayout()
        '
        'bigicon
        '
        Me.bigicon.ImageSize = New System.Drawing.Size(32, 32)
        Me.bigicon.ImageStream = CType(resources.GetObject("bigicon.ImageStream"), System.Windows.Forms.ImageListStreamer)
        Me.bigicon.TransparentColor = System.Drawing.Color.Transparent
        '
        'smallicon
        '
        Me.smallicon.ImageSize = New System.Drawing.Size(16, 16)
        Me.smallicon.ImageStream = CType(resources.GetObject("smallicon.ImageStream"), System.Windows.Forms.ImageListStreamer)
        Me.smallicon.TransparentColor = System.Drawing.Color.Transparent
        '
        'ContextMenu1
        '
        Me.ContextMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem1, Me.MenuItem2, Me.MenuItem3, Me.MenuItem4})
        '
        'MenuItem1
        '
        Me.MenuItem1.Index = 0
        Me.MenuItem1.Text = "大图标"
        '
        'MenuItem2
        '
        Me.MenuItem2.Index = 1
        Me.MenuItem2.Text = "小图标"
        '
        'MenuItem3
        '
        Me.MenuItem3.Index = 2
        Me.MenuItem3.Text = "列表"
        '
        'MenuItem4
        '
        Me.MenuItem4.Index = 3
        Me.MenuItem4.Text = "详细资料"
        '
        'ListView1
        '
        Me.ListView1.Anchor = CType((((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Bottom) _
                    Or System.Windows.Forms.AnchorStyles.Left) _
                    Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
        Me.ListView1.ContextMenu = Me.ContextMenu1
        Me.ListView1.LargeImageList = Me.bigicon
        Me.ListView1.Location = New System.Drawing.Point(0, 0)
        Me.ListView1.Name = "ListView1"
        Me.ListView1.Size = New System.Drawing.Size(408, 264)
        Me.ListView1.SmallImageList = Me.smallicon
        Me.ListView1.TabIndex = 0
        '
        '浏览
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(408, 303)
        Me.Controls.Add(Me.ListView1)
        Me.Name = "浏览"
        Me.Text = "浏览"
        Me.ResumeLayout(False)

    End Sub

#End Region



#Region "窗体载入事件"

    Private Sub 浏览_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim dc As SqlDataAdapter
        mycon.Open()

        dc = New SqlDataAdapter("select * from 宿舍管理", mycon)

        dc.Fill(mytab)
        mycon.Close()
        look()



    End Sub

#End Region

#Region "显示用的子程序"
    Sub look()
        ListView1.Items.Clear()
        Dim myr As DataRow
        Dim i As Integer
        For Each myr In mytab.Rows
            Dim ti As New ListViewItem
            ti.Text = myr(0)
            ti.ImageIndex = i
            i += 1
            ListView1.Items.Add(ti)
        Next
    End Sub

#End Region

#Region "加入标题子程序"

    Sub addtitle(ByVal str() As String)
        ListView1.Columns.Clear()
        ListView1.View = View.Details
        Dim ss As String
        Dim myCol As New ColumnHeader
        For Each ss In str
            myCol = New ColumnHeader
            myCol.Text = ss
            ListView1.Columns.Add(myCol)
        Next
    End Sub

#End Region

#Region "加入数据子程序"

    Sub havedata()
        Dim myrow As DataRow
        For Each myrow In mytab.Rows
            Dim myVal(mytab.Columns.Count - 1) As String
            Dim i As Integer
            For i = 0 To UBound(myVal)
                myVal(i) = myrow(i)
            Next
            Dim myListItem As New ListViewItem(myVal)
            ListView1.Items.Add(myListItem)
        Next
    End Sub

#End Region


#Region "右键菜单的代码"

    Private Sub MenuItem1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
        ListView1.View = View.LargeIcon                  '---------显示大图标
        look()
    End Sub

    Private Sub MenuItem2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
        ListView1.View = View.SmallIcon               '--------------显示小图标
        look()
    End Sub

    Private Sub MenuItem3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
        ListView1.View = View.List                '------------------显示列表模式
        look()
    End Sub

    Private Sub MenuItem4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MenuItem4.Click
        Dim a(mytab.Columns.Count - 1) As String                     '-----------显示详细信息模式
        Dim b As Integer
        For b = 0 To UBound(a)
            a(b) = mytab.Columns.Item(b).ColumnName
        Next
        ListView1.Items.Clear()
        addtitle(a)
        havedata()

    End Sub

#End Region


End Class