ExecteReader,ExecuteNonQuery,ExecuteScalar
ExecteReader:Use for accessing data.It provide a forward only ,read only,Connected record set.
ExecuteNonQuery:Use for Data manipuation such as insert,update,delete.
ExecuteScalar:used to retreive single value 1row ,1col its example when you want to retrieve agregate functions .
Advertisement