You mentioned you are a beginner. That leads me to deduce that you are not the author of the SQLHelper class (because I doubt if a beginner would be assigned to write a DataLayer class.)
Someone appears to have misled you into believing that this is VB.NET ! This is all VBScript with ASP. Anyone who's ever worked in ASP would instantly recognize the coding style. I've seen it too often because it is a common ploy used by rogue software firms to misle clients who insist on moving to the latest technologies and making some dough during the so-called "migration phase". To expand upon your questions: 1. The PopulateRS() function returns a string array containing ONLY values of the *first column* returned via the SQL script, no matter how many columns you wanted to retrieve. So you might as well be asking us how to create a 10-dimensional array and it still would be no use because the function returns a single dimensional array, period. Furthermore, the function does not care about column names. Lastly, the function does not care about DBNulls. So, unless you have the professional authority in your firm to invoke another function that returns something more reasonable or to rewrite your SQLHelper class, you're in a fix. I'm sorry to say but the person who wrote the SQLHelper class or atleast this function has no concept of writing VB.NET code. If that person happens to be you, then I mean no offense and I would be happy to show you how it should have been written.
