SQL Server - Timeout expired. The timeout period elapsed prior to completion of the operation ..

please set value sqlcommand.commandtimeout property


for example:

sqlcommand.commandtimeout=value;//value=200 or something