Subject: SqlCommand Timeout - msg#01183

List: windows.devel.dotnet.general

Date: Prev Next Index Thread: Prev Next Index

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.

Was this page helpful?

Thread at a glance:

Previous Message by Date: click to view message preview

Trace Access Database Activity

Hi all, I'm using ADO.Net to access an MS-Access database. How can I trace what's going on? What queries are sent to the database? You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.

Next Message by Date: click to view message preview

Re: Trace Access Database Activity

Hi Avi, Depending on your back-end, you can create a trace. With SQL Server, for instance, if you click on your server of choice in the Enterprise Manager, you can then select the "Create Trace" option. Check out "Books Online" for more information. HTH, - Mat -----Original Message----- From: Avi Nahir [mailto:avin@xxxxxxxxxxxx] Sent: Wednesday, June 26, 2002 12:33 PM To: DOTNET@xxxxxxxxxxxxxxxxxxx Subject: [DOTNET] Trace Access Database Activity Hi all, I'm using ADO.Net to access an MS-Access database. How can I trace what's going on? What queries are sent to the database? 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.

Previous Message by Thread: click to view message preview

Next Message by Thread: click to view message preview

Re: SqlCommand Timeout

Does setting SqlCommand.CommandTimeout not do what you want? Bob Beauchemin bobb@xxxxxxxxxxx -----Original Message----- From: Nischal Muthana [mailto:nischal_muthana@xxxxxxxxx] Sent: Wednesday, June 26, 2002 9:34 AM To: DOTNET@xxxxxxxxxxxxxxxxxxx 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.

Loading Comments...