HOW TO CATCH THE RESULT OF THIS QUERY

[Houssem12]

HI MEMBERS

I HAVE A QUERY THAT SHOW ME IF THE LIGNE IS LOCKED OR NOT

NOW I WHANT THE RESULT OF THIS QUERY IN VB.NET

If cn.State = ConnectionState.Open Then
cn.Close()
End If

cn.Open()
Dim ISLOCK As New SqlCommand("declare @lres int execute CB_IsRecordLock 'F_ARTICLE',6565445, @lres output", cn)

Dim ISLOCKREADER As SqlDataReader = ISLOCK.ExecuteReader
ISLOCKREADER.Read()




I WANT TO GET THE OUTPUT RESEULT ITS @lres

Continue reading...