Command object is used to perform the operations on the databse objects.

• Here, Operations means insert, update, delete, alter, drop..etc.
• database objects means tables, stored procedures, views..etc.
• If we working with the DataReader then the Command object will work with the connected oriented architecture.
• If we working with the DataAdapter then the Command object will work with the Disconnected oriented architecture.

The following are the properties of the command object.

• CommandText
• CommandType
• CommandTimeout
• Connection
• Parameters
• Transaction

The following diagram shows you the types of execution methods.

Follow the below steps to work with the command object. Step 1: Declare the Command Object. [csharp]ClassName ObjectName;[/csharp] [csharp]SqlCommand cmd;[/csharp] Step 2: Define the Command Object. [csharp]ObjectName = new ClassName(string CommandText,Conection)[/csharp] [csharp]cmd = new SqlCommand("delete empdetails where eid=101",con)[/csharp] Step 3: Mention the CommandType. [csharp]ObjectName.CommandType = CommandType.Value;[/csharp] [csharp]cmd.CommandType = CommandType.Text;[/csharp] Step 4: Execute the Command Object. [csharp]ObjectName.Executemethod();[/csharp] [csharp]cmd.ExecuteNonQuery();[/csharp]