Difference Between Executequery And Executenonquery In Ado.Net

string connectionString = @"[Your_Connection_string]";
string query = "[Your_Query]";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand(query, connection))
    {
         int result = command.ExecuteNonQuery();
    }
}

string connectionString = @"[Your_Connection_string]";
string query = "your_select_query";
using (SqlConnection connection = new SqlConnection(connectionString))
{
   connection.Open();
   using (SqlCommand command = new SqlCommand(query, connection))
   {
       SqlDataReader reader = command.ExecuteReader();
       while (reader.Read())
       {
           Console.WriteLine(reader["column_name"]);
       }
   }
}

Query/Feedback