can i perform different operations in one stored procedure

i have created one stored procedure in which i performed insert query below is the code

ALTER PROCEDURE sp1
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
(

@name nvarchar(50),
@age nvarchar(50)
)


AS
/* SET NOCOUNT ON */
insert into customer values(@name,@age)
RETURN




now what i want is that i could perform update and delete and select query in the same stored procedure.....................and in front end when i click on select, insert, update , delete button its respective operation should work taking from one stored procedure.....


how can i achieve this..............
regards,

Tags: C# (C# 4.0), .NET (.NET4), ASP.NET