This is a migrated thread and some comments may be shown as answers.

Update One Column

2 Answers 51 Views
Grid
This is a migrated thread and some comments may be shown as answers.
KobusVisagie
Top achievements
Rank 1
KobusVisagie asked on 17 Feb 2012, 11:38 AM
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

2 Answers, 1 is accepted

Sort by
0
Marin
Telerik team
answered on 21 Feb 2012, 03:40 PM
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
Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
0
KobusVisagie
Top achievements
Rank 1
answered on 08 Jun 2012, 07:29 AM
Hi Marin

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

Regards
Gregory
Tags
Grid
Asked by
KobusVisagie
Top achievements
Rank 1
Answers by
Marin
Telerik team
KobusVisagie
Top achievements
Rank 1
Share this question
or