Check Sql Connection

Hi Chavda,

Please see the below code snippet.

UsingcnAsNewSqlConnection(ConnectionString)
cn.Open()
UsingcmdAsNewSqlCommand("GetCustomerByID",cn)
Try
Withcmd
.Connection=cn
.CommandType=CommandType.StoredProcedure
.Parameters.Add("@CustomerID",SqlDbType.Int,4)
.Parameters("@CustomerID").Value=CustomerID
EndWith
da=NewSqlDataAdapter(cmd)
da.Fill(ds,"Customer")
CatchexAsException
EndTry
EndUsing
EndUsing

If the above solution is helpful then,accept the 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 Jadav10y ago

Hi,

Do you mean the Instance of SQL Server is exists or not ?

right ?

Thank you..

Bikesh Srivastava10y ago

Hi,

use this code to check sql connection .

if (myConn.State != ConnectionState.Open)