Describe Command Type property of a SQLCommand in ADO.NET?

 Posted by Tripati_tutu on 10/8/2010 | Category: ADO.NET Interview questions | Views: 5620 | Points: 40

A SQLCommand has CommandType property which can take Text, Storedprocedure or TableObject as parameter. If it is set to Text, the command executes SQL string that is set to CommandText property. When set to StoredProcedure, the command runs the stored procedure of the database. If the property is set to TableObject, the command returns the entire content of the table indicated by the CommandText property.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response