You can not create a store procedure in ASP.NET itself. For that you need database i.e. SQL.
Of course there is a way to add store procedure via visual studio without opening a SQL interface.
In SQL you can create a store procedure(SP) and call that SP from the ASP.NET.
Example 1 [
^]
Example 2 [
^]
Hope it helps.