Your class should be the model of the data in your table. You should have a class User with Properties such as Name. Then you can write a method to get a List of Users to access each User's Name.
class User
{
private string name;
public User() { }
public string Name
{
get { return this.name; }
}
public static List<user> GetUserList()
{
List<user> userList = new List<user>();
return userList;
}
}