Can you see where the error is in this? Dim team As String
Public Sub New(ByVal teamName As String)
team = teamName
End Sub
Private Sub frmRosterView_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim listViewItems As New ListViewItem()
lvwPlayers.View = View.Details
lvwPlayers.GridLines = True
lvwPlayers.Columns.Add("First", 100, HorizontalAlignment.Left)
lvwPlayers.Columns.Add("Last", 100, HorizontalAlignment.Left)
lvwPlayers.Columns.Add("Address", 100, HorizontalAlignment.Left)
lvwPlayers.Columns.Add("City", 100, HorizontalAlignment.Left)
lvwPlayers.Columns.Add("State", 100, HorizontalAlignment.Left)
lvwPlayers.Columns.Add("ZIP", 50, HorizontalAlignment.Left)
Dim mySelectQuery As String = "SELECT * FROM tmPlayerInfo WHERE Team = teamName"
Dim myConnection As New SqlConnection("server=localhost;database=StatKeeper;Trusted_Connection=yes")
Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
While myReader.Read()
listViewItems.Text = myReader.GetValue(2)
listViewItems.SubItems.Add(myReader.GetValue(3))
listViewItems.SubItems.Add(myReader.GetValue(4))
listViewItems.SubItems.Add(myReader.GetValue(5))
listViewItems.SubItems.Add(myReader.GetValue(6))
listViewItems.SubItems.Add(myReader.GetValue(7))
lvwPlayers.Items.Add(listViewItems)
listViewItems = New ListViewItem()
End While
myReader.Close()
myConnection.Close()
End Sub It says that lvwPlayers.View = View.Details is a null exception. And I have a listview on my form named lvwPlayers.