SqlCommand.CommandTimeout Property

With SqlCommand.CommandTimeout property we can set times in seconds to wait for the command to execute. The default is 30 seconds

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx 
http://stackoverflow.com/questions/7023740/sqlcommand-object-what-length-of-time-for-commandtimeout