c# sql and loop while

Question

I try to read all the fields of a column (second column -link-) in my database. I find this example, but I can't manage to read one column of varchar type:

SQLConnection.Open();

using (SqlCommand command = new SqlCommand("SELECT link  FROM shop", SQLConnection))
using (SqlDataReader reader = command.ExecuteReader())
{
    while (reader.Read())
    {
        Console.WriteLine("{2}",reader.GetString(2));
    }
}

I've got this error:

Index was outside the bounds of the array.

and I don't understand why...

Thanks in advance :)

try SELECT * FROM shop, cause you're getting the second column with reader.GetString(2) — user1979270
– user1979270, Commented Jul 13, 2013 at 22:56
I get this error: > Index (zero based) must be greater than or equal to zero and less than the size of the argument list. — pi-2r
– pi-2r, Commented Jul 13, 2013 at 23:04

Tim Schmelter · Accepted Answer · 2013-07-13 23:03:22Z

2

Replace

Console.WriteLine("{2}",reader.GetString(2));

with

Console.WriteLine("{0}",reader.GetString(0));

since 1.)the composite formatting feature uses zero-based indexed placeholders and 2.) you are selecting just one field from the table, so the only index is 0.

answered Jul 13, 2013 at 23:03

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

c# sql and loop while

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related