I can create a SQL connection, but can't run any queries

[skake01]

Open the connection before creating the SqlCommand.

Also the output of the SQL select statement doesn't contain "Column1" or "Column2" in its output : its columns (as you specified) are "order_num" and "return_num".

So the code should read :

Console.WriteLine(thisReader["order_num"].ToString());
Console.WriteLine(thisReader["return_num"].ToString());

Darwen.

thanks, but that did not work, i got the same error.