creating stored procedure in sql server

Question

hello Sir,

                  I am Rinku Dhadse developing web Application in which i want to create Stored procedure in Sql Server and call it in my C# code how i write code and how i use it in asp.net.