ExecuteReader and ExecuteNonQuery

ExecuteReader : ExecuteReader used for getting the query results as a DataReader object. It is readonly forward only retrieval of records and it uses select command to read through the table from the first to the last.
SqlDataReader reader; reader = Command.ExecuteReader(); while (reader.Read()) { MessageBox.Show(reader.Item(0)); } reader.Close();
ExecuteNonQuery : ExecuteNonQuery used for executing queries that does not return any data. It is used to execute the sql statements like update, insert, delete etc. ExecuteNonQuery executes the command and returns the number of rows affected.
int retValue = 0; Command = new SqlCommand(Sql, Connection); retValue = Command.ExecuteNonQuery();





Related Topics
  1. C# ADO.NET Connection
  2. C# SQL Server Connection
  3. C# OLEDB Connection
  4. C# ODBC Connection
  1. C# ADO.NET Command
  2. C# ADO.NET SqlCommand - ExecuteNonQuery
  3. C# ADO.NET OleDbCommand - ExecuteNonQuery
  4. C# ADO.NET SqlCommand - ExecuteScalar
  5. C# ADO.NET OleDbCommand - ExecuteScalar
  6. C# ADO.NET SqlCommand - ExecuteReader
  7. C# ADO.NET OleDbCommand - ExecuteReader
  8. C# ADO.NET DataReader
  9. C# ADO.NET SqlDataReader
  10. C# ADO.NET OleDbDataReader
  11. C# Multiple Result Sets
  12. C# Table Schema from SqlDataReader
  13. C# Table Schema from OleDbDataReader
  14. C# ADO.NET DataAdapter
  15. C# ADO.NET SqlDataAdapter
  16. C# ADO.NET OleDbDataAdapter
  17. System.Data.SqlClient.SqlException: Login failed for user

Related Links
  1. Stored Procedures in C#
  2. C# Stored Procedure with Parameter