Bob, Realized it a bit late that the SqlCommand has a CommandTimeOut. That did work. Thanks though.
Thanks Nischal --- "Beauchemin, Bob" <[EMAIL PROTECTED]> wrote: > 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. __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
