stored proedure in c#

Question

hi sir... i wana sample stored procedure example can u please snd me create a stored procedure in sqlserver and using c# we can update it this is the question please sit i want to know the concept of stored procedure... actually i am learning dotnet self so please help me