SQL Command type

Question

I create an stored procedure like dis....

CREATE PROCEDURE sp_Personal

@ID int,@Name varchar(50)@Gender varchar(6),@Address varchar(75),

@Phone bigint,@Status varchar(15)

AS

BEGIN

IF @Status='Create'

BEGIN

INSERT INTO Student1(Name,Gender,Address,Phone) VALUES

(@Name,@Gender,@Address,@Phone)

END

IF @Status='Update'

BEGIN

UPDATE Student1 SET Name=@NameGender=@Gender,Address=@Address,Phone=@Phone

WHERE ID=@ID

END

END



Now my issue is want to connect to frontend usind ADO.net

public Create(Personal pers)

{

 SqlConnection con = new SqlConnection("Data Source=SamplePC;Initial Catalog=Sample;Integrated Security=True");

SqlCommand com = new SqlCommand("sp_Personal", con);

com.CommandType = CommandType.StoredProcedure;

}


How to call a "Create" query  only using Status parameter in frontend. am using MVC4 asp.net