How to use stored procedures?

Hi Guys,

I am a new member here in VB forums. How do we use stored procedures? I mean how do U link the paremeters in the stored procedures to the coding environment in VB.net, specifically ASP.net web application. Like for example a text box...

Ex. select last_name from student where idnum = @idnum
/*this select statement is oftenly used in the stored procedures. */

so, how do we connect to the procedure for example we input the idnum in a textbox? so that we can query the last_name...