SQL Server Express; Questions About Store Procs and Forms

Hello experts!  I have a few questions about SQL Server Express; stored procedures and forms.  First, where do SPs go?  Where are they saved?  I created a few SPs.  They executed fine, but I can’t find where the go.  I can’t tell how to interact with the SP after it runs.  Would I use C# to interact with the SP?  Also, would I create all forms in C#, and control SQL Server Express that way? 
 
I’m getting into SQL Server now (I’ve ...