लेनदेन (प्रक्रिया आईडी 1330) लॉक पर गतिरोध किया गया था

Line 229:            Dim RN As New Random
Line 230:            SQLCM = New SqlCommand("UPDATE OXARTICLE SET HITS=HITS+" & RN.Next(1, 5).ToString() & " WHERE ARTICLECODE=" & NEWSCODE, CN2)
Line 231:            SQLCM.ExecuteNonQuery()
Line 232:            SQLCM.Dispose()
Line 233:            DR.Close()

[SqlException (0x80131904): Transaction (Process ID 1330) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586158
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039990
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +997
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +314
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +297
   article_details.GETHITS() in G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb:231
   article_details.Page_Load(Object sender, EventArgs e) in G:\PleskVhosts\bainsfamily.com\punjabnewsline\news\details.aspx.vb:25
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693