Does setting SqlCommand.CommandTimeout not do what you want? Bob Beauchemin [EMAIL PROTECTED]
-----Original Message----- From: Nischal Muthana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:34 AM To: [EMAIL PROTECTED] Subject: [DOTNET] SqlCommand Timeout Hi All I am writing a small C# program which uses a SqlCommand object to insert a row into the Table in the database. The row I am tryin to insert is big one. So I want to set a timeout so that if the row is not inserted in a given secs. I would not execute it and rollback the insertion. Is there any way I can implement this. Appreciate any help. Thanks Nischal You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.