Returning a value from MS SQL to VB.Net

How do I pass @attackPercentage back to my VB procedure and have it read by the reader? I keep getting Error: System.IndexOutOfRangeException: attackPercentage

ALTER PROCEDURE [dbo].[SelectPlayersRating]        @playerAccountID uniqueidentifier,      @raterAccountID uniqueidentifier        AS      BEGIN            DECLARE @attackPercentage INT            SELECT attack, safety, consistency FROM tblRatings WHERE @playerAccountID=playerAccountID AND   @raterAccountID = raterAccountID          SET @attackPercentage = '99' --Test Value          RETURN @attackPercentage         END          Dim DBConnect3 As New DBConn      Using db As DbConnection = DBConnect3.Conn("DBConnectionString")          Dim cmd As SqlCommand = DBConnect3.Command(db, "SelectPlayersRating")          cmd.Parameters.Add(New SqlParameter("playerAccountID", SqlDbType.UniqueIdentifier, ParameterDirection.Input)).Value = Guid.Parse(Request.QueryString("aID"))          cmd.Parameters.Add(New SqlParameter("raterAccountID", SqlDbType.Uniqueidentifier, ParameterDirection.Input)).Value = acc.accountID          db.Open()          Dim DR As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)          While DR.Read              ddlAttack.SelectedValue=DR("attack")              ddlSafety.SelectedValue=DR("safety")              ddlConsistency.SelectedValue=DR("consistency")              session("test") = DR("attckPercentage")          End While          DR.Close()          DR = Nothing          cmd.Dispose()          cmd = Nothing          db.Dispose()          db.Close()      End Using  

https://stackoverflow.com/questions/65622858/returning-a-value-from-ms-sql-to-vb-net January 08, 2021 at 11:01AM