I am new to telerik controls and evaluating the telerik radgrid for one of our applications. We do use the grid in a number of places for server side binding but for this requirement I need to be able to build editable grid. Here are some features which I would like to achive.
1.I need to be able to perform client side binding of radgrid which calls a WCF method.
WCF method gets a stored proceure output that is cached in IIS, Filters the resultset based on some conditions and then returns the filtered list to the client. This binding call would be called once every 10 seconds using a timer to refresh the data on the grid.
2.Should be able to perform inline editing of the radgrid and inline adding of new row. During edit/insert mode, the timer that calls grid refresh would be disabled. I need to be able to call cusom WCF methods for actual add/update and delete operations. These WCF methods inturn would call some sql stored procs. Can I use radgrid_oninsert, radgrid_ondelete and radgrid_onupdate server side event handlers for add/update/delete operations ?
Not sure if these would work as my binding of grid is done on the client side. If this does not work, then how do I achive this kind of inline editing on the client side ?
3.Ability to perform edit/delete operations based on some conditions. Most likely I'll have a "Editable" column in data. This column won't be bound to the grid but I should be able to use the value to decide if edit/delete options should be allowed for the row.
If the value of this column is "false" then edit/delete options should be disabled for the corresponding row in the grid.
4.In edit mode(as well as add new row) , some of columns a)would be free text(text boxes), b)dropdownlists c)textbox with autocomplete ability and d)readonly columns.
5.If I were to perform server side binding and use inline editing features from the server side, then is there a way I can refresh the data on the grid every 10 seconds. This timer will be on the client side and I'll need to be able to call the binding routines of the server side from the client.
Appreciate if you could provide input and point me at some useful telerik tips to implement these requirements.
Thanks & appreciate your response.
1.I need to be able to perform client side binding of radgrid which calls a WCF method.
WCF method gets a stored proceure output that is cached in IIS, Filters the resultset based on some conditions and then returns the filtered list to the client. This binding call would be called once every 10 seconds using a timer to refresh the data on the grid.
2.Should be able to perform inline editing of the radgrid and inline adding of new row. During edit/insert mode, the timer that calls grid refresh would be disabled. I need to be able to call cusom WCF methods for actual add/update and delete operations. These WCF methods inturn would call some sql stored procs. Can I use radgrid_oninsert, radgrid_ondelete and radgrid_onupdate server side event handlers for add/update/delete operations ?
Not sure if these would work as my binding of grid is done on the client side. If this does not work, then how do I achive this kind of inline editing on the client side ?
3.Ability to perform edit/delete operations based on some conditions. Most likely I'll have a "Editable" column in data. This column won't be bound to the grid but I should be able to use the value to decide if edit/delete options should be allowed for the row.
If the value of this column is "false" then edit/delete options should be disabled for the corresponding row in the grid.
4.In edit mode(as well as add new row) , some of columns a)would be free text(text boxes), b)dropdownlists c)textbox with autocomplete ability and d)readonly columns.
5.If I were to perform server side binding and use inline editing features from the server side, then is there a way I can refresh the data on the grid every 10 seconds. This timer will be on the client side and I'll need to be able to call the binding routines of the server side from the client.
Appreciate if you could provide input and point me at some useful telerik tips to implement these requirements.
Thanks & appreciate your response.
2 Answers, 1 is accepted
0
Hello cha,
In-line editing is not supported for client-side bound grid out-of-the-box. However if you strictly desired to bind the grid client-side, you can try the approach illustrated in this demo.
In order to achive your goal, I would suggest that you bind the grid server-side through the NeedDataSource event. Then you would be able to use the grid built-in column which would display the desired field editors in edit mode. Then you can handle the ItemCommand or InsertCommand/UpdateCommand/DeleteCommand respectively to perform the data operations manually.
Regarding the timer: You can use ASP:Timer which will fire its Tick server-side event. There you can rebind the RadGrid to display new data. You can also use its Enable property to disable it on the server. And to avoid postback, you can ajaxify the Timer and the RadGrid with RadAjax.
Best wishes,
Iana
the Telerik team
In-line editing is not supported for client-side bound grid out-of-the-box. However if you strictly desired to bind the grid client-side, you can try the approach illustrated in this demo.
In order to achive your goal, I would suggest that you bind the grid server-side through the NeedDataSource event. Then you would be able to use the grid built-in column which would display the desired field editors in edit mode. Then you can handle the ItemCommand or InsertCommand/UpdateCommand/DeleteCommand respectively to perform the data operations manually.
Regarding the timer: You can use ASP:Timer which will fire its Tick server-side event. There you can rebind the RadGrid to display new data. You can also use its Enable property to disable it on the server. And to avoid postback, you can ajaxify the Timer and the RadGrid with RadAjax.
Best wishes,
Iana
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
0
cha
Top achievements
Rank 1
Rank 1
answered on 17 Mar 2011, 01:40 PM
Thanks Lana. Appreciate your help. I'm planning to use the server side binding for this application.