Update One Column

[KobusVisagie]

Hi there Everyone

I am unsure if this is possible but i will try

I want to know if it is possible to update only one columns data while the other data stays in tact.

The rule for my grid is that there will be data that will be shown from the SQLDatabase, and then there will be a status column which should update every 5 seconds so the user will know what is happening with that rows data, Is this possible?

Please help as soon as possible as i really need to know how to do this.

Kind Regards
Gregory

[Marin]

Hello Gregory,

 Indeed this is not something that can be achieved out of the box with RadGrid. As the control represents tabular data and communicates one way or another with an SQL server. This fact poses similar limitation to the data manipulation that can be achieved in the particular case. As there is no straightforward way to update only one column in a database table through a single SQL query so does the grid cannot perform such operation easily. One way to achieve this would be to utilize the approach of performing batch updates in RadGrid. But have in mind that this is a performance costly operation and executing it every few seconds might present a certain overhead in the application.

Regards,
Marin
the Telerik team

[KobusVisagie]

Hi Marin

Thanks for the info, i have decided to use the tool tip manager instead, as this was the best outcome

Regards
Gregory