Member Avatar for dot_net_rookie

Hi,
How can i pass values from datareader to arraylist..Can anyone help me please...

connString = ConfigurationManager.ConnectionStrings("conn_proj").ToString
        objConnection = New OdbcConnection(connString)
        objConnection.Open()
        Dim myCommand As OdbcCommand
        Dim pgcount_SQL As String
        pgcount_SQL = "Select count(M_PAGES_ID_PK) from mast_pages_tbl"
        Response.Write(pgcount_SQL)
        myCommand = New OdbcCommand(pgcount_SQL, objConnection)
        Dim objReader As OdbcDataReader = myCommand.ExecuteReader()
.
.
.
.
.


        objConnection.Close()
  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by samir_ibrahim
Member Avatar for samir_ibrahim

Hi,
How can i pass values from datareader to arraylist

I did not see any arraylist declaration in your code? but you can access the datareader as array if that help.

For I = 1 to objReader.RecordsAffected
    Debug.Print(objReader(I))
Next I
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.