I have solved this problem already. Thanks. ;) Regards, Jo

Hi, I am just starting to use gridview and have encounter problem when using it. I have 2 columns for my gridview which is the product number and product description. I would have to get the old product number so that I can update the database with the latest record. Would appreciate if someone can help me with this. Thanks in Advance. Regards, Jo

i dont get what you mean by the second statment. The statement i have is to update 2 tables.

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[UpdatePAppParty] @PID VARCHAR(10), @AID VARCHAR(10), @name VARCHAR(50), @designation VARCHAR(20), @status VARCHAR(15), @reasons VARCHAR(100) AS Begin Update [aParty eStatus] Set names = @name, designation = @designation, status = @status, reason = @reasons where aParty.APID = estatus.APID and aParty.projectID = estatus.projectID END this is the procedure that i came out with. not too sure if it is correct. Regards, Jo

Hi, I have some problems with the updating of database. I will need to update 2 tables in one sql query and I am not too sure how to write a stored procedure with sql server. Need some guidance. Thanks. Regards, Jo

this is the coding for the link button which is inside the gridview. I will need to retrieve the value from the link button in order to update my database.

Hi, I would like to know how to retrieve the text from a link button which is within a gridview. Thanks in advance. =)