Updating Columns In Sql Server Table From My Asp Web Page

I have a web interface where i have listing of several data and check box for inserting data into SQL server 2005 database table,

so I am able to inset data to sql tables using stored procedure. Now the question is i want to update these inserted records(agency approval column inserted as 1) in same table and assign value 1 fot the checked data to column finace approval as 1.

Here is how ia have webclas  library where i script for getting the insert parameterspublic void Process_Payment(ref DataTable TableWithPayments, string Payment)

{SqlCommand InsertCommand = new SqlCommand();

SqlConnection AccessDatabase = new SqlConnection(FinanceSourceWrite.ConnectionString);int PaymentID = 0;

AccessDatabase.Open();

InsertCommand.Connection = AccessDatabase;

 

 

//DataTable TemporaryTable = new DataTable();

//TemporaryTable = TableWithPayments;SqlTransaction TransactionProcess = null;

SqlParameter InsertParameters;foreach (DataRow DataCommentInfo in TableWithPayments.Rows)

{InsertCommand.CommandText = "InsertPaymentList"; //THIS IS my stored procedureInsertCommand.CommandType = CommandType.StoredProcedure;

TransactionProcess = AccessDatabase.BeginTransaction();

// SET ALL THE VALUES FOR THE PARAMETERSInsertParameters = InsertCommand.Parameters.Add("@JC_ID", SqlDbType.Int);

InsertParameters.Direction = ParameterDirection.Input;InsertParameters.Value = DataCommentInfo["JC_ID"];

 InsertParameters = InsertCommand.Parameters.Add("@Payment_Type", SqlDbType.Int);

InsertParameters.Direction = ParameterDirection.Input;InsertParameters.Value = DataCommentInfo["Payment_Type_ID"];

 

InsertParameters = InsertCommand.Parameters.Add("@Agency_approval", SqlDbType.Int);InsertParameters.Direction = ParameterDirection.Input;

InsertParameters.Value = DataCommentInfo["Agency_approval"];

 

Now my stored procedure

  

ALTER PROCEDURE [dbo].[InsertPaymentList](

@JC_ID int ,

@Payment_Type int,

@Payment_Group int,

@AGENCY_ID int,

@Agency_approval int,

@Agency_approval_date datetime,

@Program_ID nvarchar(50),

@Status bit,

@Jobsite_code_ID int,

@Date_Stamp datetime,

@Provider nvarchar(50),

@UserName nvarchar(256),

@Activity_ID int,

@Subproject_ID int,

@Payment_Support_Retention_List_ID int,

@WPR_ID int,

@Placement_ID int,

@Enrollment_ID int,

@Satisfaction_ID int,

@Enrollment_Bonus_ID int,

@Re_Placement_Bonus_ID int

)AS

INSERT INTO Payment_LIST_AIMS

(JC_ID, Payment_Type, Payment_Group, AGENCY_ID, Agency_approval,

Agency_approval_date, Program_ID, status,

Jobsite_code_ID, Provider, UserName, Placement_ACTV_ID, Placement_Sub_ID, Support_Retention_ID, WPR_ID, Placement_ID,Enrollment_ID,Satisfaction_ID,Enrollment_Bonus_ID,Re_Placement_Bonus_ID)

VALUES  @JC_ID, @Payment_Type, @Payment_Group, @AGENCY_ID, @Agency_approval,@Agency_approval_date, @Program_ID, @Status,

@Jobsite_code_ID, @Provider, @UserName, @Activity_ID,

@Subproject_ID, @Payment_Support_Retention_List_ID, @WPR_ID, @Placement_ID,@Enrollment_ID,@Satisfaction_ID,@Enrollment_Bonus_ID,@Re_Placement_Bonus_ID)

SELECT CAST(scope_identity() as int)

Here like you see agency approval column in SQL server table gets value assigned as 1 when Agency user clicks the confirm payment button and so all the values as above....

Now another user Finance user process the same records from the web UI and clicks the process payment button at this stage ..i need to update Finance approval column as 1 agains that particular record existing th the SQL table, there are two three coulmc to be updated , Finance approval(this is where i need help) , Finance approval date , and user

 Being a newbie please help me whith how i can fix this

Thanks

Santosh