Click here to Skip to main content
15,914,943 members
Home / Discussions / C#
   

C#

 
GeneralRe: i need help???in c# Pin
Wes Aday9-Mar-12 3:03
professionalWes Aday9-Mar-12 3:03 
Questioninteracting with a webiste in c# Pin
james bradbery8-Mar-12 21:21
james bradbery8-Mar-12 21:21 
AnswerRe: interacting with a webiste in c# Pin
Dave Kreskowiak9-Mar-12 3:16
mveDave Kreskowiak9-Mar-12 3:16 
QuestionThe WebService still returns "Connection Successful" even SQL Server is off. Please Help. Pin
MarkSquall8-Mar-12 18:58
MarkSquall8-Mar-12 18:58 
AnswerRe: The WebService still returns "Connection Successful" even SQL Server is off. Please Help. Pin
Bernhard Hiller8-Mar-12 21:26
Bernhard Hiller8-Mar-12 21:26 
GeneralRe: The WebService still returns "Connection Successful" even SQL Server is off. Please Help. Pin
Sentenryu9-Mar-12 0:21
Sentenryu9-Mar-12 0:21 
AnswerRe: The WebService still returns "Connection Successful" even SQL Server is off. Please Help. Pin
Shameel9-Mar-12 1:03
professionalShameel9-Mar-12 1:03 
AnswerRe: The WebService still returns "Connection Successful" even SQL Server is off. Please Help. Pin
jschell9-Mar-12 5:16
jschell9-Mar-12 5:16 
marksquall wrote:
I should be expecting the error message, right?


No.

And your scenario is wrong anyways so presumably you are only doing it to mess around.

C# (.Net) by default uses a connection pool for MS SQL Server connections.

So the first time you called it a new connection was created. That was put into the pool.

And it was put into the pool by the GC which is NOT a good idea. You should be explicitly closing it.

The second time you called it, the connection in the pool was used. Pooled connections are not verified (nor should they be). They only result in an error if they are actually used to interact with the database.


marksquall wrote:
Can anyone help me how would I change my webservice code?


That would require more explanation of what you think you are attempting to do. But as one possibility you should be doing a do nothing query on every attempt to insure that the database itself is actually capable of doing work.
AnswerRe: The WebService still returns "Connection Successful" even SQL Server is off. Please Help. Pin
MarkSquall11-Mar-12 21:33
MarkSquall11-Mar-12 21:33 
QuestionEncryption and decryption Pin
sandy_418-Mar-12 17:19
sandy_418-Mar-12 17:19 
AnswerRe: Encryption and decryption PinPopular
OriginalGriff8-Mar-12 20:20
mveOriginalGriff8-Mar-12 20:20 
GeneralRe: Encryption and decryption Pin
sandy_419-Mar-12 0:12
sandy_419-Mar-12 0:12 
GeneralRe: Encryption and decryption Pin
OriginalGriff9-Mar-12 0:25
mveOriginalGriff9-Mar-12 0:25 
GeneralRe: Encryption and decryption Pin
sandy_419-Mar-12 0:27
sandy_419-Mar-12 0:27 
GeneralRe: Encryption and decryption Pin
Matt Meyer9-Mar-12 3:54
Matt Meyer9-Mar-12 3:54 
GeneralRe: Encryption and decryption Pin
Wayne Gaylard9-Mar-12 0:36
professionalWayne Gaylard9-Mar-12 0:36 
GeneralRe: Encryption and decryption Pin
OriginalGriff9-Mar-12 0:40
mveOriginalGriff9-Mar-12 0:40 
QuestionWhere is this c# console application running from?? Pin
Goalie358-Mar-12 17:08
Goalie358-Mar-12 17:08 
AnswerRe: Where is this c# console application running from?? Pin
Roger Wright8-Mar-12 17:30
professionalRoger Wright8-Mar-12 17:30 
AnswerRe: Where is this c# console application running from?? Pin
RobCroll9-Mar-12 3:19
RobCroll9-Mar-12 3:19 
GeneralRe: Where is this c# console application running from?? Pin
Roger Wright9-Mar-12 5:02
professionalRoger Wright9-Mar-12 5:02 
AnswerRe: Where is this c# console application running from?? Pin
jschell9-Mar-12 5:23
jschell9-Mar-12 5:23 
GeneralRe: Where is this c# console application running from?? Pin
Vasudevan Deepak Kumar9-Mar-12 9:54
Vasudevan Deepak Kumar9-Mar-12 9:54 
QuestionDecimal format in the textbox Text Change C# (1000000 -> 1,000,000) Pin
nhanlaptrinh8-Mar-12 16:03
nhanlaptrinh8-Mar-12 16:03 
AnswerRe: Decimal format in the textbox Text Change C# (1000000 -> 1,000,000) Pin
OriginalGriff8-Mar-12 20:37
mveOriginalGriff8-Mar-12 20:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.