c# - Select Query ADO (loop through the tables) -

i have requirement in database (ms access) need run through particular tables , inside of tables have select particular fields(i can predefine both tables , fields).

i don't want duplicate required field names , required tables names everywhere. store details in class. when select data below optimized way make string query each , every statement using datareader (ado.net) (assume number of fields varies each , every table below)

select field1, field2, field3 table1name select field1, field2, field3, field4, field5  table2name 

could please list down best practices since new ado.net. gained of best practices (http://msdn.microsoft.com/en-us/library/ms971481.aspx). need best way loop through tables using select query