Good Afternoon Guys
Let me start here. i have been Builidng Win App and this was an easy task there. Now i have a Page that has a Datagridview and am Displaying this from a DataTable Through a SP like this
Create Proc [sde].[Check_Active_Valuation]as select LIS_KEY,FUNC_KEY,SUBSTRING(CONVERT(VARCHAR,V2.ADD_DATE,1),1,13)AS [ADD DATE],V2.NEW_IMPROVED_VALUE AS [MARKET VALUE],SUBSTRING(CONVERT(VARCHAR,V2.EFFECTIVE_DATE,1),1,13)AS [EFFECTIVE_DATE] ,CASE V2.VAL_STATUS_ID WHEN1 THEN 'PREVIOUS' WHEN 2 THEN 'ACTIVE'WHEN 3 THEN 'PROCESSED'WHEN 4 THEN 'COMMITED' END AS [STUTUS]from sde.Property_Summary p1 INNER JOIN SDE.VALUATION V2ON V2.PROPERTY_ID =P1.PROPERTY_IDwhere 1< (select count(v1.val_status_id)from sde.valuation v1where v1.property_id = p1.property_idand v1.archive_date is nullANd v1.val_status_id = 2AND V1.EFFECTIVE_DATE > '2002/07/01')As you can see my SP, Value of Last Field am Displaying is Derived from the Value of that Field. So now, My Users Will see this on the grid will Previous ,Commited and Processed, and thats Fine, now i cant Edit that,i want my users to be able to Double Click and this Field should turn to be a Combobox and they Should Select the Appropriate between Previous , Processed and Commited, The Save part i can hendle.
Thank you