CREATE PROCEDURE [dbo].[sp_RodeoEvtConfig]

-- Add the parameters for the stored procedure here

@rodeoid int = 1,

@eventcd char(2)

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for procedure here

SELECT rodeoevtconfig_pk, rodeoId, eventCD, eventName, goCount, committeePurse, sponsorPurse, additionalCompensation, eventStatus, finalsFlag, finalsPayoutFactor,

finalsAmount, CommitteeEventMoney, dayMoneyPayoutPositions, backToBackFlag, dayMoneyDeduction, deductionPercent, orderOfFill, decimalPrecision,

stockBackNumberUsed, leftRightJudgesSets

FROM RodeoEventConfiguration

WHERE (rodeoId = @rodeoid) AND (eventCD = @eventcd)

Me.RodeoEvtConfigBO1.FillAllRodeoEvtConfig(1, "BB")

Public Sub FillAllRodeoEvtConfig(ByVal nrod As Integer, _

ByVal cevt As String)

Dim cmd = New SqlCommand("dbo.sp_RodeoEvtConfig")

cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add("@rodeoid", SqlDbType.Int).Value = nrod

cmd.Parameters.Add("@eventCD", SqlDbType.Char, 2).Value = cevt

FillDataTable(cmd)

End Sub