Torna al Thread
Try
Dim conString = ConfigurationManager.ConnectionStrings("liceoConnectionString")
Dim strConnString As String = conString.ConnectionString
Using scope As New TransactionScope()
Using db As New SqlConnection(strConnString)
db.Open()
Using sqlcmd As New SqlCommand("Get_Numbercommenti", db)
sqlcmd.CommandType = CommandType.StoredProcedure
sqlcmd.Parameters.AddWithValue("@idnotizia", SqlDbType.Int).Value = idnotizia
Using sqldr As SqlDataReader = sqlcmd.ExecuteReader
If sqldr.Read() Then
Me.LinkButton2.Text = sqldr.GetSqlInt32(0).Value
Else
Page.RegisterStartupScript("ScriptDescription", "<script type=""text/javascript"">alert('Autenticazione fallita! Controllare che i dati inseriti siano corretti.');</script>")
End If
End Using
End Using
End Using
scope.Complete()
End Using
Catch ex As TransactionAbortedException
Page.RegisterStartupScript("ScriptDescription", "<script type=""text/javascript"">alert('" & ex.Message & "');</script>")
Return
Catch ex As SqlException
Page.RegisterStartupScript("ScriptDescription", "<script type=""text/javascript"">alert('" & ex.Message & "');</script>")
Return
Catch ex As Exception
Page.RegisterStartupScript("ScriptDescription", "<script type=""text/javascript"">alert('" & ex.Message & "');</script>")
Return
End Try