How to get results one by one 'MySqlDataReader'

Asked Mar 19 '15 at 02:56

Active Mar 19 '15 at 05:27

Viewed 58 times

using (MySqlDataReader reader = command.ExecuteReader())
{
    while (reader.Read())
    {
        Console.WriteLine(reader.GetString(0));
    }
}

I get few results in same time but i want to get one by one, what i should add?

edited Mar 19 '15 at 05:27

alecxe

asked Mar 19 '15 at 02:56

Xizt

When i use MySqlDataReader i get several rows, i want first of them and later rest – Xizt Mar 19 '15 at 03:11
What does that mean? By looping through the reader, you *are* pulling the rows one by one. – 9ee1 Mar 19 '15 at 03:42
@9ee1 OP sounds like he copied some code off the internet. He sounds like he only wants to call `Read()` _once_. – Cole Tobin Mar 19 '15 at 04:59
@ColeJohnson Perhaps. He never responded, so I guess we will never know :) – 9ee1 Mar 20 '15 at 18:21

0 Answers0