If Forms("商品列表").Opened Then Dim lvesp As WinForm.ListView = Forms("商品列表").Controls("ListView2") lvesp.StopRedraw lvesp.Rows.Clear lvesp.Columns.Clear lvesp.View = ViewMode.Details lvesp.GridLines = True '显示网格线 Dim cls() As String = {"商品编码","商品名称","单位","单价","不参与折扣","拼音简写"} '定义列名 Dim wds() As String = {100,100,100,100,100,100} '定义列宽 For i As Integer = 0 To cls.Length - 1 '增加列 Dim c As WinForm.ListViewColumn = lvesp.Columns.Add() c.Text = cls(i) '指定列标题 c.Name = cls(i) '指定列名 c.Width = wds(i) '指定列宽 Next For Each dr As DataRow In DataTables("商品列表").DataRows '从数据表中提取数据 Dim vr As WinForm.ListViewRow = lvesp.Rows.Add() '增加一行 For Each cl As String In cls '逐列取值 vr(cl) = dr(cl) Next vr.Tag= dr '将DataRow赋值给ListViewRow的Tag属性,将二者联系起来 Next lvesp.ResumeRedraw() '恢复绘制 End If
|