How to disable the edit Button on gridview depends on status

Question

Hi Friends i ve the application like that Travel request.aspx departuredate = jquery date picker from =textbox to = textbox lodge = textbox add(after press the button ll on details on gridview) submit GRIDVIEW table (above insertion value shown here) for above values stored on My database table structure is: create table travel_request ( claim_id int identity departuredate datetime from varchar(20) to varchar(20) is_approved varchar(30) ) once the user press the submit means ll go to approver now travel_request table column is_approved=fresh in these fresh status user can edit the value from grid view. once the approver given the approval now travel_request table column is_approved=approved  gidview edit button would be disable how to make a code?

Iftikar Hussain · Answer

Hi try like this > CommandName=Edit runat=server Enabled=' ' > Regards Iftikar

Iftikar Hussain · Answer

i hope you should allow user only for applying first time alter procedure submit_buton ( @username varchar(20) ) as begin declare @user varchar(20) select @user=user_id from users where username=@username if not exists(select 1 from travel_request a inner join travel_claims b on a.request_id = b.request_id where a.user_id=@user and a.is_approved in ( 'fresh''cancel' ) begin update travel_claims set is_approved='fresh' where request_id=@request end

Rocky Rocky · Answer

hi wat ll happend if i passed these condition on my procedure a.is_approved in('fresh''approved''cancel') replacement of a.is_approved 'fresh'

Iftikar Hussain · Answer

modify like this alter procedure submit_buton ( @username varchar(20) ) as begin declare @user varchar(20) select @user=user_id from users where username=@username if not exists(select 1 from travel_request a inner join travel_claims b on a.request_id = b.request_id where a.user_id=@user and a.is_approved 'fresh' ) begin update travel_claims set is_approved='fresh' where request_id=@request end

Rocky Rocky · Answer

hi create procedure submit_buton ( @username varchar(20) ) as begin declare @user varchar(20) select @user=user_id from users where username=@username if not exists(select * from travel_request a inner join travel_claims b on a.request_id = b.request_id where a.user_id=@user and a.is_approved in('fresh''approved''cancel') ) begin update travel_claims set is_approved='fresh' where request_id=@request end if already exists means ll show error message?

Iftikar Hussain · Answer

provide your sp which you have created for submitting travel request

Rocky Rocky · Answer

Hi i need one help can you provide stored procedure with condition more than one of duplication submission request from user side submit