Why my insertion is not working ?

Can you please show us the error that you are getting??

rewrite all as shown below

 
if @action='Save' or @action='Submit'
begin
Insert into REQUEST
(RefNo, Name, status
Values (
@PMTNo, @name, @status))

end

 

 
internal void UpdateRequest(string action, string RefNo, string name, int status)
{
con.Open();
SqlCommand cmd = new SqlCommand("UpdateRequest", con);

cmd.Parameters.AddWithValue("@action", action);
cmd.Parameters.AddWithValue("@PMTNo", RefNo);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@status", status);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
con.Close();
}

Response.Redirect("abc.aspx");

}

Do you get any error when you execute? Post that error so that someone can help you.

 

Is it the actual code/SP you have posted here? Does it compile properly, because I see some issues here:

1) Is SP you have written

There is a starting bracker [, But where is the ending ] ?

In SP, I advise to convert @action parameter to int and pass like 1 for save, 2 for update, etc.

 

2) In protected void btnSave_Click(object sender, EventArgs e)

you declare:

      string Action = "Save";

and here you use "action" (mind the case - small a)

       UpdateRequest(action, RefNo, status);

 

Here there is only one set of quotes:

         SqlCommand cmd = new SqlCommand(UpdateRequest", con); 

 

I doubt your code compiles at all?