Hello everyone

I am working on a module and one of the things I wish to do is run a count query on a button click.  I have a stored procedure called "YourCompany_CountAthlete" and it contains the following code: 

ALTER PROCEDURE dbo.YourCompany_CountAthlete

 as

Select count(*) from YourCompany_Rider

I executed it  and it did count the number of records correctly (counting the number of riders).  What I am wondering is - how can I call this stored procedure to run and then display the result in a text box through a button click?  For reference the button is called CountAthleteButton and the textbox is AthleteCountBox. 

I have done other coding for entering information into a table that requires editing of the dataprovider.vb, "mymodule"controller.vb, "mymodule"info.vb, and sqldataprovider.vb, so if it does requre editing these files and calling them, I might be able to understand that too. 

Another button I have is for adding a rider to a table:

Dim cntrlr As myModuleController = New myModuleController()

 Dim mymodinfo As myModuleInfo = New myModuleInfo()

mymodinfo.LastName = LastNameText.Text

mymodinfo.FirstName = FirstNameText.Text

mymodinfo.SponsorID = SponsorDropDown.SelectedItem.Text

mymodinfo.EventID = EventDropDown.SelectedItem.Text

cntrlr.AddRider(mymodinfo)

LastNameText.Text = ""

  FirstNameText.Text = ""

SponsorDropDown.SelectedIndex = -1

EventDropDown.SelectedIndex = -1

GridView3.DataBind()

Sponsortext.Focus()

This seems to work perfectly fine, so if there are things that you could reference there if need be, you could do that too.

I appreciate any help offered - I have been trying to figure this out for a while and have had no luck.