Adding to Listview

[tehon3299]

I need to get all the items under a certain column in SQL and add them all to a Listview. How would I do this?

 

I know how to connect to SQL and add things to listview's but I don't know how to add them when it's from SQL.

[Derek Stone]

The method depends on the ADO.NET code you're using. We'll need to see whether you're using a DataSet or a DataReader, among various other options.

[tehon3299]

This is the code I am using:

        Dim MyCommand As New SqlCommand()
       Dim MyConnection As New SqlConnection()
       Dim MySQLDataAdapter As New SqlDataAdapter()
       Dim SessionCmd As String

       MyConnection = New SqlConnection("server=(local);database=StatKeeper;Trusted_Connection=yes")

       SessionCmd = "Select (TeamName) FROM tmTeams"

       MyCommand = New SqlCommand(SessionCmd, MyConnection)

       MyCommand.Connection.Open()

       Try
           MyCommand.ExecuteNonQuery()
       Catch Exp As SqlException
           If Exp.Number = 2627 Then

           Else

           End If
       End Try

       MyCommand.Connection.Close()