Getting data from MySQL using VB

[semeth]

Hi.
That is my problem:

I want to get from my db some data, but how can i get this data to variable?

I do that:

conn.Execute "SELECT column1 FROM table1 WHERE id>1 and id<100"

So how can i write this elements to variables.

And one of possible method is using loop, but the db is huge, and the query must execute less than 60 second, and sometimes i must take from db more that 50000 rows.

Please help.

Thanks a lot for answer.