ASP.NET

ASP.NET RSS

Adding a Combobox in a Datagridview ASP.NET

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Mar 2007

Posts: 147

Reputation: vuyiswamb is an unknown quantity at this point

Solved Threads: 5

vuyiswamb

Offline

Junior Poster

Adding a Combobox in a Datagridview ASP.NET

Aug 28th, 2008

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

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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')
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

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."