can´t fetch select

[grezly]

I´m trying to fetch some data from a database to a variabele.

I´d created a data connection to an acces db

I can login (due to select statement), but i can't fetch data from the db

command = "{statement}" 
OleDbDataAdapter1.SelectCommand.CommandText = command

But how can you fetch data from the db.
I read something about getrow but i really can't fix it.

[jmcilhinney]

I suggest that you read the ADO.NET tutorial in my signature and also the Access section from the Start VB.NET tutorial.