How to create stored procedure

Create and execute SP

Create stored procedure:

create procedure p1 (@id int,  @Name varchar(50)) as
begin
insert into t1 values(@id,@Name)
end

Call from Front end:

connection.con.Open();
SqlCommand oc = new SqlCommand("p1",connection.con);
      oc.CommandType = CommandType.StoredProcedure;
oc.Parameters.AddWithValue("@id",1);
      oc.Parameters.AddWithValue("@Name", ‘aaa');
 oc.ExecuteNonQuery();
 connection.con.Close();