Reading values from SQL database in C#

Question

i have just started learning C# and i can write data to the database without a problem. But i'm having problems with reading, the SQL executes fine but i'm having issues with storing it. How would i store the four columns that should be returned and then show them as a message box? Thanks.

SqlCommand myCommand = new SqlCommand("select * from Requests where Complete = 0", myConnection); SqlDataReader myReader = myCommand.ExecuteReader(); while (myReader.Read())  Console.WriteLine(myReader["Username"].ToString()); Console.WriteLine(myReader["Item"].ToString()); Console.WriteLine(myReader["Amount"].ToString()); Console.WriteLine(myReader["Complete"].ToString()); 

Answer 1

One problem is missing braces after the while

while (myReader.Read()) {  // <<- here     Console.WriteLine(myReader["Username"].ToString());     Console.WriteLine(myReader["Item"].ToString());     Console.WriteLine(myReader["Amount"].ToString());     Console.WriteLine(myReader["Complete"].ToString()); }  // <<- here 

if you skip the braces only the first line will be processed in each loop, the rest will be processed after the loop, then myReader is past the last row.

Answer 2

Don't forget to use the using(){} block :

using (SqlConnection connection = new SqlConnection(connectionString)) using (SqlCommand command = new SqlCommand("select * from Requests where Complete = 0", connection)) {     connection.Open();       using (SqlDataReader reader = command.ExecuteReader())     {         while (reader.Read())         {             Console.WriteLine(reader["Username"].ToString());             Console.WriteLine(reader["Item"].ToString());             Console.WriteLine(reader["Amount"].ToString());             Console.WriteLine(reader["Complete"].ToString());         }     } }