Re: SqlCommand Timeout

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.