Regarding to CommandTimeout property

[pavalisofthard]

I would like to increase the CommandTimeout time 30 sec to maximum value like 100 or 200 .But I dont know I can I set it.Any one can help me.While I am exporting the Data base huge data to Excel or pdf .It is going to be showing Timeout Expires exception at exceutereader(0 command.


Thanks & Regards,
Venkat

[r035198x]

As easy as

myCommand.CommandTimeout = 200;