I am writing a vb.net application. The application pulls a query from a database via ODBC. I will want to look at the results of that query more than once as I compare various things against the values within it.
I figured I would create a two dimensional array and then populate each "row" of the array with the fifteen returned ordinals - and then I can run a for..next loop to iterate through the array as many times as I need.
But I can't seem to get my head aroudn arrays in vb.net.
Can someone please explain how I can create, populate and then read a two dimensional array?
I have put below the code which I have so far - which simply echoes each field of each row out on to the screen.
'strcol1 = dbreader.GetString(dbreader.GetOrdinal("cpd-desc"))
'strcol2 = dbreader.GetString(dbreader.GetOrdinal("rate-region"))
'strcol3 = dbreader.GetString(dbreader.GetOrdinal("rateid"))
'Console.WriteLine(strcol1 & " - " & strcol2 & " - " & strcol3)