values from a db into an array

[id123]

hi,

does anyone have any code to show i could read data from my access db and place the data in an array. I ideally want to just read the primary key from each table (empID from the employee table)

cheers

[nswan]

why don't you just select the primary key in the select statement then? You could use a DataTable object as well if you don't want to use a dataset. You can fill a datatable with a data adapter the same way you do a dataset.

[id123]

thanks for the reply,

sorry but i am a bit new to this so i dont really have the grasp of the language yet. do you have a code snippet or example to demonstrate what you mean?