System.Data.SqlClient Namespace   SqlCommand Class

Sets or retrieves the wait time before terminating the attempt to execute a command and generating an error.

The property is read/write with a default value of 30.

IDbCommand.CommandTimeout

A value of 0 indicates no limit, and should be avoided in a CommandTimeout because an attempt to execute a command will wait indefinitely.

The following example illustrates how the CommandTimeout property can be set.

void setSqlCommand ( ) {
   SqlCommand myCommand = new SqlCommand ( );
   myCommand.CommandText = "SELECT * FROM Categories ORDER BY CategoryID";
   myCommand.CommandTimeout = 15;
}

Public Sub setSqlCommand ( )
   Dim myCommand As New SqlCommand ( )
   myCommand.CommandText = "SELECT * FROM Categories ORDER BY CategoryID"
   myCommand.CommandTimeout = 15
End Sub

SqlCommand Members   CommandText   Connection   CommandType