Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

checking if sqlConnection is open

Status
Not open for further replies.
dky1e

dky1e

Programmer
May 4, 2002
293
US
Is there a cleaner way to test whether sqlConnection is open?
if( sqlConnection.State.ToString().Equals( "Open" ) )

Because this looks ugly :)

thanks.
 
Sort by date Sort by votes
I found it.

if( sqlConnection.State == ConnectionState.Open )

Looks ALOT better!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

xarzu
  • Question
How do I establish an open connection to an open web browser in C#?
Replies
0
Views
279
xarzu
xarzu
xarzu
  • Locked
  • Question
What is the proper way to declare a Microsoft class to use in my code. The quick and dirty way I am doing it here, I know, is not correct
Replies
0
Views
1K
xarzu
xarzu
xarzu
  • Locked
  • Question
What is the format of a SQLConnection connection string?
Replies
0
Views
121
xarzu
xarzu
ahmedsa2018
  • Locked
  • Question
cannot recognize email receiving is reply or new mail receiving
Replies
0
Views
204
ahmedsa2018
ahmedsa2018
IlyaRabyy
  • Locked
  • Question
What is the max length of a buffer Stream.Read and Stream.Write can handle?
Replies
4
Views
595
IlyaRabyy
IlyaRabyy

Part and Inventory Search

Sponsor

Back
Top