CAN ANYBODY HELP?!

  • Thread starter Thread starter William \(Bill\) Vaughn
  • Start date Start date
W

William \(Bill\) Vaughn

As you have discovered, using Cancel is not particularly safe or effective.
Some queries can't be easily "cancelled" by the server so it has to go back
and repair any referential integrity issues raised by the query. Sometimes
this can be done quickly and easily--at other times it can't. I would not
create a design that depends on Cancel.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Here's what you do:

Double click on the time that is showing in your system tray.
Modify the date & time to the current date & time.
Click "OK"
 
Thanks a lot William.
Unfortunaly, this behaviour is not described anywhere in the MS
documentation.

Best regards,
Sergey.
 
Thank you very much for your help Mr. Scott M.
I will for sure try this.

Parables16:32.

Best regards,
Sergey.
 
Could anyone help me with the following problem!

I open an SqlConnection.
Then:
1. execute a reader on SqlCommand and get data through that reader;
2. in a certain time I call Cancel() method on SqlCommand and
SqlDataReader.Close().

If I perform steps 1 and 2 several times (sometimes it happens even from the
first time)
I get the error which says that SqlConnection is closed. And it is. So,
seems that SqlCommand.Cancel()
in combination with SqlDataReader.Close() forces the connection to close.
I can't determine the reason why it happens.
Can I control somehow this behaviour, because I need the connection to be
opened.

Thank you in advance,
Sergey.
 
I talk about this in my books, but I have not been writing MS docs for many
years. It's one of those obscure areas that does not get a lot of attention.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top