I use the below code to store SqlDataReader data in ArrayList as objects, and I couldn't know how to retrieve the data stored in Row1 Column3 as string, can anyone help please?
Dim myReader As SqlDataReader
myReader = mySqlCommand.ExecuteReader() 'Retrieve Data from SQL Server
If myReader.HasRows Then
Dim myArrayList As New ArrayList()
While myReader.Read()
Dim values(myReader.FieldCount - 1) As Object
Dim fieldCount As Integer = myReader.GetValues(values)
myReader.GetValues(values) 'Get the Row with all its column values
myArrayList.Add(values) 'Add this Row to ArrayList
End While
End if
Dim myReader As SqlDataReader
myReader = mySqlCommand.ExecuteReader() 'Retrieve Data from SQL Server
If myReader.HasRows Then
Dim myArrayList As New ArrayList()
While myReader.Read()
Dim values(myReader.FieldCount - 1) As Object
Dim fieldCount As Integer = myReader.GetValues(values)
myReader.GetValues(values) 'Get the Row with all its column values
myArrayList.Add(values) 'Add this Row to ArrayList
End While
End if