How to use stored procedures in ASP.net?

[Fishcake]

Assuming your using SQL Server.....

imports system.data.sqlclient
'At top of page
 
....
dim sqlConn as sqlConnection
dim cmdSelect as sqlCommand
 
'Open db connection in sqlConn
...
cmdSelect = new("stored_proc_name_here",sqlConn)
cmdSelect.commandType = commandType.StoredProcedure
cmdSelect.parameters.add("@idnum", txtIDNum.text)
...

Thats from memory so not sure if exact but you should get the idea.