Going Nuts Trying To Do This

Im going completly nuts trying to do this. In ASP it would have taken me seconds.





Ok I think this is right but correct me if im wrong





I have a class that for example has a function that gets all the states from the DB:





File called Class.vb





Imports System


Imports System.Data


Imports System.Data.SqlClient


Imports System.Collections


Imports System.Configuration








Public Class Getalldata


Public Function GetPicdata() As SqlDataReader





Dim cnn As New SqlConnection(ConfigurationSettings.AppSettings("CONNECTION_STRING_USER"))


Dim cmd As New SqlCommand("Get_states", cnn)








cnn.Open()


Dim result As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)


cnn.Close()





End Function


End Class





Ok How in the hell do I call this just to LOOP and print them out????








Sort of like this





Call class/object/whatever. I dont know how





Then





While Whaever





Loops thru the states response.writting them





Loop





Please hel;p before I completly go nuts