How to retrieve a range of values from database in each click of a button to a grid

class Table1
{
int id;
String text;
getId();
getText();

void selectRow(int id)
{
SQLConnection sql = new SQLConnection("connectionString");
//this query is easy, but using parameters is safer
string query = "select * from Table1 where id= "+id.ToString();
//use SQLReader
if(read)
{
this.id = ???
this.text = ???
}

static List<Table1> selectAll()
{
List<Table1> list = new List<Table>();
SQLConnection sql = new SQLConnection("connectionString");
//this query is easy, but using parameters is safer
string query = "select * from Table1";
//use SQLReader
Table1 tmp;
while(read)
{
tmp= new Table1();
tmp.id = ???
tmp.text = ???

list.Add(tmp);
}

}

}//class end

form:
init()
{
listview.AddColumn("id",50);
listview.AddColumn("text",100);
}
fillListView()
{
List<Table1> tList = new List<Table1>();
tlist = Table1.selectAll();
//add to list view
}