What Are All The Different Methods Under Sql Command?

1.	What Are All The Different Methods Under Sql Command?
Answer» There are DIFFERENT METHODS under SqlCommand and they are: Cancel – Cancel the query CreateParameter – returns SQL Parameter ExecuteNonQuery – EXECUTES and does not return RESULT set ExecuteReader – executes and returns data in DataReader ExecuteScalar – Executes and returns single value ExecuteXmlReader – Executes and return data in XMLDataReader object ResetCommandTimeout – Reset Timeout property There are different methods under SqlCommand and they are: Cancel – Cancel the query CreateParameter – returns SQL Parameter ExecuteNonQuery – Executes and does not return result set ExecuteReader – executes and returns data in DataReader ExecuteScalar – Executes and returns single value ExecuteXmlReader – Executes and return data in XMLDataReader object ResetCommandTimeout – Reset Timeout property

Answer»

There are DIFFERENT METHODS under SqlCommand and they are:
Cancel – Cancel the query
CreateParameter – returns SQL Parameter
ExecuteNonQuery – EXECUTES and does not return RESULT set
ExecuteReader – executes and returns data in DataReader
ExecuteScalar – Executes and returns single value
ExecuteXmlReader – Executes and return data in XMLDataReader object
ResetCommandTimeout – Reset Timeout property

There are different methods under SqlCommand and they are:
Cancel – Cancel the query
CreateParameter – returns SQL Parameter
ExecuteNonQuery – Executes and does not return result set
ExecuteReader – executes and returns data in DataReader
ExecuteScalar – Executes and returns single value
ExecuteXmlReader – Executes and return data in XMLDataReader object
ResetCommandTimeout – Reset Timeout property

What Are All The Different Methods Under Sql Command?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment