[Solved] Data entry with database update after each control update

[Terry Kargel]

I've been asked to create a webpage to implement single record data view/edit against a SQL Server 2005 database. A key requirement is that the database be updated every time a control is updated (no "Save" or "Apply" buttons). I was told that the Telerik RadControls For ASP.NET AJAX product was purchased to accomplish this requirement. This is my first use of AJAX and any Telerik products. What I'm looking for is guidance on how best to implement this type of page (advice, samples, demos, tutorials, etc).

My initial impulse would be:
* add unbound rad controls to a RadAjaxPanel
* write "FillForm" code to populate the controls from a stored proc via a DataReader
* execute "FillForm" on every PageLoad (to reflect current state of database)
* set all controls to AutoPostBack
* update the database on each PostBack

Is this a viable plan or should I be using some kind of databinding or grid control? Any help for an AJAX newbie is appeciated.

[Sebastian]

Hello Terry,

This might be one possible approach to accomplish your task. Another solution would be to use our web grid for this purpose and switch the grid items in edit mode initially as presented in these examples:

http://www.telerik.com/help/aspnet-ajax/grddefaulteditmodeforgriditemsoninitialload.html
http://www.telerik.com/help/aspnet-ajax/grdperformingbatchupdates.html

http://demos.telerik.com/aspnet-ajax/calendar/examples/datepicker/shareddatepicker/defaultcs.aspx?product=grid

Kind regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Joni Jeff]

It's great! Thanks for sharing.