I have gridbound column Col_A and COL_B and dataformat set to currency.Both these columns are integer . I have embeded udpate statement in sqldatasource to update both these columns. Based on business rule I open only one column for editing before update.
If COL B is open for update(COL A is read only in this scenario), When I execute update statement COL A is reading the formatted value and passing to SQL staement i.e formatted currency value and this gives database error because COL A is integer type.
1) How can i get the just the value of COL A (not the formmated one for example , I need 3000 not 3,000). Extravalues in edit mode not working
2) How do i put mask for editable column ,i.e the user can type 5,000 rather than 5000 , but the value read is 5000
Thanks
If COL B is open for update(COL A is read only in this scenario), When I execute update statement COL A is reading the formatted value and passing to SQL staement i.e formatted currency value and this gives database error because COL A is integer type.
1) How can i get the just the value of COL A (not the formmated one for example , I need 3000 not 3,000). Extravalues in edit mode not working
2) How do i put mask for editable column ,i.e the user can type 5,000 rather than 5000 , but the value read is 5000
Thanks
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 30 Jan 2012, 05:46 AM
Hello NVB
-Shinu.
You can use the SessionParameter concept in SqlDataSource to achive this. Please take a look into the following forum which shows how to use SessionParameter.
http://www.telerik.com/community/forums/aspnet-ajax/grid/populate-radcombo-in-editform.aspx#1273974-Shinu.