|
|
Subject: SqlCommand Timeout - msg#01183
List: windows.devel.dotnet.general
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
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 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.
|
|