Imports System.Data.SqlClient Public Class ListViewData Public Sub FillListView(ByRef MyListView As ListView, _ ByRef myData As SqlDataReader) Dim lvwColumn As ColumnHeader Dim itmListItem As ListViewItem Dim strTest As String Dim shtCntr As Short MyListView.Clear() For shtCntr = 0 To myData.FieldCount() - 1 lvwColumn = New ColumnHeader() lvwColumn.Text = myData.GetName(shtCntr) MyListView.Columns.Add(lvwColumn) Next Do While myData.Read itmListItem = New ListViewItem() strTest = IIf(myData.IsDBNull(0), "", myData.GetString(0)) itmListItem.Text = strTest For shtCntr = 1 To myData.FieldCount() - 1 If myData.IsDBNull(shtCntr) Then itmListItem.SubItems.Add("") Else itmListItem.SubItems.Add(myData.GetString(shtCntr)) End If Next shtCntr MyListView.Items.Add(itmListItem) Loop End Sub End Class
toString()
Convert.ToString()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)