Even though you question is blank: yet there are two question I have to ask.
1 - You wanna know how to write Stored Procedure in Sql Server.
2 - You know the answer for above question but wanna know how to use that stored procedure in C# application.
Most probably its the second case (though you did not mention it, actually you mentioed NOTHING :() ). In that case here can be the solution
public void InsertRecord(int StudentId, string StudentName)
{
SqlConnection conn = new SqlConnection("your connection string");
SqlCommand command = new SqlCommand("InsertSpName", conn);
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
}
Remember this is just an idea how you would do things. Don't pin point the problems in THIS code :)