Check Sql Connection

Question

Please help me i want to check sql server exists or not. and after i using the sqlconnection.open() in vb.net

Bikesh Srivastava · Answer

Hi use this code to check sql connection . if (myConn.State != ConnectionState.Open)

Rajeev Punhani · Answer

Hi Chavda Please see the below code snippet. Usingcn As New SqlConnection(ConnectionString) cn.Open() Usingcmd As New SqlCommand( GetCustomerByID cn) Try With cmd .Connection=cn .CommandType=CommandType.StoredProcedure .Parameters.Add( @CustomerID SqlDbType.Int4) .Parameters( @CustomerID ).Value=CustomerID End With da= New SqlDataAdapter(cmd) da.Fill(ds Customer ) Catch ex As Exception End Try End Using End Using If the above solution is helpful then accept the answer.

Rajeesh Menoth · Answer

Hai So you need to check current state of sql connection using c#. Reference : http://stackoverflow.com/questions/6943933/check-if-sql-connection-is-open-or-closed

Vishal Jadav · Answer

Hi Do you mean the Instance of SQL Server is exists or not ? right ? Thank you..