473,387 Members | 1,440 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Stop a Sql Command

How can I Stop a Sql Command ? (Fill, ExecuteReader, etc...).
Nov 16 '05 #1
4 2882
Unless you are using QueryAnalyzer, I think you can only kill the process
executing the command. I assume you are running the command from Visual
Studio

JIM
"Rogerio Jun" <Ro********@discussions.microsoft.com> wrote in message
news:AF**********************************@microsof t.com...
How can I Stop a Sql Command ? (Fill, ExecuteReader, etc...).

Nov 16 '05 #2
I want stop the sql command in c#.

Rogerio

"James" wrote:
Unless you are using QueryAnalyzer, I think you can only kill the process
executing the command. I assume you are running the command from Visual
Studio

JIM
"Rogerio Jun" <Ro********@discussions.microsoft.com> wrote in message
news:AF**********************************@microsof t.com...
How can I Stop a Sql Command ? (Fill, ExecuteReader, etc...).


Nov 16 '05 #3
And SQLCommand.Cancel() won't work?

JIM
"Rogerio Jun" <Ro********@discussions.microsoft.com> wrote in message
news:41**********************************@microsof t.com...
I want stop the sql command in c#.

Rogerio

"James" wrote:
Unless you are using QueryAnalyzer, I think you can only kill the process
executing the command. I assume you are running the command from Visual
Studio

JIM
"Rogerio Jun" <Ro********@discussions.microsoft.com> wrote in message
news:AF**********************************@microsof t.com...
> How can I Stop a Sql Command ? (Fill, ExecuteReader, etc...).


Nov 16 '05 #4
James

10x.

Rogerio

"James" wrote:
And SQLCommand.Cancel() won't work?

JIM
"Rogerio Jun" <Ro********@discussions.microsoft.com> wrote in message
news:41**********************************@microsof t.com...
I want stop the sql command in c#.

Rogerio

"James" wrote:
Unless you are using QueryAnalyzer, I think you can only kill the process
executing the command. I assume you are running the command from Visual
Studio

JIM
"Rogerio Jun" <Ro********@discussions.microsoft.com> wrote in message
news:AF**********************************@microsof t.com...
> How can I Stop a Sql Command ? (Fill, ExecuteReader, etc...).


Nov 16 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: mkent | last post by:
I'm trying to use signal.alarm to stop a run-away os.system command. Can anyone exlain the following behavior? Given following the trivial program: import os import signal def...
5
by: Paul O. Morris | last post by:
Is there a script that I can run to stop a particular SQL server service on Win2003 server? I'm looking for a similar script to restart that service as well. Thanks.
3
by: yerim y via DBMonster.com | last post by:
hello, I am trying to stop a databse, have it in a read only mode. What i have found so far is the DB2STOP but that command works at he instance level, stopping all databases. Anybody knows of a...
4
by: DKode | last post by:
Hello, I have been using VB.NET for about 5 months and now I decided it's time to start using C#.NET because I like the syntax setup alot more, because it more closely resembles php/perl which...
2
by: ENathan | last post by:
I have a public sub in a class that does something like: If ValuesChanged() Then UpdateDatabase End If ValuesChanged and UpdateDatabase are Private functions within the class. My problem...
7
by: Timo Haberkern | last post by:
Hi there, i have some troubles with my TSearch2 Installation. I have done this installation as described in http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words...
1
by: AlexZh | last post by:
Hi, I'd like to stop command line build by one project build failed. To do that I've created simple AddIn (see code below), that works fine for IDE and does not work for command line. In the AddIn...
1
by: aj | last post by:
A few service stop/start/restart questions on SQL Server 2005 SP2, which I'll call SQLS. It looks as if there are *potentially* 6 ways to start/stop SQLS Services like the engine itself,...
11
by: zgh1970 | last post by:
Hi, Friends, I need to know how to stop all database process even after db2stop. How can I stop all database processes? I have finished upgraded our system test and UAT region from 32-bit to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.