Hi all,

I'm having a bit of a problem. It probably has an easy solution, but I don't see it.

Anyway, I am currently developing an application, and having trouble with deciding how to get data into the gridview.

The first thing I thought about was creating a class like "Griddata", and I would set it up like this....

Code:
Public Class Griddata
declare variables here

public property FirstName as String
Get, Set, etc.
Then, I would call a separate sql statement to determine the value(s) of each property.... for example,

Code:
private function returnFirstName (etc.)
firstname = select firstname from tablename
return firstname
Is this the way I should go about this? Seems to me like I'm way off. Oh, and I have an example, but the program was written by a contractor and the code is very confusing.

Will I be able to use a dataset? I ask because the program cannot access the database directly, and all the examples I've seen seem to have a SQLConnection string.....I'm sending my SQL requests through an intermediary.