Articles → ADO.NET → Difference Between ExecuteQuery And ExecuteNonQuery In Ado.Net

Difference Between Executequery And Executenonquery In Ado.Net






Executenonquery






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();
    }
}



Executequery




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"]);
       }
   }
}





Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, March 20, 2024

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250